Results 1 to 2 of 2
-
20th Jun 2009, 08:07 AM #1OPMember
How to optimize mysql
i checked vi /etc/my.cnf
the contents are
[mysqld]
set-variable = max_connections=500
safe-show-database
I already searched about my sql tuner etc.
but where is the following located
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
. In my my.cnf file there is no such things.
some one pls help me.
in my server around 150 online. server is
intel i7 920 , 8gb ram. now almost 82% of ram is used.
someone pls help mevgnheart Reviewed by vgnheart on . How to optimize mysql i checked vi /etc/my.cnf the contents are set-variable = max_connections=500 safe-show-database I already searched about my sql tuner etc. Rating: 5
-
20th Jun 2009, 10:59 AM #2
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Optimize MySQL - MySQLTuner
By Sp32 in forum Tutorials and GuidesReplies: 30Last Post: 18th Jun 2012, 05:21 PM -
[Hiring] Someone to optimize Mysql
By samipk in forum Completed TransactionsReplies: 3Last Post: 19th Jul 2011, 09:01 PM -
Need Help to Optimize VPS WHM + Vbulletin 4
By blackpaper in forum Server ManagementReplies: 5Last Post: 7th Mar 2011, 07:09 AM -
mysql usage 99.8%|Site Not Loading|Please help to optimize
By raj1126 in forum Technical Help Desk SupportReplies: 18Last Post: 11th Nov 2010, 05:59 AM -
HOW TO: Secure and Optimize your VPS
By Storming in forum Technical and Security TutorialsReplies: 9Last Post: 25th Nov 2009, 04:11 PM
themaCreator - create posts from...
Version 3.22 released. Open older version (or...