I was trying to connect to a MySQL server at work and I got connection fail “Too many connections”. Here’s the screen shot that I took using Navicat Lite client and Sequel Pro.

I did Googling a bit and I found that most common problem is because MySQL has too many open client being connected [...]

There are times when we want to query a database structure for a particular table name. Or you want to find which tables a particular column name is defined. Or in my case, I wanted to find all tables that has column A and column B defined … how do I do it?
If you are [...]

Error can’t create table …
I was trying to add new table and alter another table to add new column and foreign key to the new table. Here’s basically what I had

CREATE TABLE `chapters` (
`chapter_id` int(10) unsigned NOT NULL auto_increment,
`chapter_title` varchar(255) NOT NULL,
PRIMARY KEY (`chapter_id`)
);

ALTER TABLE `articles`
[...]

How would you like to optimize a 10 minute query down to 24 seconds? This was an optimization I had to do at work and I thought I’d share this with anyone. Even though I was using MySQL as an example, I think the technique should work on any database. Let’s say you have a [...]