473,786 Members | 2,615 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

99.9% mysqld Utilization Problem

all,

i have seen a couple of postings on the following issues which i have
encountered and have struuggled with for a couple of days now.
i apologize in advance if someone has already posted the resolution and i
missed it.

Problem Description:
on a Dual i386 Architecture with RH9, MySQL 3.23.54a-11 (or its .56 upgrade)
under heavy loads the mysqld process reaches 99.9% CPU Utilization (as
viewed using top)
and a second daemon is never forked and the database hangs.
some people have indicated they need to kill -9 mysqld (although i do not
have that problem).

specifically my rig has:
- two P3/866
- 1GB RAM
- have successfully upgraded to MySQL 3.23.56 using the RPMs
- have sucessfully copied my-large.cnf settings to /etc/my.cnf
- am using Mantis Bug Tracker (PHP) to connect
- have Apache 2 that comes with RH9
- have 600 global users reporting problems but heavy load is about 10-20
concurrent

this is my first Dual-RH server.
previously, i have used all single processor P2, P3, & P4.

can anyone shed some light on possible next steps.
i would hate to have to pull production back to a Single Proc after having
built a Dual and really do NOT want to even think about Win32 option.

any help appreciated!

- Alex
Jul 19 '05 #1
0 1382

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

Similar topics

0
7533
by: Stephane Raimbault | last post by:
I've been searching the mailing list for a solution to my problem with "mysqld got signal 11;" and I haven't seen any answers that might help me. This is the situation. I have a db that is being accessed intensively about 400 connections during the wee at a time. I noticed the problem at first with 4.0.13 and tried 3.23.57 and now 4.0.14 with the same problem. I've run the db on FreeBSD 5.1 and 4.8, again same problem. This is what...
0
1282
by: Albert Rossi | last post by:
all, i have seen a couple of postings on the following issues which i have encountered and have struuggled with for a couple of days now. i apologize in advance if someone has already posted the resolution and i missed it. Problem Description: on a Dual i386 Architecture with RH9, MySQL 3.23.54a-11 (or its .56 upgrade) under heavy loads the mysqld process reaches 99.9% CPU Utilization (as
0
624
by: Gary Cote | last post by:
>Description: I've recently compiled mysql 4.0.14 on redhat 8.0. The installation fails, however, when running mysql_install_db. I've attached a transcript below. I gather from searching the 'net that this isn't an entirely unusual thing to happen, and is likely the result of some misconfiguration on my part, or perhaps a version incompatability with my libc. Unfortunately, I haven't seen any concrete suggestions on how to get past it.
3
5625
by: Paul | last post by:
I'm using ssh to administer a mysql server, version 3.23.49, which I just installed. The problem when starting mysqld: I type "mysqld" at the shell prompt and hit return, then I get the message "mysqld: ready for connections". But then it doesn't give me back the shell prompt. I can type stuff on the screen, but it doesn't do anything. I've tried Ctrl-C and Ctrl-Z, but that does nothing. Any ideas? Thanks. Paul
1
16813
by: Jeremy Kohansimeh | last post by:
Hello, I just installed version 4.0.21 on a Mandrake 8.2 system. I cannot get the MySql daemon to run. I am using the following commands, and receiving these errors: $mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/JBrain.pid 040921 09:01:55 mysqld ended
2
2298
by: Patrick Moore | last post by:
We have a SQL 7.0 Standard Server running on a Windows 2000 Server machine with 2 800mhz Pentium III with 2GB memory. Our front end is Access 97 and 2000 with most ADO connections for the scripts but some DAO for forms and reports. We recently "released" a new version of the "database" that caused a catastrophic event to start happening with our SQL server. Using PerfMon we monitored the CPU utilization on the server and noticed that...
0
1322
by: bimalendug | last post by:
Hi All, I'm using the .NET performance counters to calculate the network utilization. But this value exceeds 100%. In most of the cases, it is very similar to the one shown in the task-manager. But when I try to measure the network utilization with a particular utility that sends large data, then the values that I get exceed 100%. Even in the task-manager it shows similar graph (graph goes up above the 100% line and disappears and then...
1
1678
by: intheend | last post by:
respected when i start the mysqld it times out .. without starting service mysqld start time out when i give the command
1
6630
by: Kaheru | last post by:
memory utilization increase? This is because when i try to keep track of the CPU utilization and memory utilization of my FTP server process (ftpserver.exe), the CPU utilization increase, but the memory utilization decrease. Why is this happening? PS: CPU Utilization is taken from Process\% Processor Time Memory Utilization is taken from Process\Working Set (I want to measure the physical memory it uses) Any help is appreciated....
0
9496
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10164
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9961
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8989
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7512
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6745
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5534
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3669
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2894
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.