Results 1 to 10 of 10
-
05-09-2004, 08:11 PM #1Web Hosting Evangelist
- Join Date
- May 2002
- Location
- singapore
- Posts
- 455
mysql problem ... server load 20-50 help!
hi there ...
even after reboot and apache is shut down,
mysqld is using 60% of cpu resources and eating most of the RAM
any idea what went wrong? and how do i fix it?
mysql 147.71 131.07 0.0
Top Process %CPU 99.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/domain.mydomain.net.pid --skip-locking
Top Process %CPU 91.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/domain.mydomain.net.pid --skip-locking
Top Process %CPU 72.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/domain.mydomain.net.pid --skip-locking
thankscurrent and satisfied customer of softlayer.com and webnx.com
-
05-09-2004, 08:13 PM #2Web Hosting Master
- Join Date
- Jun 2003
- Location
- Indiana, US
- Posts
- 1,355
*edit*
-
05-09-2004, 08:14 PM #3Problem Solver
- Join Date
- Mar 2003
- Location
- California USA
- Posts
- 13,681
What does your /etc/my.cnf look like? what are the box specs?
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
-
05-09-2004, 08:15 PM #4Web Hosting Evangelist
- Join Date
- May 2002
- Location
- singapore
- Posts
- 455
thelinuxguy
it's default setup ... it was fine until few days ago ...current and satisfied customer of softlayer.com and webnx.com
-
05-09-2004, 08:17 PM #5Web Hosting Evangelist
- Join Date
- May 2002
- Location
- singapore
- Posts
- 455
thelinuxguy,
would you be able to fix it for me? if yes which one of your service shoudl i get?current and satisfied customer of softlayer.com and webnx.com
-
05-09-2004, 08:17 PM #6Problem Solver
- Join Date
- Mar 2003
- Location
- California USA
- Posts
- 13,681
what is the server specs?
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
-
05-09-2004, 08:18 PM #7Web Hosting Evangelist
- Join Date
- May 2002
- Location
- singapore
- Posts
- 455
it's athlon 2400 ... 1gb ram
current and satisfied customer of softlayer.com and webnx.com
-
05-09-2004, 08:19 PM #8Problem Solver
- Join Date
- Mar 2003
- Location
- California USA
- Posts
- 13,681
[mysqld]
skip-locking
key_buffer=16M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
max_connections=250
thread_cache_size=286
max_allowed_packet=5M
connect_timeout=15
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=2
wait_timeout=15Steven 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
-
05-09-2004, 08:25 PM #9Web Hosting Evangelist
- Join Date
- May 2002
- Location
- singapore
- Posts
- 455
it doesnt help ... still sky high
current and satisfied customer of softlayer.com and webnx.com
-
05-09-2004, 08:32 PM #10Web Hosting Master
- Join Date
- Nov 2002
- Posts
- 2,780
try reindex the whole database,
then do a mysqlcheck -rao on the Dbs,http://Ethr.net jay@ethr.net
West Coast AT&T / Level3 / Savvis Bandwidth, Colocation, Dedicated Server, Managed IP Service, Hardware Load Balancing Service, Transport Service, 365 Main St, SFO / 200 Paul Ave, SFO / PAIX, PAO / Market Post Tower, 55 S. Market, SJC / 11 Great Oaks, Equinix, SJC