Due to my tests it works approximately 30 times faster. It will be great, if you share your experience with me.
In order to select alternative method of all sites update add this line to you blog file Starting from version 2.2 plugin works with Word Press 3.0 and higher only.
It should be safe to follow these recommendations To find out more information on how each of these runtime variables effects performance visit: info about My SQL's Enterprise Monitoring and Advisory Service SLOW QUERIES The slow query log is NOT enabled. You have 0 out of 12312036 that take longer than 10.000000 sec.
to complete Your long_query_time seems to be fine BINARY UPDATE LOG The binary update log is NOT enabled. MEMORY USAGE Max Memory Ever Allocated : 650 M Configured Max Per-thread Buffers : 2.70 G Configured Max Global Buffers : 320 M Configured Max Memory Limit : 3.02 G Physical Memory : 2.00 G Max memory limit exceeds 90% of physical memory KEY BUFFER Current My ISAM index space = 52 M Current key_buffer_size = 256 M Key cache miss rate is 1 : 1710 Key buffer free ratio = 74 % Your key_buffer_size seems to be fine QUERY CACHE Query cache is enabled Current query_cache_size = 64 M Current query_cache_used = 29 M Current query_cache_limit = 1 M Current Query cache Memory fill ratio = 45.79 % Current query_cache_min_res_unit = 4 K My SQL won't cache query results that are larger than query_cache_limit in size SORT OPERATIONS Current sort_buffer_size = 2 M Current read_rnd_buffer_size = 12 M Sort buffer seems to be fine JOINS Current join_buffer_size = 132.00 K You have had 225 queries where a join could not use an index properly You should enable "log-queries-not-using-indexes" Then look for non indexed joins in the slow query log.
You should invest more time in understanding the question rather than using your copy&paste skills with a hope that it [email protected] the dead lock "Waiting for query cache lock" is usually coming from write contention on the query cache, because it's too big and mysql spend more time to invalidate that cache, and therefore reducing the size of the cache to the lowest performing value is the way to go.For earlier Word Press versions use plugin version 2.1.10 I am ready to answer on your questions about this plugin usage and help with possible problems.Use User Role Editor plugin forum or this page comments and site contact form for that please.Platform: , with only difference in that the post-processed data is stored using separate INSERT and UPDATE queries rather than INSERT ON DUPLICATE KEY UPDATE.My SQL configuration (on both the Debian 6 and 7 machines): Try to reduce the query cache size significantly. Start with 16M or 32M and adjust the query_cache_limit accordingly (256K?