…disk IO performance hit that comes with DRBD. When you run a virtual machine, in most cases your virtual…an obvious disclaimer here in that the aforementioned statements reflect only my opinion and not any …that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…statements from standard input, and outputs the SQL_API statements representing the original SQL statements…When the view is ‘enabled’, the contents are created: mysql…of SQL features not available with the incremental method, like ORDER BY or use of NOW(), it but still provides improved performance…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…is the behavior of the MySQL when it needs… some other cases help us …SQL process will stop with an error. Example: mysql> CREATE FUNCTION this_year() RETURNS INT DETERMINISTIC RETURN YEAR(CURDATE()); mysql…when using SET user-variables and then using it to perform… before the statement. MySQL uses the …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…SQL in stored procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL…perform a successful breakin to test for this type of security flaw. The more difficult part is making sure to test for all such cases in your code where SQL statements…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… 99% of all cases) commits a transaction, the DML statements from …sql statement. As some of them are looping, the timestamp of those statements does not increase, causing a flip of…mysql 4 (this position will increase every time writes are performed on the active master, so just take a position when…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…performance of simple query (single row point select) using standard statement, prepared statement and have it served from query cache. Prepared statements…MySQL API is it can switch between prepared and non-prepared statements transparently (in most cases…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…have performed and even depending on snapshot they are working on. If you’re using statements outside of …of the queries – in this case you can set query_cache_type to “DEMAND” and use only SQL…when it is good idea to use query cache ? Third party application – You can’t change how it works with MySQL…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…performed a number of simple benchmarks. Let’s start with a table containing 4 million rows and one secondary key: mysql…statements…of cases when this optimization is not applicable: UNIQUE indexes in ALTER TABLE are ignored to enforce uniqueness where necessary when…
