… localhost [] # Thread_id: 64914 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0…and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero….this query in a simple way because scanning all that rows are actually needed to produce …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… important piece 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… weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3 in parallel Parallel…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…or impossible to find the right threshold for all situations. This suggestion is a consequence of …MySQL on the same files in the data directory, and refusing to shut down MySQL so that it is killed… is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too …
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before … and restart time. The core file will dump all MySQL Server memory content including buffer pool which … can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related… 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
…applications servers if easily done if they are all members (and the only members) of the same…that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $… just updates the xinetd and send a kill -HUP to the process. Another equally valid option would be…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
… we run ANALYZE TABLE: mysql> analyze table t; +——–+———+———-+———-+ | Table | Op | Msg_type | …killing a query could cause even more troubles. If we are dealing with a write query on InnoDB the rollback process…there will be no rollback process so all the already updated rows…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
…to create excellent free tools for MySQL administrators. There is one really …of load and set up pt-kill to kill the queries if they …extremely demanding production cases, then started all over again. Finally, a few …improvements to our testing and development process, as well as rewriting pt-diskstats…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… slave, I just stopped the replication processes. This is safe to do even … that isn’t considered in the “all inside one transaction” argument: transactions aren…kill it, and restart it: slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the … other personalized services they may not use MySQL (and SQL at all). In many cases you would see… and kill them. Now think what happens if you Search Google or engage in any other processing intensive …
