the fee is 0.09 USD, what will happen to this transaction now? will it every processed? How long it might take? just interesting
Ignore the dollar value of the fee, focus on sats per vbytes , you pay fees based on the size of your transaction, but since there is a limited block size, all that matters is how much you are willing to pay for every byte you use in that block, OP just so happened to be pretty unlucky because on the 13th ( a day before he broadcasted his transaction) the mempool size ( there is actually no "THE" in mempool but for sake of simplicity) was at an average of 2MB, the average bitcoin transaction is about 250 bytes so roughly 8000 transaction at any given time during that period, so supply is 1MB vs demand of 2MB as an average, in fact in some hours, there were fewer transactions than the block could fill, so miners would happily accept any transaction at the cheapest possible fee.
Fast forward the mempool size reached nearly 138MB on the 15th (most likely due to FTX crash, these black swans cause people to transact a lot, either those running away and selling or those who just bought what they call the dip, or those withdrawing their coins from exchanges to safer place).
Now since there is way more stuck transaction than the miners can handle, people are willing to pay them more, as I type I randomly checked and saw some transaction right now are paying over 140 sats per Vbyte vs 4 sats OP is paying, so he is going to have to wait until miners run out of those "expensive" transactions and then they will include his transaction.
The mempool is getting smaller and smaller as I type, and it's likely to shrink even more around Friday night then the 4 sat/vbyte transactions will become attractive again and his transaction will go through, if I had to throw a number at the wall I'd say 30 hours from writing this comment.
However, there is really no guarantee on how long one might need to wait, imagine for whatever reason people wake up tomorrow and decide to use bitcoin for daily payments and the average sat/vbyte doesn't drop below 10 sats, this transaction could be stuck forever
, of course, that's extremely unlikely to happen but one should always use a wallet that allows them to react when something like this happens if OP has access to the PKs he could just use another wallet to broadcast the transaction again at higher fees, or -- he could just wait till the weekend.