Edit History

Hi, generally speaking and from experience, no the hosting company will not support tuning of mysql unless the hosting package is fully managed and may not even then.

Login to phpMyAdmin
Go to your hosting control panel and launch phpMyAdmin.

Go to the "Status" or "Server Status" tab
This gives you live metrics. Look for values highlighted in red—these indicate areas where performance may be suboptimal.

Look for these key stats:

• Key buffer size – Important if using MyISAM tables.
• Query cache efficiency – If too low, consider disabling or tuning query_cache_size (note: query cache is deprecated in MySQL 5.7+).
• Temporary tables created on disk – If this number is high, increase tmp_table_size and max_heap_table_size.
• Sorts using disk – If high, consider increasing sort_buffer_size.
• Table locks / Slow queries – May need innodb_buffer_pool_size tuning or indexing.