Question Problems after switching cache type

[Home Alone]

I switched my cache from memcache to xcache this morning and vboptomise stopped working. I uninstalled then reinstalled and it started working again. All the system checks passed. After about 10 minutes the load on the mysql server skyrocketed and when I checked I saw hundreds of the following processes and each process was taking 20 - 30 seconds to run:

SELECT DISTINCT eventid, actionid, currencyid FROM credits_transaction

I changed the cache type back to memcache and this problem went away. Any idea why this would happen?

 

[Fillip H.]

I can't say that I do have any idea, no. Those seem entirely unrelated to me =/

If Memcache works better for you then I'd suggest to stick to it