Uncategorized
Monitoring 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].
Explain 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.
MySQL 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.
Where 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.
InnoDB 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.
Focus on what you do best
When you have a great idea for a web application, it can be hard to consider with all the moving parts to focus just on what’s your uniqueness or differentiator from everybody else.
Time Warner Cable Speed
I had my Time Warner cable installed yesterday, a rather painless process. Reported as having Internet speeds of 10MB down and 1/2 MB up, these were confirmed with speedtest.net Installation – July 5
Don’t use HostMonster
Following a 2-4 day outage from my hosting provider of my dedicated server, I decided to move non critical websites to shared hosting. I have one with 1&1 but I created a second account to share load and act as a backup with www.
Learning from a Disaster
As Farhan has already pointed out to us, Disaster is Inevitable – Must shutdown generators . My primary hosting provider The Planet had a serious meltdown, 9,000 servers unavailable, DNS and administration application .
The next opening keynote – Everything fails, All the Time
Our third keynote this morning was by Dr Werner Vogels – CTO Amazon.com His second question to the audience “How many of you don’t shop at Amazon?” When one or two people raised their hands he commented, “Can I talk to you later.