Databases
Speaking at MySQL UC 2010
My talk on 10x performance improvements – A case study has just been approved for the <a href="2010 MySQL Conference . This will be my 5th straight year speaking at the MySQL conferences.
Read moreEurope conference options for MySQL Developers
For those in the US the annual MySQL UC is taking place again in April. For those in Europe we have dedicated room for MySQL and MySQL related products/variants/branches at FOSDEM 2010 being held in Brussels, Belgium on 6-7 Feb.
Read moreMonitoring the right MySQL slow queries
When looking at a set of SQL statements in isolation with tools such as the slow query log, processlist and tcpdump/mk-query-digest it is easy to identify queries that are slow.
Read moreWhat do MySQL staff think of the acquisition?
It finally dawned on me while reflecting on the year past this Sunday that the missing voice since the announcement of the Oracle acquisition of Sun Microsystems (and therefore MySQL) has been the MySQL employees.
Read moreUnderstanding installing MySQL rpm versions
I have a problem with an easy way to install MySQL via rpm without resorting to specifying the exact point release of MySQL. Presently my local yum repository has versions of 5.
Read moreThe Oracle EU statement on MySQL – What’s missing
Many providers embedd MySQL with their commercial products including Adobe, Macfee, Nokia, Symantec and ScienceLogic just to name a few. In addition most commercial third party storage engines have for years been forced to provided very customized versions of MySQL due to limitations in the storage engine API.
Read moreCouldn’t load plugin named ‘innodb’
As part of reviewing storage engines for my work on the upcoming Expert PHP and MySQL book, I finally had an excuse to try out the InnoDB Plugin for MySQL which is now conveniently included with MySQL 5.
Read moreIs your database schema in sync?
If you have more then a single MySQL database for your production environment, e.g. a development and test environment, or a MySQL replication topology, ensuring your schema’s are in sync can be task that requires some time if not managed correctly.
Read moreMonitoring MySQL with MONyog
It just works. In absence of any MySQL monitoring for your site, I have found no solution that gets you operational as quickly and easily. MONyog can be deployed in 60 seconds, and configured in another 60 seconds.
Read moreMySQL Permissions – Restarting MySQL
I am working with a client that is using managed hosting on dedicated servers. This has presented new challenges in obtaining the right permissions to undertake MySQL tasks but not have either ‘root’ or ‘mysql’ access and not have to involve a third party everytime.
Read moreMonitoring MySQL resource limits
I have for the first time seen a client implement MySQL Resource Limits . I got the following error tying to connect to the database. $ mysql -udba -p ERROR 1226 (42000): User 'dba' has exceeded the 'max_user_connections' resource (current value: 10) I see from the documentation the ability to see the limits in the mysql.
Read moreMonitoring MySQL Product Options
I’ve had plenty of comments on specific products to Monitoring MySQL Options before providing the completed list. Here are the results from my survey to give everybody a more complete list.
Read moreMonitoring MySQL options
My recent poll What alert monitoring do you use? showed 25% of the 58 respondents to bravely state they had no MySQL monitoring. I see 1 in 3, ~33% in my consulting so this is consistent.
Read moreUnknown locale for statpack & maatkit
I had trouble today on a client site using my MySQL power tools Maatkit and Statpack . $ ~/scripts/statpack.py --files=mysql.status.091015.080001.txt,mysql.status.091015.090001.txt Traceback (most recent call last): File "/home/rbradfor/scripts/statpack.py", line 563, in ?
Read more