…virtual-machine approach, but for the optimal production deployment you want two …an obvious disclaimer here in that the aforementioned statements reflect only my opinion and… in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement… optimization in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL …
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
…you should try to improve to get optimal response times pt-archiver, to efficiently purge… TABLE statements on large tables without downtime You can reserve your spot for this free MySQL …MySQL. In this presentation, you will learn how you can use some of these tools to solve typical, real-world MySQL…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built …fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table … Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL 5…-statement SELECT statements in autocommit. Which is the perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built …fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table … Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
… also help in such cases. So… maybe you were testing a C program with three threads executing highly concurrent DML statements (where… on… If we did know the “LES” – or Last Executed Statement - in our RQG case for example, we could bring up the… In the future. Conclusion: the Last Executed Statement was found in an optimized core dump by checking the contents of the thd array in the mysql…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… client. So in MySQL 4.1 Prepared statement came. Do not mix these native Server Side Prepared Statements with emulated prepared statements which JDBC, ODBC… and full parsing. (Note: Optimization phase currently remains). Not only this is faster if you execute statement serveral times but also it…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… behavior starting MySQL 5.5.3 Starting with 5.5.3 DDL statements that modify the table metadata are executed in an isolated… tables | 213.028481 | | System lock | 0.000009 | | init | 0.000014 | | optimizing | 0.000002 | | statistics | 0.000005 | | preparing | 0.000006 | | executing | 0…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of statements could be prepared… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close…
