…part of MySQL bug #49169 and can be described as follows. Whenever a connection wants … from that optimization, you basically want all or most of your transactions to be…MySQL 5.5 basically kills throughput on high concurrency. The picture changes dramatically when the read-only optimization in MySQL…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… correspond to connections – orphaned prepared statements, user variables, huge network buffer (can grow up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related applications…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… snapshot commits. You can kind of workaround this issue by killing transactions which are too old though proper solution would be… having few connections which use appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not…/single connection. P.S You would say how this all could be true if there are thousands of virtual hosting companies offering MySQL…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…MySQL on the same files in the data directory, and refusing to shut down MySQL so that it is killed… engine. For example, a pile-up of connections all trying to open or close tables can…The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable …an option and variable reference for all three sites in one! abort_…commanual Compressionblogpercona.commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual consoleblogpercona….
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…. The following figure summarize the simplest HA architecture using MySQL replication. All writes are going to the master while reads are spread… of MySQL servers. For the write VIP, MMM monitors the state of the current master and, upon failure, try to kill all the connections… lack of fencing capability. It is important to stop all the connections to the failing master and if that server is not…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… are ok, all VIPs, readers and writer, will be located on the master During a master switch, connections are killed on the demoted master to avoid replication conflicts All slaves are in read_only mode… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…space and restart time. The core file will dump all MySQL Server memory content including buffer pool which …you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes …cases could be to connect as “gdb -p `pidof mysqld`” select “continue” and let MySQL run. If it…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… the web/applications servers if easily done if they are all members (and the only members) of the same security group… to have the applications connect to 127.0.0.1 on port 3306 and then redirect the connection to MySQL using xinetd redirect type of services. The update_xinetd.sh script just updates the xinetd and send a kill…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql will not shut down unless a manual kill…
