How To Find Which Mysql User Is Using All Cpu
31015 100 15 0 151m 35m 5156 S 28 0.4 379:34.10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
This is my top process, I have quad core server and because of this server load is over 10
I am using cPanel, is it possible to trace which user is using all this cpu?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Mysql Usage: High CPU %, How Do I Find Out Who's Using What
just noticed mysql cpu usage has shot up from its usual 5-10% cpu to 30%+. domains are as normal and no extraordinary php processes. any way i can tell what users are most heavily running mysql? (as in number queries / slow queries etc?) i know mysqladmin processlist but that only gives me a snapshot, whereas i want to see over 24 hours, who used mysql the most...
View Replies!
View Related
Can We Find Out Historically What Causes Cpu Load
I have a P4 2.4G dedicated which is very lightly loaded. I use the loadavg app from www.labradordata.ca to monitor historical cpu and ram usage. 5-minute cpu load averages don't go beyond 0.5 and the mean is more like 0.05 almost every day. However just yesterday I discovered the cpu load went up to 38.0 at midnight for a couple of minutes. RAM usage looked normal. This is the 1st time ever that it has happened, and hasn't happened again since. Load has also returned to normal. I've looked at the logs and from my limited experience, have not been able to find out what caused the spike. Is it possible to find out from the logs? Is there any (other) way to find out what caused the spike or we just can't?
View Replies!
View Related
User Nobody Using Too Much Cpu
use "nobody" is using 2much cpu on my server ... can someone explain me how is this possible ? [url] I already have checked "Prevent the user "nobody" from sending out mail to remote addresses (PHP and CGI scripts generally run as nobody if you are not using PHPSuexec and Suexec respectively.)" In tweak settings.
View Replies!
View Related
How To Find What Perl Script Is Causing High CPU Usage
How to find what Perl script is causing high CPU usage? I logged into my CentOS box tonight and notice after viewing the output of the "top" command that there are the following lines of output that have me concerned. What command can I use to find the source of the Perl script that is causing the CPU spike? It seems it's been running for some time too. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 30120 apache 25 0 6908 4544 1216 R 99.8 0.2 13416:07 perl 30654 apache 25 0 8028 4508 1212 R 99.4 0.2 13417:22 perl 21273 apache 25 0 7584 4528 1200 R 98.1 0.2 2225:12 perl 20516 apache 25 0 6760 4540 1232 R 96.8 0.2 2221:30 perl
View Replies!
View Related
Check Memory And Cpu User By Hosting Account
In the past WHM gave us the chance to check the hosting accounts daily cpu, memory and mysql usage in server status, but on the new WHM/CPANEL releases we noticed that this values are not so precise as they were. Anyone know how can be found the average use of cpu/memory/mysql of each hosting account letting the hosting companies understand who uses more resources?
View Replies!
View Related
Limiting Cpu/memory Of A Single User/domain In Whm
i've been researching this but can't seem to find a decent solution. basically trying to limit the cpu usage of a single domain, or limit accesses per hour if that's possible? i tried adding an entry in /etc/security/limits.conf which restricts numproc to 2 and then down to 1, but it doens't seem to make any impact on the load. load of the server drops from about 1.5-2 down to 0.02 when this single site is suspended, and i can't have it run wild. ideally would like a message that says something along the lines of server is too busy... trying again in 5 seconds or something along those lines?
View Replies!
View Related
Access RAM Memory & CPU Usage By User Files
I don't really now how this can be done, but as far as I can remember when I was in shared hosting, they always complaint about memory usage.... but they always know what specific files were cosing the most load on the server. So, I remember I have this count.php file that was constantly hited and the complaint and tell me exactly what file it was cosing the heavy load. This is just an example, but looks like they always knew the specific files that were cosing problems, so what the hell, this can be done! Now that I have my own server I would like to know these things as well, so I can know what files need to be optimized. I searched and searched and searched and... OK, you'll get the point, and I just HAVE NOT find any information on this. Can someone tell me this "secret"? What do you use to get the files that are cosing the most heavy load on a Linux server?
View Replies!
View Related
Trojan Activity - Running Perl With High CPU Usage, With User Apache
Running programs named Perl with Heavy CPU usage, with the ownership of user apache. We found the problem on Fedora 3 and Fedora 6. In our case, it was the result of a Trojan activity. Quick Solution Check the cron jobs of user apache crontab -u apache -e */1 * * * * perl /tmp/.tmp/tmpfile delete the cronjob entry. Also delete the file /tmp/.tmp/tmpfile also added "apache" to the file /etc/cron.deny That's all Problem and solution in detail....
View Replies!
View Related
Error Backup, Transfer To New Server "Unable To Find The Cpanel User File."
I have problem: Searching /root.... Found cpmove-clanpz.tar.gz! Moving Packge to /root/cprestore/cpmove-clanpz.tar.gz Extracting tarball....window.scroll(0,175);............... Done Extracting Domain....Done Sorry, the copy failed. Unable to find the cpanel user file. Is the archive missing (cwd: /root/cprestore loaded cpmove-clanpz/cp/clanpz)? checked 4 files..... 1. /scripts/pkgacct username... 2. Transfer backup to new server 3. /scripts/restorepkg username 4. this error
View Replies!
View Related
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED] I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended how I would repair that to get mysql to start again?
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
More Using CPU / MySql
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 Replies!
View Related
Mysql Take 75.5 % Of Cpu
my server stil down I cant login to the SSH .I reboot my server 3 time in the day ? I dont now what is the problem? there is result of command top PHP Code: Tasks: 206 total, 1 running, 204 sleeping, 0 stopped, 1 zombieCpu(s): 95.7% us, 3.3% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.3% hi, 0.7% siMem: 506732k total, 501156k used, 5576k free, 1404k buffersSwap: 522104k total, 323436k used, 198668k free, 88132k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1962 mysql 15 0 402m 34m 3456 S 75.5 7.0 6:57.25 mysqld 8388 apache 15 0 32304 10m 3872 S 7.6 2.1 0:00.62 httpd 4489 root 18 0 1784 532 204 S 6.6 0.1 0:50.46 gzip 7810 apache 16 0 31696 9.8m 3844 S 4.0 2.0 0:00.22 httpd 4487 root 18 0 15616 2116 1168 D 1.7 0.4 0:13.60 PleskX.pl 4831 root 18 0 16360 3496 1184 S 1.3 0.7 0:10.99 PleskX.pl
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Mysql Using 100% CPU
I have a medium size forum with around 100 members online in 15minutes.. as the days gone .. sql data has become quite big .. and now most of the times mysql uses 100% ... any help regarding this .. how to optimise sql .. or may be RAM upgrade needed ?? i already have 3GB ram with xeon 3010 processor
View Replies!
View Related
CPU/Memory/MySQL Monitor
Since upgrading to Apache 2 I am no longer able to tell which domains are the busiest using CPU/Memory/MySQL Usage. Now Apache processes are all lumped together and individual domains only show cron, mail and FTP usage. I opened a ticket with cPanel and they know of the problem but there is still no solution. Is there another way I can tell which of my sites is using the most resources until this bug is fixed?
View Replies!
View Related
Lower MySQL CPU Usage
I'm having a problem with high MySQL CPU usage on my server, one of my sites is getting hit pretty hard right now and MySQL is just killing the box. Its averaging a load of over 20, CPU usage is around 130%. here is my my.cnf file. is there anything in their that should be changed to help lower the CPU usage? # The MySQL server [mysqld] port= 3306 socket= /var/lib/mysql/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 512 max_connections=500 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Server Specs. Pentium E 2.0Ghz 2GB ram 2x 320GB hard drives. Cent OS 5 Cpanel
View Replies!
View Related
Mysql 100% CPU Usage
After running for a while mysql suddenly starts using 100% CPU and my site goes down due to apache waiting with 150 sleeping processes. Here is the top stats PHP Code: top - 00:20:47 up 12:01, 2 users, load average: 1.11, 1.04, 0.95 Tasks: 200 total, 2 running, 198 sleeping, 0 stopped, 0 zombie Cpu(s):100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 1004152k total, 618132k used, 386020k free, 118436k buffers Swap: 2000084k total, 0k used, 2000084k free, 282372k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2011 mysql 18 0 177m 43m 5684 S 99.9 4.5 86:51.60 mysqld 14877 root 15 0 2360 1216 860 R 0.3 0.1 0:00.11 top 1 root 15 0 1948 648 556 S 0.0 0.1 0:00.97 init ps ax | grep apache -c 152 On restarting mysql everything goes back to normal. Can someone tell me how I could go about rectifying this? I'm sure the server can take the load, coz before this the site was on a way slower machine and worked flawlessly.
View Replies!
View Related
MySQL Cpu / Memory Usage
I'm always having MySQL consuming quite a bit of cpu & ram. what's happening here? PHP Code: mysql 27519 7.2 12.8 158736 132496 ? Sl Mar08 180:57 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.hostname.pid --skip-external I have replaced my server's real hostname to server.hostname
View Replies!
View Related
Mysql Has 182% Cpu Usage
I am using lighttpd php and mysql. How to lower the cpu usage? What's the best way to monitor mysql usage? Quote: top - 10:39:48 up 10 days, 35 min, 1 user, load average: 8.22, 9.38, 8.50 Tasks: 132 total, 5 running, 127 sleeping, 0 stopped, 0 zombie Cpu(s): 73.5%us, 22.3%sy, 0.0%ni, 2.1%id, 0.0%wa, 0.1%hi, 2.0%si, 0.0%st Mem: 2075000k total, 1919256k used, 155744k free, 113660k buffers Swap: 2031608k total, 56k used, 2031552k free, 1177200k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 21899 mysql 20 0 200m 53m 4752 S 182 2.6 8100:18 mysqld 2548 lighttpd 20 0 20288 16m 680 S 19 0.8 878:33.76 lighttpd 9759 lighttpd 20 0 23168 7880 3048 S 10 0.4 8:50.96 php-cgi 30959 lighttpd 20 0 23164 7896 3096 S 10 0.4 11:40.95 php-cgi 9732 lighttpd 20 0 23204 7544 2664 S 8 0.4 8:59.42 php-cgi 10671 lighttpd 20 0 23248 7612 2664 S 8 0.4 4:51.95 php-cgi 9769 lighttpd 20 0 23312 8012 3048 S 7 0.4 8:55.61 php-cgi 9771 lighttpd 20 0 23104 7312 2584 S 7 0.4 8:50.33 php-cgi 10601 lighttpd 20 0 23336 8032 2996 S 7 0.4 4:56.21 php-cgi 31091 lighttpd 20 0 23064 7860 3100 S 7 0.4 11:30.69 php-cgi 9782 lighttpd 20 0 23116 7880 3060 S 7 0.4 8:57.46 php-cgi 8559 lighttpd 20 0 23396 7780 2668 R 6 0.4 6:43.16 php-cgi
View Replies!
View Related
CPU/Memory/MySQL Usage - Munin @ 54%
I'm checking my CPU/Memory/MySQL Usage and I'm seeing that something called Munin is running at 54%. That is apparently the average for today. Can anyone give me any insight as to what this is? Wikipedia classifies Munin as a network monitoring application. I don't think it should be using this much processing. It appears that I may have enabled this plugin when I rebuilt my apache using EasyApache. Are there any big benefits to this? Looking at the graphics at first glance it doesn't look like there is. but then again, I'm not that knowledgable about this stuff.
View Replies!
View Related
Narrowing Down Sites MySQL Cpu Usage
I'm no SQL expert so I'm not exactly sure what to look for in-depth here. However, I noticed that MySQL would periodically raise to 98% cpu usage in top. So, I checked it out and turns out every time you load the front page of a site I host it takes about 30 seconds to load and its during that time that MySQL is freaking out. I know the user relies heavily on MySQL, however I want to try to narrow down the problem as much as possible for them. Any recommendations on what else to look for?
View Replies!
View Related
Mysql High CPU Load - Totally Stumped
Quad Core server, 4GB ram. MySQL runs at all times between 200 - 300% CPU. Server does only 5K unique per day, and runs zen cart. I am at a loss, I have experiece with tracking dowen reasons for this but this one has stumpped me. So I was hoping to get new eyes on this and see if anyone had any ideas. my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #old_passwords=1 skip-locking skip-name-resolve skip-bdb key_buffer = 64M max_allowed_packet = 16M table_cache = 2048 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 16 thread_concurrency = 8 query_cache_size = 25M query_cache_type = 1 tmp_table_size=64M back_log = 100 max_connect_errors = 10000 join_buffer_size=1M open-files = 20000 interactive_timeout = 300 wait_timeout = 300 max_connections=200 # The following directives should be commented out # but included as they are things that get added # very frequently on tickets. These are more in a # need-this-feature basis. # The below 2 cannot be set on the fly. If the customer already has # InnoDB tables and wants to change the size of the InnoDB tablespace # and InnoDB logs, then: # 1. Run a full backup with mysqldump # 2. Stop MySQL # 3. Move current ibdata and ib_logfiles out of /var/lib/mysql # 4. Uncomment the below innodb_data_file_path and innodb_log_file_size # 5. Start MySQL (it will recreate new InnoDB files) # 6. Restore data from backup #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_file_size = 100M innodb_buffer_pool_size = 64M innodb_additional_mem_pool_size = 8M #log-slow-queries=/var/lib/mysqllogs/slow-log #long_query_time=2 #log-queries-not-using-indexes #log-bin=/var/lib/mysqllogs/bin-log #log-slave-updates #expire_logs_days = 14 server-id = 1 [mysql.server] user=mysql #basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit=65536 mysqladmin status Uptime: 1458 Threads: 1 Questions: 366975 Slow queries: 0 Opens: 401 Flush tables: 1 Open tables: 395 Queries per second avg: 251.698 SHOW STATUS; mysql> SHOW STATUS; +-----------------------------------+----------+ | Variable_name | Value | +-----------------------------------+----------+ | Aborted_clients | 0 | | Aborted_connects | 8 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 116 | | Bytes_sent | 157 | | Com_admin_commands | 0 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_call_procedure | 0 | | Com_change_db | 0 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_create_user | 0 | | Com_dealloc_sql | 0 | | Com_delete | 0 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_drop_user | 0 | | Com_execute_sql | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 0 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 0 | | Com_savepoint | 0 | | Com_select | 1 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 0 | | Com_show_column_types | 0 | | Com_show_create_db | 0 | | Com_show_create_table | 0 | | Com_show_databases | 0 | | Com_show_errors | 0 | | Com_show_fields | 0 | | Com_show_grants | 0 | | Com_show_innodb_status | 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_ndb_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_privileges | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 1 | | Com_show_storage_engines | 0 | | Com_show_tables | 0 | | Com_show_triggers | 0 | | Com_show_variables | 0 | | Com_show_warnings | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 0 | | Com_update_multi | 0 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Compression | OFF | | Connections | 1569 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 5 | | Created_tmp_tables | 1 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 132 | | Innodb_buffer_pool_pages_data | 307 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 1 | | Innodb_buffer_pool_pages_free | 3787 | | Innodb_buffer_pool_pages_latched | 0 | | Innodb_buffer_pool_pages_misc | 2 | | Innodb_buffer_pool_pages_total | 4096 | | Innodb_buffer_pool_read_ahead_rnd | 2 | | Innodb_buffer_pool_read_ahead_seq | 0 | | Innodb_buffer_pool_read_requests | 48197 | | Innodb_buffer_pool_reads | 205 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 1 | | Innodb_data_fsyncs | 7 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 7213056 | | Innodb_data_reads | 221 | | Innodb_data_writes | 7 | | Innodb_data_written | 35328 | | Innodb_dblwr_pages_written | 1 | | Innodb_dblwr_writes | 1 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 0 | | Innodb_log_writes | 2 | | Innodb_os_log_fsyncs | 5 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 1024 | | Innodb_page_size | 16384 | | Innodb_pages_created | 0 | | Innodb_pages_read | 307 | | Innodb_pages_written | 1 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 0 | | Innodb_row_lock_time_avg | 0 | | Innodb_row_lock_time_max | 0 | | Innodb_row_lock_waits | 0 | | Innodb_rows_deleted | 0 | | Innodb_rows_inserted | 0 | | Innodb_rows_read | 165 | | Innodb_rows_updated | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 52512 | | Key_blocks_used | 1074 | | Key_read_requests | 24616475 | | Key_reads | 1170 | | Key_write_requests | 11301 | | Key_writes | 4948 | | Last_query_cost | 0.000000 | | Max_used_connections | 13 | | Not_flushed_delayed_rows | 0 | | Open_files | 495 | | Open_streams | 0 | | Open_tables | 395 | | Opened_tables | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 440 | | Qcache_free_memory | 2620672 | | Qcache_hits | 293141 | | Qcache_inserts | 69381 | | Qcache_lowmem_prunes | 60094 | | Qcache_not_cached | 20918 | | Qcache_queries_in_cache | 1338 | | Qcache_total_blocks | 5755 | | Questions | 394590 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 1 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 0 | | Sort_scan | 0 | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | NONE | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Table_locks_immediate | 173929 | | Table_locks_waited | 3 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 11 | | Threads_connected | 2 | | Threads_created | 13 | | Threads_running | 2 | | Uptime | 1540 | | Uptime_since_flush_status | 1540 | +-----------------------------------+----------+
View Replies!
View Related
MySQL High CPU Usage Put On RAM
I need some help my CPU (Intel Core 2 Duo 1.7 Ghz) always gets high usage from mysql sometimes its using 95% cpu etc... How can I modify my.cnf to use less CPU and more ram since I have 3gb ram installed? here is my.cnf Code: [mysqld] back_log = 5 skip-innodb max_connections = 400 key_buffer = 190M myisam_sort_buffer_size = 156M join_buffer_size = 4M read_buffer_size = 4M sort_buffer_size = 5M table_cache = 1024 record_buffer = 1024 thread_concurrency = 2 long_query_time = 1 thread_cache = 1024 thread_cache_size = 992025 wait_timeout = 13 connect_timeout = 5 tmp_table_size = 64M max_heap_table_size = 16M max_allowed_packet = 16M max_connect_errors = 500 read_rnd_buffer_size = 1024 bulk_insert_buffer_size = 32M query_cache_limit = 1M query_cache_size = 64M query_cache_type = 1 query_prealloc_size = 163840 query_alloc_block_size = 32768 low_priority_updates=1 default-storage-engine = MyISAM [mysqld_safe] nice = -2 open_files_limit = 4096 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 32M write_buffer = 32M
View Replies!
View Related
Using Find Command With Regex To Find All Number-only Filenames
how can i do a search for all files (probs using regex) of files consisting purely of numbers? for e.g. find: 53243.php 24353.php 24098.php (always have 5 numbers). seems one of my accounts has had some script run which generated a bunch of these in various subfolders, and the php file basically does a callback to www3.rssnews.ws and www3.xmldata.info, which seem to be some sort of spyware servers.
View Replies!
View Related
|
TRACKER
