…all queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query…0 9.42k 1.67 0 110.38 0 # Killed 0 0 0 0 0 0 0 # Last errn…on many things including how fast do you need to be able to recover from backups and how much your load …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… complex queries. It is usually much better to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how large…. Some people try to solve it with disabling swap file but it can hurt another way – OS may kill MySQL Process running out… spike you may have MySQL Server being killed by OS instead of temporary swapping few things out. Two things to note about OS…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…MySQL optimizer choose the appropriate index for a query. If a table’s statistics or index cardinality becomes outdated, you might see queries…Schema: db1 Last_errno: 0 Killed: 0 # Query_time: 12.277786 Lock_time…the server 12 seconds to update all the tables’ statistics… disabling the feature and how …
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′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
Post: Speeding up GROUP BY if you want aproximate results
March 7, 2008 By 24 Comments
… today I wanted to count how many hits come to the pages which get more than couple of…pv; Unfortunately this query ran for over half an hour badly overloaded server and I had to kill it in… want to analyze data distribution but table is to large is to just limit it to first number of rows: mysql>…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times for even simplest queries, or… section of InnoDB status. Baron once wrote an article on how to do this. There is not such easy way for the… the output to that file first and then the stored information is read back to user. To make things more difficult, MySQL keeps the…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…to STATEMENT just before the execution of those large queries. It’s also worth to mention that there are two methods to… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even… Cacti are also a very good option to know how and when the size of your…
Post: Living with backups
November 6, 2008 By 28 Comments
… from MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick… a utility called ionice. It allows to affect how I/O scheduler will be dealing with …= 0; } if ($is_running == 1 && $was_running == 0) { kill 18, $pid; $was_running= 1; } … my $sth=…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
…SESSION1: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> insert into tst values(1); Query OK,… is what you have to pay for multiversioning. Lets also think how these modifiers can be… point transaction which made least updates is killed to resolve deadlock. Which means if transaction takes…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…killing server performance overtaking buffer pool. Though full table scan is only one of replacement policy optimizations possible. Q8: How…to fix Innodb so it unlocks (or never locks) the rows if they were not matched by query… little known new features in MySQL 5.1 Q15: How frequently does Innodb …
