… pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server operations manual …crash. 130528 09:53:56 mysqld_safe Number of processes running now: 0 130528 09:53:56 mysqld_…56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another …
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… ways to do the same. This is huge hole in MySQL design, thinking little about users isolations and resource quotas and… MySQL to “leak” 1MB of memory per second with no apparent good reason – no slow queries or queries in the PROCESS LIST… of memory: Killed process 1081 (mysqld). automount invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 Out of memory: Killed process 1081 (mysqld…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…[root] @ localhost [] # Thread_id: 64914 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows… are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero. It looks… but because the access type to the tables is “const” MySQL does not count it as access to two tables. In…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… instances of MySQL on the same files in the data directory, and refusing to shut down MySQL so that it is killed forcibly (i.e. crashed) instead of gracefully shutting down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL…. The server is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… to be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark on… it works you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes accessing the wrong… `pidof mysqld`” select “continue” and let MySQL run. If it crashes you will have process ready to work with GDB, which is…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever… have created and forgot to remove (or still use for processing). Of course you will see these tables going away if… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… instance) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW… to MySQL using xinetd redirect type of services. The update_xinetd.sh script just updates the xinetd and send a kill -HUP to the process. Another equally valid option would be to change…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… to tie all of these process together. We employ nsca nagios alerts for all of the backup processes. freshness_threshold should be… issue is we have a guardian process that runs during a backup. It then kills any process that causes a stall of the… retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…plan for another query we run ANALYZE TABLE: mysql> analyze table t; +——–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | …killing a query could cause even more troubles. If we are dealing with a write query on InnoDB the rollback process…
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 30 Comments
… than restarting your server or whatever is to set a MySQL value that does not allow connections to last over 30…['Command'] == “Sleep”) && ($row['User'] != “Root”)) { $killed = 0; mysql_query(“kill “.$row['Id']) or ($killed = 1); if ($killed = 1) { echo “Killed process number “.$row['Id'].”, with a User…
