Results 1 to 10 of 19
Threaded View
-
11th Nov 2010, 05:59 AM #19Member
[mysqld]
datadir =/var/lib/mysql
socket =/var/lib/mysql/mysql.sock
log_slow_queries =/var/log/mysql/mysql-slow.log
port = 3306
skip-locking
max_connections = 200
key_buffer = 16M
myisam_sort_buffer_size = 32M
table_cache = 1024
thread_cache_size = 512
join_buffer_size = 2M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 512K
net_buffer_length = 256K
thread_stack = 256K
tmp_table_size = 16M
query_cache_limit = 2M
query_cache_size = 16M
query_cache_type = 1
thread_cache_size = 256
thread_concurrency = 4
long_query_time = 2
skip-bdb
skip-innodb
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
#safe-updates
[mysqld_safe]
open_files_limit = 8192
[isamchk]
key_buffer = 16M
sort_buffer_size = 16M
read_buffer = 16M
write_buffer = 16M
[myisamchk]
key_buffer = 16M
sort_buffer_size = 16M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
[client]
socket=/path/to/mysql.sock
Try this for 512 Memory
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
optimize my site
By kkrajdurai in forum Technical Help Desk SupportReplies: 12Last Post: 12th Jul 2012, 09:08 PM -
Optimize MySQL - MySQLTuner
By Sp32 in forum Tutorials and GuidesReplies: 30Last Post: 18th Jun 2012, 05:21 PM -
[Howto] Optimize Your Site With GZIP Compression and cache
By EW-Team in forum Tutorials and GuidesReplies: 12Last Post: 14th Mar 2012, 02:23 PM -
[Hiring] Someone to optimize Mysql
By samipk in forum Completed TransactionsReplies: 3Last Post: 19th Jul 2011, 09:01 PM -
How to optimize mysql
By vgnheart in forum Server ManagementReplies: 1Last Post: 20th Jun 2009, 10:59 AM
themaCreator - create posts from...
Version 3.53 released. Open older version (or...