MySQL Forums
Forum List  »  Performance

Load avg is 65 and cpu is 100% on mysqld
Posted by: Mannoj Kumar
Date: June 20, 2012 05:26AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Load avg is 65 and cpu is 100% on mysqld
2202
June 20, 2012 05:26AM


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.