Databases
How do I find the storage engine of a MySQL table
This seems quite a trivial question, but developers don’t often know what a MySQL storage engine is and how to determine what storage engine is used for a table. The first choice is to describe the table with the DESC[RIBE] command.
Read moreMonitoring MySQL – The error log
It is important that you monitor the MySQL error log. There are a few different options available for defining the details of the log. If not specified the default is [datadir]/[hostname].
Read moreExplain this
The EXPLAIN command is an important tool to review how a SQL query is executed and in this example includes what indexes are used. By adding a covering index I ended up with the following EXPLAIN plan I was unable to explain.
Read moreMySQL Replication 102
One of the most asked questions is how to setup MySQL replication. The MySQL Reference Manual provides a good Replication How To as a starting guide on MySQL Replication 101.
Read moreWhere can you find MySQL Events?
As a frequent traveler for my MySQL consulting (last 4 weeks were Sydney, San Francisco, New York and Vancouver), I like to keep abreast of any local tech event that includes MySQL that I may be able to attend.
Read moreInnoDB I_S.tables.table_rows out by a factor of 100x
I’ve always believed that the MySQL Information_schema.tables.table_rows figure for Innodb tables to be while approximate, approximately accurate. Today I found that the figures varied on one table from 10x to 100x wrong.
Read moreMySQL DML stats per table
MySQL provides a level of statistics for your INSERT, UPDATE, DELETE, REPLACE Data Manipulation Language (DML) commands using the STATUS output of various Com_ variables, however it is per server stats.
Read moreHas your blog been hacked?
While not a MySQL topic, as most of my readers view my MySQL Blog, my WordPress blog has been hacked? Has yours? Like many, I’m sure you may have read about it like at WordPress blogs under attack from hack attack but I was surprised when my custom permlinks did not work.
Read moreWhat do you monitor in MySQL?
If you are unfamiliar with what to monitor in MySQL, starting with looking at what popular Monitoring products monitor. For example, the following is the list of MySQL Cacti Plugin measurements.
Read moreSQL Analysis with MySQL Proxy – Part 2
As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance.
Read moreSQL query analysis with MySQL Proxy
Long before there was the official Query Analyzer (QUAN), a component of MySQL Enterprise, SQL analysis was possible using MySQL Proxy . The following is an introduction to logging and query analysis with MySQL Proxy.
Read moreSeeking public data for benchmarks
I have several side projects when time permits and one is that of benchmarking various MySQL technologies (e.g. MySQL 5.0,5.1,5.4), variants (e.g. MariaDB, Drizzle) and storage engines (e.g. Tokutek, Innodb plugin) and even other products like Tokyo Cabinet which is gaining large implementations.
Read moreWe need more CATs
Before you think I’ve posted an animal story in my MySQL category please read on. For reference, The RAT and the CAT is something I wrote back in 2006, that explains the CAT part.
Read moreHandy MySQL documentation indexes
Updated If your wanting to know more about MySQL Indexes on tables, then check out Understanding Different MySQL Index Implementations . I just discovered today in the MySQL 5.1 Reference Manual a handy set of additional indexes in the System Navigation section.
Read more