Re: Load avg is 65 and cpu is 100% on mysqld
Indexes looks good, when I execute the same select query I get the result in 1 sec. So as the updates and inserts. I'm only startled on load avg and cpu utilization.
mysql> show global status like '%tmp%'; -> I also suspect this guy, when disktables are more during selects and updates on the same table.
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Created_tmp_disk_tables | 740 |
| Created_tmp_files | 12 |
| Created_tmp_tables | 1820 |
+-------------------------+-------+
3 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE '%tmp%'; -> looks like min is more than max that is set.
+-------------------+------------+
| Variable_name | Value |
+-------------------+------------+
| max_tmp_tables | 32 |
| slave_load_tmpdir | /tmp |
| tmp_table_size | 1073741824 |
| tmpdir | /tmp |
+-------------------+------------+
mysql> SHOW VARIABLES LIKE '%buffer%';
+------------------------------+-------------+
| Variable_name | Value |
+------------------------------+-------------+
| bulk_insert_buffer_size | 8388608 |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_size | 12884901888 |
| innodb_change_buffering | all |
| innodb_log_buffer_size | 8388608 |
| join_buffer_size | 1073741824 |
| key_buffer_size | 8388608 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| preload_buffer_size | 32768 |
| read_buffer_size | 33554432 |
| read_rnd_buffer_size | 1073741824 |
| sort_buffer_size | 1073741824 |
| sql_buffer_result | OFF |
+------------------------------+-------------+
Qcache_hits: 199188
Qcache_inserts: 5963443
Qcache_not_cached: 7814584
--> innodb_flush_log_at_trx_commit = 2, but ideally 1 should be fine right to commit whenever any inserts or updates issued on auto-commit mode?
Subject
Views
Written By
Posted
2204
June 20, 2012 05:26AM
1018
June 21, 2012 12:38AM
Re: Load avg is 65 and cpu is 100% on mysqld
1026
June 21, 2012 11:12PM
1086
June 23, 2012 02:06PM
1044
June 24, 2012 12:37AM
1073
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.