PHPMyAdmin & MySQL Control Center

Comparison?

[lorax]

I'm very familiar with PHPMyAdmin but have recently considered playing with MySQLCC. I'd like to hear what folks think of it before I go to the trouble of download and install.

[DaveAtIFG]

It looks promising and powerful but it's still in alpha test [mysql.ulak.net.tr], hoping to go beta at next release. I'd wait until it matures a little.

[lorax]

Well, being the curious and foolish sort that I am - I downloaded and installed it. I quickly saw how powerful this little tool is. Especially when using it to analyze and optimize a web app. I've been using it for the last hour or so to analyze one of the web apps I've recently "completed" and was able to increase it's performance noticeably. In this case - poorly chosen indexes.

I went back through all of my queries and looked at the select statements and what I was using in the WHERE clauses and used them to determine the indexes I should be using.

The tool allows analyzing the tables, queries, and database - basically anything you can do from the MySQL command line (thought I'm not sure about a dump). It interacts with either local or remote databases and it keeps a history of the commands you've issued - something PHPMyAdmin does not. You can even save queries and results or print them out if you wish. Very handy for troubleshooting and future reference. The messages window indicates things like errors, number of rows returned and how long the query took to execute.

All in all, a very handy tool.