… blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is… slow query logs captured from our production systems. We restored a production database backup to our test database so that our test database was consistent before applying the captured query traffic. This is…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…database, it will fail. These things tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL…mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…as Queries and alert on a queries-per-…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… of 90s when MySQL appeared on the market many web applications were simple and often not using database at all. MySQL did not… the data in defined way so cross shard queries become a pain. Dealing with lag in MySQL Replication is another issue which complicates… in the database efficiently. The other Wave is appliances – you can see Violin Memory appliance which can be used with MySQL to…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… grouping technology allowing to dramatically increase performance of complicated join queries. MySQL users are always hungry for better performance as you might… replication, filtering, cross database replication. It feature set beats MySQL 5.6 but as Robert Hodges puts it , “it works with MySQL 5.0…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…procedure language MySQL offers, and also it moves too much computation load onto their database server. Their MySQL …in the database must be protected again if you use query results in a subsequent SQL query, then you…it here: https://www.owasp.org/index.php/Cross_Site_Scripting_Flaw I’d like to …
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… deadlocks, but instead a cross-node locking conflict of …mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query…databases this may be perfectly natural, but I believe most conventional relational databases…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 18 Comments
… describe several solutions for storing and querying trees in an SQL database, including the design I call Closure…the same table in a single query in MySQL. But we can use MySQL‘s multi-table DELETE syntax… You’re concerned with changing paths that cross over that boundary. Everything else takes …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…re up for a lot of surprises. Backup Cross storage engine backup is a pain because they…is not enough as MySQL allows you using multiple storage engines in the query you need to test… TABLE WITH READLOCK” and hoping nobody is touching “mysql” database any more. Single Storage Engine server would be…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… at the same time as running reporting queries on last month. All last month will … you can do with MySQL Replication, such as filtered replication or cross storage engine replication, though … MySQL Replication or just looking to keep MySQL infrastructure to be as close to one for other databases…
Comment: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 15 Comments
… have different behaviour than –binlog-do-db See http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html#option_mysqld_replicate-do-table http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html… for cross-database updates, in contrast to –replicate-ignore-db.” But you still need to be aware of it’s quirks, queries that…
