Load avg is 65 and cpu is 100% on mysqld
Load avg is huge but all selects are treated immediate and updates are committed soon.
I don't see any issues on indexing of tables or selects. But I suspect something has to be done for the below status. Any suggestion would be of great help. Today morning we migrated from 5.0 to 5.5.25 with row bin logs enabled. And now the perf sucks. Kindly suggest where to fine tune..
mysql> SHOW status LIKE 'qcache%';
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 1070253896 |
| Qcache_hits | 42362 |
| Qcache_inserts | 1275394 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1433302 |
| Qcache_queries_in_cache | 2805 |
| Qcache_total_blocks | 5618 |
+-------------------------+------------+
8 rows in set (0.10 sec)
Edited 1 time(s). Last edit at 06/20/2012 05:26AM by Mannoj Kumar.
Subject
Views
Written By
Posted
Load avg is 65 and cpu is 100% on mysqld
2202
June 20, 2012 05:26AM
1018
June 21, 2012 12:38AM
1026
June 21, 2012 11:12PM
1085
June 23, 2012 02:06PM
1044
June 24, 2012 12:37AM
1072
June 24, 2012 04:37AM
1021
June 25, 2012 08:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.