Results 1 to 2 of 2
-
04-09-2004, 12:24 AM #1Retired Web Hoster
- Join Date
- Apr 2003
- Posts
- 959
MySQL optimization for this kind of server
Hello,
Server Spec: Celeron 2.2Ghz + 512MB DDR Ram, IDE HDD, Fedora Linux 1, MySQL 4.0.18, Direct Admin
Only 1 site, PHP+MySQL Forum, PHP+MySQL Flash Guestbook
Code:[mysqld] #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock #skip-locking #skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=400 #interactive_timeout=100 wait_timeout=30 connect_timeout=15 thread_cache_size=128 key_buffer=32M join_buffer=1M max_allowed_packet=5M table_cache=1024 record_buffer=1M sort_buffer_size=2M read_buffer_size=2M max_connect_errors=10 thread_concurrency=2 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=20M sort_buffer_size=20M read_buffer=2M write_buffer=2M [myisamchk] key_buffer=20M sort_buffer_size=20M read_buffer=2M write_buffer=2M [mysqlhotcopy] interactive-timeout
Thanks
-
04-09-2004, 05:18 PM #2Problem Solver
- Join Date
- Mar 2003
- Location
- California USA
- Posts
- 13,681
[mysqld]
key_buffer=16M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
max_connections=250
thread_cache_size=128
max_allowed_packet=5M
connect_timeout=15
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=2
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[myisamchk]
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Try this config outLast edited by Steven; 04-09-2004 at 05:22 PM.
Steven Ciaburri | Industry's Best Server Management - Rack911.com
Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance