Tune Mysql
Dec 13, 2007
I am running on a VPS which so far seems to be great, but at times I see some pauses. I have been working to tune mysql and so far have seen some good improvements. I am confused some sample my.cnf's which show dedicated myisamchk buffers. Do the normal buffers not count?
My current VPS has 768MB of dedicated ram, and is on a new 8 way server utilizing virtuozzo. On Unix bench I receive between a 190 - 240.
I am running 3 sites, and only one of which has notable traffic. it is a phpBB2 site with 30-50 concurrent users. The database is roughly 300MB and 4million records.
As stated at times there seems to be pauses and I am unsure if is simple related to the nature of the VPS or if I have some tuning left to do. Below are the stats I have gathered and I can provide more information if needed.
I will say that query cache does not seem to benefit phpBB2 as I was only getting 1-2:1 hit ratio.
my.cnf:
Quote:
[mysqld]
max_connections = 120
table_cache = 500
key_buffer_size = 80M
join_buffer_size = 1M
read_rnd_buffer_size = 768K
thread_cache_size = 50
thread_concurrency = 2
safe-show-database
tuning-primer.sh:
Quote:
MySQL Version 4.1.22-standard i686
Uptime = 0 days 20 hrs 56 min 1 sec
Avg. qps = 7
Total Questions = 535268
Threads Connected = 5
Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations
To find out more information on how each of these
runtime variables effects performance visit:
[url]
SLOW QUERIES
Current long_query_time = 10 sec.
You have 996 out of 535280 that take longer than 10 sec. to complete
The slow query log is NOT enabled.
Your long_query_time may be too high, I typically set this under 5 sec.
WORKER THREADS
Current thread_cache_size = 50
Current threads_cached = 46
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 120
Current threads_connected = 4
Historic max_used_connections = 50
The number of used connections is 41% of the configured maximum.
Your max_connections variable seems to be fine.
MEMORY USAGE
Max Memory Ever Allocated : 292 M
Configured Max Per-thread Buffers : 486 M
Configured Max Global Buffers : 90 M
Configured Max Memory Limit : 576 M
Total System Memory : 768.00 M
Max memory limit seem to be within acceptable norms
KEY BUFFER
Current MyISAM index space = 117 M
Current key_buffer_size = 80 M
Key cache miss rate is 1 : 30980
Key buffer fill ratio = 70.00 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere
QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size
SORT OPERATIONS
Current sort_buffer_size = 2 M
Current record/read_rnd_buffer_size = 764 K
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 1.00 M
You have had 2779 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.
OPEN FILES LIMIT
Current open_files_limit = 1130 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 500 tables
You have a total of 204 tables
You have 438 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 45794 temp tables, 4% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Created disk tmp tables ratio seems fine
TABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 929 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 47
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
mysqlreport:
Code:
MySQL 4.1.22-standard uptime 0 20:57:20 Thu Dec 13 18:07:02 2007
__ Key _________________________________________________________________
Buffer used 50.00M of 80.00M %Used: 62.50
Current 59.10M %Usage: 73.87
Write hit 37.16%
Read hit 100.00%
__ Questions ___________________________________________________________
Total 536.23k 7.1/s
DMS 466.89k 6.2/s %Total: 87.07
Com_ 37.48k 0.5/s 6.99
COM_QUIT 31.83k 0.4/s 5.94
+Unknown 28 0.0/s 0.01
Slow 997 0.0/s 0.19 %DMS: 0.21
DMS 466.89k 6.2/s 87.07
SELECT 398.63k 5.3/s 74.34 85.38
UPDATE 43.35k 0.6/s 8.08 9.28
DELETE 17.53k 0.2/s 3.27 3.75
INSERT 7.38k 0.1/s 1.38 1.58
REPLACE 11 0.0/s 0.00 0.00
Com_ 37.48k 0.5/s 6.99
change_db 30.51k 0.4/s 5.69
show_status 2.11k 0.0/s 0.39
show_proces 2.08k 0.0/s 0.39
__ SELECT and Sort _____________________________________________________
Scan 192.22k 2.5/s %SELECT: 48.22
Range 12.28k 0.2/s 3.08
Full join 2.78k 0.0/s 0.70
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 79.22k 1.1/s
Sort range 29.26k 0.4/s
Sort mrg pass 1.13k 0.0/s
__ Table Locks _________________________________________________________
Waited 14.12k 0.2/s %Total: 2.08
Immediate 666.09k 8.8/s
__ Tables ______________________________________________________________
Open 438 of 500 %Cache: 87.60
Opened 452 0.0/s
__ Connections _________________________________________________________
Max used 50 of 120 %Max: 41.67
Total 31.83k 0.4/s
__ Created Temp ________________________________________________________
Disk table 1.95k 0.0/s
Table 45.86k 0.6/s
File 2.27k 0.0/s
__ Threads _____________________________________________________________
Running 1 of 4
Cached 46 of 50 %Hit: 99.84
Created 50 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 4 0.0/s
Connects 0 0/s
__ Bytes _______________________________________________________________
Sent 1.11G 14.7k/s
Received 182.99M 2.4k/s
View 14 Replies
ADVERTISEMENT
Mar 14, 2009
I'm interested in hiring someone to go through our Windows VPS and do a bit of a tune-up and investigation to check if everything is running as well as it should be.
In particular 95% of memory seems to be constantly used, mostly by perl.exe and I just want to be convinced that this isn't being caused by a problem somewhere, before I upgrade.
Just wondering if anyone provides this kind of service, or knows someone who does and is good? I'd prefer a recommendation rather than just handing over the administration login to anyone...
View 5 Replies
View Related
Mar 26, 2008
Does Internap "performance base" their routing in the upstream direction only (e.g. set LocalPref on received routes from their carriers), or also "optimize" routing for downstream traffic (e.g. set communities to force their carriers not to readvertise to certain other networks)?
View 1 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
View Related
Feb 11, 2008
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
View 2 Replies
View Related
Jan 17, 2008
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies
View Related
Jan 15, 2007
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View 11 Replies
View Related
Apr 15, 2009
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
View 14 Replies
View Related
Mar 28, 2007
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
View 2 Replies
View Related
Jun 13, 2007
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies
View Related
Dec 18, 2007
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
View 5 Replies
View Related
Jun 27, 2009
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
View 2 Replies
View Related
Jun 3, 2008
I'm trying to upgrade from MySQL 4 to MySQL 5 for performance reasons. MySQL 4 was working great so I decided to just go ahead and upgrade to MySQL 5 via CPanel. The upgrade appeared to go fine however I now get this error when trying to start MySQL.
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
I went ahead and did a forced re-install of MySQL 5, but that didn't help. Apache has been updated as well since then, but that did no good, and the MySQL process isn't starting at all.
Its CENTOS with PHP5.
View 1 Replies
View Related
Jun 21, 2007
I am not sure what difference between --with-mysql and --with-mysql=/usr to compile php 4.4.7
because I get error message when I use --with-mysql=/usr
the error message is like Mysql header can not be found or similar thing.
it ok when I use --with-mysql
so, I am afraid that can I use php and mysql without problem by using --with-mysql?
View 1 Replies
View Related
Jan 20, 2007
I'd like to upgrade my current mysql 4.1 version to mysl 5, but i can't find a good tutorial or explenation! I've been searching for hours now without any good results.
I've downloaded the lastest stable mysql 5 .rpm, and tried to install it with rpm -i mysql.version.rpm, but it says the following:
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
MySQL-server conflicts with mysql-server-4.1.20-1.RHEL4.1.i386
I guess that means i have to uninstall mysql 4.1 first.
ok...
# rpm -e mysql-server-4.1.20-1.RHEL4.1.i386
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Let's try to install it now.
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
Ok, let's remove that.
# rpm -e mysql-4.1.20-1.RHEL4.1.i386
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386
mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-devel-4.1.20-1.RHEL4.1.i386
Does upgrade work?
# rpm -Uvh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386
Clearly not.
How do i upgrade mysql?
View 1 Replies
View Related
Feb 16, 2007
I have a big issue importing 4.0 databases with mysql 5.0.27.
I did a mysqldump -pxxxxx --force --all-databases > file.sql on server with mysql 4.0
But when I tried to import the file on server with mysql 5.0, this is what I got:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1
I even tried to force import and I got:
ERROR 1046 (3D000) at line x: No database selected for every database.
I checked sql file and CREATE DATABASE xx and USE xx were both added.
I tried this with a single database and worked but with all not
View 6 Replies
View Related
Jun 1, 2007
loading a phpinfo() shows that the mysql variable "Client API version" on my server doesn't match the version of mysql installed ( 4.0.20 when mysql version is 4.1.21).
Can this cause trouble and php or mysql errors on scripts i'm running?
View 0 Replies
View Related
Nov 28, 2008
What are the files in this directory - /var/lib/mysql/
Files like
#sql_2a6c_0.MYD
#sql_2a6c_2.MYD
etc
etc
I have a stack of them all 200MB plus in size
I need to cleanup /var as its 99% full, what else can I clean up?
View 11 Replies
View Related
Nov 28, 2008
MySQL 5.1 GA
Has anyone tried to migrate already?
View 6 Replies
View Related
Apr 15, 2008
Mysql usage is very high now and most time server load is high.
Where is issue and how can resolve this?
View 11 Replies
View Related
Oct 22, 2008
I'm trying to understand, generally, on a Hybrid VPS with 1gig guaranteed/4gig burst- for small sites that might be installing stuff like Wordpress, a Forum, Joomla!, etc., how many MySQL databases this system can support.
I realize traffic would be a major factor but for discussion sake lets assume an average of 50 users for each db with a peak of 100 users.
Just trying to get a 'rule of thumb'. Wondering also, how much RAM (resources?) an idle db consumes.
View 10 Replies
View Related
Feb 25, 2008
i've been using 4.1 without problems but now i'm switching servers and i am wondering whether its a good idea to go for ver 5. How do they compare in terms of performance/security etc? Whats recommended for web use?
View 7 Replies
View Related
Sep 13, 2008
My Server using more MYSQL and CPU
i checked every thing
1 ) i went to : Show MySQL Processes
i want to know what is NULL
root localhost NULL Query 0 NULL SHOW PROCESSLIST
2 ) i went to CPU/Memory/MySQL Usage
Top Process %CPU 122 gzip
Top Process %CPU 110 gzip
Top Process %CPU 89.0 gzip
View 0 Replies
View Related
Jul 18, 2008
Would enabling PDO and PDO Mysql modules in apache compile (via whm) be a bad idea? Any possible conflicts or warnings?
It says
(UNSUPPORTED EXPERIMENTAL) Includes SQLite support. Other drivers (freetds, oracle, etc) can be installed with PECL. If you use rawopts to add them during compile then you will have to have them '=shared' and *NOT* do the PHP "versioning" option. Custom opt mods for PDO extensions should also do the "versioning" logic this one does.
I'm already using mysql 5 with mysqli
View 2 Replies
View Related
Dec 18, 2007
I have successfully upgraded PHP 4.3.9 to PHP 5.1.6 and MySQL 4.1.20 to 5.0.48 and everything appears to working properly. Couple of questions:
1. Will the databases that were created under 4.3.9 automatically work under 5.0.48? Or do I need to do anything to them?
2. The database information appears to be fine under phpMyAdmin, but I noticed a new database file is now showing. It is named "information_schema". What is this file and is it a new part of MySQL 5.0.48?
3. Does phpMyAdmin 2.6.3 work fine with MySQL 5.0.48? Or do I need to upgrade that as well? And if so, what version works with 5.0.48?
View 14 Replies
View Related
Dec 20, 2007
A table in my DB got crashed and I repair it via phpmyadmin it gives me status that its repaired but when I browse it, it says table is marked crashed.
I've tried repairing several times,
View 5 Replies
View Related
Aug 29, 2007
started programming for web about a year ago (PHP, mysql, xml etc ) and am completely addicted. Having no prior experience in computing and have been hosting sites on shared server packages. I would, tentatively, like to start hosting my sites on a dedicated servers as i have now realised that it gives you more control over things like security, php / mysql extensions and config files.
I thought i'd start the process on a vps first and make some mistakes there, as i know it can get pricey with dedicated server. A friend reckoned that i should start with Ubuntu on linux (i have no experience with linux, but would like to get involved).
First of all does anyone now any good, cheap vps providers (i've looked at vpsland, feedback? better alternatives?)
and also, can you guys recommend good books/resources that will get me started with server administration (idiots guide!!) or just any good hints to get going! Should i set up on a web server on own pc first or jump in on a vps?
View 2 Replies
View Related
Feb 15, 2007
I have a server with 3 gb ram and currently 2 gb ram is free on my machine but the cpu is always 90 usually everytime
what can I do to use more ram toward mysql and less cpu
what can i adjust in my.cnf to lower cpu usage by mysql?
View 2 Replies
View Related
Mar 16, 2007
one of our servers is memory usage is very high and hard to track it down.
[]# mysqladmin pr
+-------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------+----+---------+------+-------+------------------+
| 29045 | root | localhost | | Query | 0 | | show processlist |
+-------+------+-----------+----+---------+------+-------+------------------+
Loook at the memory usage.
]# free -m
total used free shared buffers cached
Mem: 1003 988 14 0 20 85
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1262 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:03.83 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1263 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:00.00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1264 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:10.37 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1269 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:25.82 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1339 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:36.99 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1344 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:26.47 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1349 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:41.44 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1397 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:27.28 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1398 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:27.71 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1401 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:37.15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1403 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:20.32 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1410 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:23.28 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1411 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:17.13 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1412 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:16.82 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1413 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:25.30 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
1449 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:31.98 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
11205 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:21.92 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
11219 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:32.17 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
10073 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:09.14 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
10074 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:19.78 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
10075 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:23.84 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas
22902 slackers 16 0 30420 20m 2028 S 0.0 2.1 0:23.25 spamd child
how to track it down?
View 5 Replies
View Related