« MySQL Attendees: Thanks for the iTunes | Main | Database Design Workshop »
April 15, 2004
MySQL Administrator
Getting the afternoon sessions started with Alfredo Kojima talking about MySQL Administrator, a graphical tool for performing general administration in MySQL. For this demonstration the tool is pointed at MySQL 4.0, apparently is geared to work with releases greater than 3.23.x.
There is a slew of functionality that can be performed by the administrator. Alfredo is going over a list of all the functionality and I'm not going to take the time to list. Suffice it to say you can perform a ton of tasks from the administrator.
Features that I don't think we get using CLI:
- MySQL options grouped logically with inline explanations of options and guided value input
- select multiple of anything
- graphs for history of health (connections, traffic, query cache, key cache) that can be varied to show performance over time
- replication status of numerous hosts on one screen
- gui for sorting connections (SHOW PROCESSLIST)
- server logs parsed and presented in summary form (general, error and slow)
Currently the administrator is somewhat limited in that it can't execute certain commands remotely, only on localhost.
Posted by mike at April 15, 2004 2:50 PM
Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.Trackback Pings
TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/551