473,511 Members | 14,393 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql eating too much cpu

Greetings. I have scoured through usenet to find out how to help my
server.Here are my specs
Dual P4 2.8G
2GB Ram
Redhat Ent. Linux 3 ES
mysql verson 3.23.58

Here is what I have in my /etc/my.cnf (I found these settings in a
usenet forum)

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = thread_cache=128
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
set-variable = key_buffer=784M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I often see the cpu usage above 80% when running top. Can someone
suggest what I need to tweak in order to help this poor server out? I
run a clan website for gaming and rarely have more than 100 people on
at a time, most times it is less than 50.

I am not a mysql guru, I am a network guy, so be gentle.

Thank you!

Feb 15 '06 #1
0 1291

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3401
by: Kerry Shetline | last post by:
I've successfully installed MySQL and the Perl DBI module, but when I try to install DBD::mysql, it keeps failing like this: -------------------- (from the CPAN shell) --------------------- .......
2
3967
by: Alan Hewat | last post by:
I have a relatively modest mySQL database with a PHP interface (70,000 entries). On a standard Dell Dimension 4400 (1.9 GHz with 512 Mbytes) running Suse 8.1 a typical query takes 0.66 sec with no...
3
1993
by: Bobby Torkington | last post by:
Hi all I'm running version 4.0.16 on solaris 8 as the backend for a web site serving around 12 million pages impressions a month. The performance of the server is monitored using orcollator. ...
33
5505
by: Joshua D. Drake | last post by:
Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake
3
1621
by: timtos | last post by:
Hi. I have to use a database in my c# program. For that I created a MySqlManager class. If it is being instanciated a connection will be established like this: odbcConnection = new...
20
1965
by: Vincent V | last post by:
Hey guys im about to start a large project and am wondering what DB server to use I have the Choise of MySql(innodb) or if i pay a bit extra i can get MS SQL 2000 The concerns i have -What type...
2
1060
by: Bob | last post by:
I'm sure some of you are familliar with PTFB... http://www.bobos.demon.co.uk/par/PTFB.htm it's a wonderful little app that answers dialogue box questions for you when they pop up. I have...
2
8245
by: speralta | last post by:
My tired old eyes may be failing me, but the following insert statements look correct to me, but I can't seem to get a clean insert from a fairly large text file database into mysql. I was...
6
38453
Atli
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get...
0
7251
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7148
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7430
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7089
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7517
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5673
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5072
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3230
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3217
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.