… same block again. That happens for as long as it does not get flushed. MySQL obviously takes advantage of this functionality just… that running a simple copy operation from MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…process and send back the response, with a “long tail” of requests that take longer than … This is common in MySQL servers I work with when they’re running a simple read-mostly …would normally be sending queries to the server would be stopped, waiting for existing queries to complete. That didn…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…MySQL 4.1 but you still could not run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL…very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5…suggested by MySQL customers and myself based on long MySQL usage for Web. Later I stopped adding …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_stop‘, ’0′ ‘Com_stmt_close’, ’304204263′ ‘Com_stmt_execute’, ’304205150′ ‘Com_stmt_prepare’, ’410680831′ ‘Com_stmt_reset’, ’0′ ‘Com_stmt_send_long…=/tmp/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: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave… be network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware…:Exec_Master_Log_Pos: localhost:(none)> slave stop; Query OK, 0 rows affected (0.00 sec) …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… errors. Look at early MySQL versions – if you insert too long data it would just strip …may find MySQL which just happened to come with OS and queries which no one ever run EXPLAIN …stopping you from shooting yourself in the foot. MySQL Skills also would likely loose portability. If you look at MySQL…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… catch up (it also pauses if replication stops on a replica). In order to do this…query-digest. For example, with the sandbox server I used for the examples, it would be pt-query-digest –review S=/tmp/mysql… but as it needs to lock the table, long running transactions that lock (part of) the table …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql> delete from salaries where emp_no = 10001; Query OK, 17 rows affected (0.15 sec) mysql> drop table salaries; — Ooops! Query…mysql stop Shutting down MySQL (Percona Server)….. [ OK ] [root@sb logs]# umount /mysql/data [root@sb logs]# lvconvert –merge /dev/sb/mysql… a long running ALTER or…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… Oracle folks arrived at this conclusion a long time before the MySQL world started to come around. There…any buffer hit ratio the user desires by running silly queries that do nothing but cause buffer hits,…without controversy. But really, it’s time to stop with the bad advice about counter ratios. …
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
…in our plans to create excellent free tools for MySQL administrators. There is one really big thing to …set up pt-kill to kill the queries if they happen to run too long and schedule downtime in your … progress reports, of course. And if you want to stop it for any reason, it’s graceful about that…
