high usage in mysql

morteza3245

• May 30, 2014 01:25

Hello, today i saw my mysql server had high usage, you can see below picture: .vB and my.cnf value is: [QUOTE][mysqld] myisam_use_mmap=1 open_files_limit=100000 local-infile=0 tmp_table_size=50M key_buffer_size=5G join_buffer_size=1M query_cache_limit=1M innodb_file_per_table=1 read_rnd_buffer_size=2M max_heap_table_size=50M slow_query_log_file=mysql-slow.log query_cache_size=50M long_query_time=0.1 table_definition_cache=2500 slow_query_log=1 query_cache_type=1 innodb_buffer_pool_size=200M table_open_cache=5000 thread_cache_size=30 max_allowed_packet=32M default-storage-engine=MyISAM
Please help me how i can resolve this issue? my Load is normall on 1 ~ 2

• 

  nixuser

  • May 30, 2014 08:55

  run mysqltuner in your server.

  0
• 

  cPanelMichael

  • May 30, 2014 13:34

  Hello :) You should let MySQL run for at least 24 hours and then run the MySQL tuner to get more user-feedback. The following thread is a good place to start: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0
• 

  morteza3245

  • May 31, 2014 19:12

  i did run mysqltune already and did config with result of mysqltune already, Can you let me know how i can let MySQL run for at least 24 hourse? Please explain. Thanks. [COLOR="silver">- - - Updated - - - i did run mysqltune already and did config with result of mysqltune already, Can you let me know how i can let MySQL run for at least 24 hourse? Please explain. Thanks.

  0
• 

  cPanelPeter cPanel Staff

  • June 01, 2014 13:36

  Hello, By letting it run for 24 hours (or more) it's just meant to not restart or stop mysql. Let it run without interruption and then run MySQLTuner on it and that will give you some results that you can then act upon.

  0

Please sign in to leave a comment.