Results 1 to 4 of 4
Thread: Optimize my.cnf?
-
04-18-2005, 01:29 PM #1Web Hosting Guru
- Join Date
- Jan 2005
- Posts
- 268
Optimize my.cnf?
what is the best way to optimize my.cnf ?
my server is Xeon 2.8ghz + 1gb ram. OS Centos and cpanel. There is only 3 sites in there, 1 is forums other is download site. At peak time, there are around 300 active users online. I have search around but those optimize do not work for my server. Last night my server load was 100, somehow the mysql load too much ( i think) . Thank guys
p/s: last night, there were over 1050 processes, and 1046 running...Last edited by AndyJ; 04-18-2005 at 01:33 PM.
-
04-18-2005, 02:20 PM #2Junior Guru Wannabe
- Join Date
- May 2004
- Posts
- 66
why dont you put here the configuration you are putting , and also a snap shot from the command
mysqladmin proc
and also
mysqladmin status
-
04-18-2005, 03:09 PM #3Web Hosting Guru
- Join Date
- Jan 2005
- Posts
- 268
mysqladmin process
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| 2824 | eximstats | localhost | eximstats | Sleep | 3364 | | |
| 35397 | root | localhost | | Query | 0 | | show processlist |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
mysqladmin status
Uptime: 29729 Threads: 2 Questions: 478947 Slow queries: 304 Opens: 424 Flush tables: 1 Open tables: 172 Queries per second avg: 16.110
my.cnf
[mysqld]
set-variable = max_connections=350
safe-show-database
port=3306
socket=/tmp/mysql.sock
skip-locking
connect_timeout=15
key_buffer=16M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
thread_cache_size=286
max_allowed_packet=5M
wait_timeout=15
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=2
-
04-18-2005, 03:14 PM #4Web Hosting Master
- Join Date
- Dec 2001
- Location
- NYC, NY
- Posts
- 799
its not a my.cnf issue.. its bad database layout for your clients
Blog your life away
http://photoblog.com