… 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: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… 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: 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: 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: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… needs would be OS needs – your system processes, page tables, socket buffers etc all need memory. I would put this to 256M… swapping out MySQL Process or other important processes to make room for file cache. OS may find it unfair there is MySQL process which consumes… swap file but it can hurt another way – OS may kill MySQL Process running out of memory (or thinking it is running out…
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: Living with backups
November 6, 2008 By 28 Comments
…€™s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily … imagine what happens to all the cached data during backup run when the process is reading several …running= 0; } if ($is_running == 1 && $was_running == 0) { kill 18, $pid; $was_running= 1; } … my $sth=…
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…
