mysql crashes - MySQL Database

Miguel Perez

Hi Guys:

Does anyone know how come I'm getting a lot of mysql processes when I start
mysql server for the first time.

When I type top it showed the following:

5:33pm up 15 min, 4 users, load average: 0.16, 0.19, 0.10
80 processes: 79 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.1% user, 0.2% system, 0.0% nice, 99.2% idle
CPU1 states: 0.1% user, 2.4% system, 0.0% nice, 96.4% idle
CPU2 states: 5.3% user, 0.1% system, 0.0% nice, 94.0% idle
CPU3 states: 28.3% user, 3.4% system, 0.0% nice, 67.2% idle
Mem: 2065160K av, 1028956K used, 1036204K free, 0K shrd, 12964K
buff
Swap: 2096440K av, 0K used, 2096440K free 226252K
cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
715 mysql 15 0 627M 627M 2328 S 0.1 31.1 0:02 mysqld-max
722 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
723 mysql 20 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
724 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
725 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
726 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
746 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
747 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
752 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
753 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
774 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
784 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
788 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
789 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
795 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
858 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
862 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
867 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
889 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
899 mysql 16 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
908 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
914 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:04 mysqld-max
967 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
1652 mysql 15 0 627M 627M 2328 S 0.0 31.1 0:00 mysqld-max
Thanks in advanced and I hope someone can help me.
Greetings

_______________ _______________ _______________ _______________ _____
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
http://photos.msn.es/support/worldwide.aspx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1

Subscribe Reply

1761

Similar topics

1717

problem with mysql-crashes

by: thomas-lists | last post by:

Hey folks, before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x5e13a478 is invalid pointer thd->thread_id=2223573

MySQL Database

771

MySQL crashes (sometimes) on large query

by: Matt Weakly | last post by:

Greetings: My MySQL (4.1.0 alpha) server crashes while processing large queries from a web page (using ColdFusion 5.0): ODBC Error Code = S1000 (General error) Lost connection to MySQL server during query The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (178:2) to

MySQL Database

3481

MySql reading BYTE datatype as String in Java

by: Dan | last post by:

Hello. I have recently tried upgrading the MySql connector for my servlet from 2.0.4 to 3.0.9. I have found a minor limitation in 2.0.4 and was hoping that 3.0.9 would fix it. However, now I am having a serious problem with the latest connector. During login, it seems to me that when validating the password, which is stored as a byte array in the database, the MySql connector is passing back the password info as a Byte. The...

MySQL Database

2034

mySQL vs Oracle, no problem?

by: Jan Olsen | last post by:

We're planning an SQL-based solution, possibly mySQL for Windows or Linux. But some in the organization might favor Oracle. Are there any particular pitfalls of using mySQL instead of Oracle? I'm a novice when it comes to evaluting different SQL solutions. We expect to have maximum 10 million records for our largest table, and perhaps 50 different small tables of up to 1 million records each. Uncompressed, the system will use no more...

MySQL Database

1562

MySQL client crashes with segmentation fault on Red Hat Linux Enterprise IA64

by: john.leonard.ireland | last post by:

Hi all, I don't know what I'm missing here, but if anyone could help me out I'd really appreciate it. Basically, everything is fine, compiles, installs, server runs, but the interactive mysql client breaks. I have an IA64 Red Hat Linux Enterprise Edition system and I tried to install the binaries recommended on MySQL. However, when I run the mysql client, I get simply:

MySQL Database

8392

DB2 v MySql

by: Mairhtin O'Feannag | last post by:

Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort of stammering and sputtering, and managed to pull out something I heard a couple of years back - that there was no real transaction safety in MySql. In flight transactions could be lost.

DB2 Database

110

10545

MyISAM engine: worst case scenario in case of crash (mysql, O/S,hardware, whatever)

by: alf | last post by:

Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst case scenario for MyISAM backend? Also is it possible to not to lose data but get them corrupted?

MySQL Database

2451

MySQL crashes during request

by: max_mont | last post by:

Hi, I'm working on MySQL 5.0 on Windows XP. I've tested a request on MSAccess and it's working. But if I launch it under MySQL, the PC crashes and I have to restart server. this is the request : SELECT * From bd_resultat.Valeurs_Entree Where Ve_Pa_Id = 147 and Ve_Val ='NO_OUTIL' and Ve_Groupe IN (SELECT Ve_Groupe From bd_resultat.Valeurs_Entree Where Ve_Pa_Id = 148 and Ve_Val ='FIB' and Ve_Groupe IN (SELECT Ve_Groupe From...

MySQL Database

4789

C# Console (exe) application crashes on open command (MySql)

by: Kurt Jakobsen | last post by:

Hi, I have problem opening an MySql connection from an win console application. I am using SharpDevelop as IDE. Previously I've been working with MySql through C# aspx and am new to writing exe programs in C#, so I assume that I might be missing something in the IDE / project configuration. I am successfully opening a connection and reading data from the table using adapter (window panel application binding to a grid), but when trying the...

MySQL Database

8249

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8685

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8633

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

8348

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8493

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

6112

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5570

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4084

Trying to create a lan-to-lan vpn between two differents networks

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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2613

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp