…/local/mysql/ cd /usr/local/mysql/ ps aux|grep mysql kill -9 18230 18266 ps aux|grep mysql bin/mysqld_safe –user=mysql & bin/mysql_upgrade –socket=/var/lib/mysql/mysql.sock mysql
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server operations manual by visiting…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually…like this: UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at the…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… scan in MySQL 5.5 basically kills throughput on high concurrency. The picture changes dramatically when the read-only optimization in MySQL 5…
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… which are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero… but because the access type to the tables is “const” MySQL does not count it as access to two tables. In…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… space (${full}%, ${avail}MB free)”>&2 exit 1 fi host=$(mysql -ss -e ‘SELECT p.HOST FROM information_schema.innodb_lock…_id INNER JOIN information_schema.processlist p on b.trx_mysql_thread_id = p.ID LIMIT 1′) if [ "${host}" ]; then echo…/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill ${pid} fi If…
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 which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
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…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… located on the master During a master switch, connections are killed on the demoted master to avoid replication conflicts All slaves… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid….170″ nic=”eth0″ \ meta target-role=”Started” ms ms_MySQL p_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark on enabling… it works you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes accessing the wrong…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you…
