0
votes
0answers
36 views

Find out what process initiated a mysql query

Is there any way to trace back what process initiated a mysql uqerry like the two below. MySQL on localhost (5.0.95-log) up 178+23:58:01 ...
0
votes
1answer
31 views

MySQL Process Big

Ok, so I don't know if this is a repeat question so I'm sorry if it is (I couldn't find anything like it after searching =/) My server seems to be running what seems to me a larger than normal mysql ...
0
votes
0answers
51 views

SQL, Installation process, my.ini

Recently i decided to install apache + php + mysql separately from each other instead using one of the packets such as wamp,xampp,zend server,etc..., So far i installed apache server with php engine, ...
1
vote
3answers
1k views

Is there a way to automatically restart MySQL, if it takes up too much processing power?

Due to some bad scripting on my part, MySQL sometimes goes haywire - taking up a lot of CPU power (load average of more then 20 - I only have 8 cores)! When I restart it is all good again. So my ...
0
votes
0answers
74 views

Why is my mysqld being aborted when I connect to it with a client ?

I am installing mysql-5.5.7rc from source. After the installation I start the mysqld service, but as soon as I run the mysql client service, the mysqld service gets aborted. Also mysql_install_db is ...
0
votes
3answers
281 views

throttle cpu usage for a cronjob

I've got a cronjob that is basically nothing more than mysqldump whatever | gzip > backup.sql.gz. The database is fairly big. I've noticed that while the job is running, my apache is much less ...
0
votes
1answer
67 views

Mysql multi request at same time

I have a Ubuntu-server. It is running Mysql & Apache. I have several request at same time. I I saw processes, by top command. I have 10 Apache process and always one process for Mysql. I ...
1
vote
1answer
285 views

What happens when you kill a process that has database tables locked?

Trying to kill a process that running a MySQL database backup, and has the tables locked. What will happen if I kill the process?
0
votes
1answer
57 views

How can i see what is locking up a table? [duplicate]

Possible Duplicate: “Delete query” not able to be completed I am trying to delete a single row from the db, but it is not completing,even in 20 minutes.There is no other ...
2
votes
1answer
1k views

Lots of NULL processes in MySQL

Since last week without a particular reason my website started to drastically slow down. I logged into MySQL and run show processlist which resulted in something like this: mysql> show full ...
0
votes
1answer
265 views

[Unix]How do I know this particular mysql process belong to what process on `show processlist`

As stated on question's title, I ran into situations and I need to check something. Here's the condition. When I do top, I see mysql process with ID, say 1234. But, when I execute show processlist ...
1
vote
3answers
88 views

Why one process is taking so many resources

My website is being very slow or non-responsive. A quick look at the top command shows me something like this: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1709 mysql 20 ...