![]() ![]() The goal is to significantly improve the performance of searches on the MyISAM table You clearly stated you goal in the question ![]() Thread_handling one-thread-per-connection The following are my settings: connect_timeout 10 The size of the tables in MB: data_size index_size total engine The goal is to significantly improve the performance of searches on the MyISAM table. Without load the queries take about 500ms to run. The server has a max_connection value of 800, under load test of about 300 concurrent users the query time starts to increase significantly. Much read only and used by user for searches. ![]() There are about 100 other innodb tables on the same database. I have a 16G server dedicated to MySQL with 1 MyISAM table with about 2 million rows that gets a significant amount of traffic. ![]() I need to performance tune a mysql server and need help.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |