…MySQL appeared on the market many web applications were simple and often not using database at all. MySQL…MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough to solve all performance…
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…be performed …Queries and alert on a queries…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… technology allowing to dramatically increase performance of complicated join queries. MySQL users are always hungry for better performance as you might guess. …replication, filtering, cross database replication. It feature set beats MySQL 5.6 but as Robert Hodges puts it , “it works with MySQL 5….
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…MySQL offers, and also it moves too much computation load onto their database server. Their MySQL… very challenging. Whereas with performance, your site is working…database must be protected again if you use query results in a subsequent SQL query…www.owasp.org/index.php/Cross_Site_Scripting_Flaw I…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… a lot of complications and performance overhead. MySQL has to do several fsync… a lot of surprises. Backup Cross storage engine backup is a … as MySQL allows you using multiple storage engines in the query you … READLOCK” and hoping nobody is touching “mysql” database any more. Single Storage Engine …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… or further degraded performance. In the large databases I run in production relaying on MySQL Replication for … 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…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
…query-digest is an excellent tool. I do not know of any comparable tool for mysql… you want to make the cross to one of the other components…rewrites and runs these against the database and check the runtime and/or the… performance problem: “I do NOT look for possible solutions of a performance problem…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…You query VoltDB with stored procedures, not with arbitrary SQL queries…. of the lack of cross-node communication. What’s…master, fully ACID, always-consistent database to a 40-server cluster… We’re focused on MySQL software and services. I …parameters as a result of performing a regression against the …
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
… team could be cross tested with each database/api (for example if the 3364 opm mysql result was using … to communicate with mysql (DBI/DBD::mysql) there is not only one way to fire a query but a… retrieve just one column from mysql over DBI/DBD there is a performance difference of 51,155 fetches…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… do application redesign, for performance review or for starting… of scripting, implementation (writing queries), hands on setting up MySQL, Replication, Monitoring, … things. Second – waiting on database (or other) operations to complete – …remote work is often done cross time zones this becomes …
