>Like I said in OP, we've identified MySQL to be the primary bottleneck and are already working on resolving this.
Ah, yes. I remember from your prior post that you have very large databases and table sizes and are considering (or have begun) partitioning the largest tables. It turns out there is an innate partitioning scheme built into the most recent MySQL versions, but it has to be compiled into the running binary by way of a compiler flag:
Yes, we did investigate MySQL's internal partitioning option briefly before deciding to roll our own scheme (which, after working quite well initially, is now beginning to create problems of its own).
Perhaps, it is time for us to revisit this. Thanks again Paul.
Like I said in OP, we've identified MySQL to be the primary bottleneck and are already working on resolving this.
>whose transactions are abandoned.
At least some saving grace here... we're not selling anything... it is purely a content site
Thanks for your input.