… will be performed. So key-ordered scan is basically an extension of MRR to secondary keys. You can read more about… 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to…: 254 Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table | Rows_read | Rows_changed…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… papers, you’ll see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given… happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation… is also interesting: There is a known issue in tablespace extension. If the request to allocate a BLOB page leads to… update. However, there is no redo log record for file extension in the current redo log format. What does this mean…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of… talk now about why Persistent connections were disabled in mysqli extension. Even though you could misuse persistent connections and get poor…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… anyone can follow. A full performance audit is far more extensive than this article can cover, and might wander into Apache…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…’t show all the things he’d checked, which was extensive indeed. After a quick explanation the customer understood that the…
Page: Consulting for MySQL
July 31, 2006 By
…, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup… possible. Custom features and patches for MySQL We can help with developing custom features and extensions for MySQL, help fixing bugs promptly as… you’re developing MySQL Storage Engine, Appliance or Extensions we’re happy to work with you offering our expertise in MySQL Server and…
Post: MySQL Architecture meeting at Google
April 24, 2008 By 2 Comments
… at Google campus to talk about MySQL architecture mainly focusing on storage engine vendors and other extension areas. It was very interesting to see all these storage engine interface extensions which are planned for MySQL 6.0… lot have changed since that inside the MySQL and with forthcoming releases of MySQL 5.1 and 6.0 we’ll see…
Post: MySQL Community Needs
August 15, 2007 By 3 Comments
… but often to second – I mainly care about performance monitoring extensions which are very special – you do not have to run… same as Enterprise version but it has number of community extensions if you want them. For example there are CentOS 4… critical while it is rarely used same way with MySQL – even if MySQL is used on Desktop by end users it is…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
… to implicit extension to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has… of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add the BLOB… the eBay patch, ported it to 5.5, tested it extensively and fixed all the bugs we found. There are a…
