Results 1 to 10 of 26
Threaded View
-
27th Apr 2010, 11:17 PM #2Respected Member
It is suggesting these changes:
Variables to adjust:
query_cache_size = 20M
join_buffer_size = 2.0M
tmp_table_size = 48M
max_heap_table_size = 48M
table_cache = 6192
innodb_buffer_pool_size = 32M
also add:
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Public Rapidleech-Need help optimizing apache and php for performance of VPS
By Enigmatic in forum Server ManagementReplies: 1Last Post: 29th Sep 2011, 03:54 PM -
Public Rapidleech-Need help optimizing apache and php for performance of VPS
By Enigmatic in forum Technical Help Desk SupportReplies: 9Last Post: 29th Sep 2011, 03:40 PM -
Need help optimizing apache and php for performance of VPS for Public Rapidleech
By Enigmatic in forum Web Application/Script SupportReplies: 1Last Post: 29th Sep 2011, 02:27 PM -
Automatic reboot Apache and Mysql every x min, possible?
By DoctorX in forum Server ManagementReplies: 10Last Post: 8th Jul 2011, 03:36 PM -
Optimizing MySQL (Linux with DirectAdmin)
By Lease in forum Technical and Security TutorialsReplies: 0Last Post: 8th Jan 2008, 08:57 AM
themaCreator - create posts from...
Version 3.52 released. Open older version (or...