…Server is the ability to enable logging atomically, not just for new connections as in MySQL. This is very … localhost [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0.117904 Lock_time: … Another thing to note is the last line in the output the # MISC part, it tells you how much…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…To check the if it works you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL…. Now as I explained how you can get core files from MySQL I should say they … The alternative in many cases could be to connect as “gdb -p `pidof mysqld`” select “continue” and let MySQL run…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…how much the slaves were behind the master when the outage occurred. So, if you want to…MySQL servers. For the write VIP, MMM monitors the state of the current master and, upon failure, try to kill all the connections to…, replication can be used in many cases to build effective and scalable highly …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…in MySQL if you’re looking for durable transactions the log write latency is triple important compared to other database systems. MySQL has to…connect” the storage to another node – if server fails or if you just want to upgrade to…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…data after load, until someone points me how to get real size, and also explains what…other engines in Google Spreadsheet or in summary table at the bottom) Query Q1: mysql> SELECT DayOfWeek, …but query stuck. I killed query, restarted mysqld but could not connect to mysqld anymore. In processes I see…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… so make sure to leave space for other MySQL needs while factoring this in. The next step would be to decide How Much Memory do… connections doing work with huge temporary tables and otherwise running complex queries. It is usually much better to simply check it. Start MySQL… kill MySQL Process running out of memory (or thinking it is running out of memory) which may happen ie in case of unexpected connection…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to… ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill‘, ’47′ ‘Com_load’, ’0′ ‘Com_load…mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… have a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times… on how to do this. There is not such easy way for the long transaction list, but fortunately there are some alternatives to…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED…
Post: Living with backups
November 6, 2008 By 28 Comments
…a utility called ionice. It allows to affect how I/O scheduler will be dealing …1) { if ($is_running == 0 && $was_running == 1) { kill 19, $pid; $was_running= 0; } if ($is_running == …to check MySQL status every second and in case the number of connected threads goes above 50, it sends STOP signal to…
