Module 6: GUI Interfaces for Data Handling and Administration

1.	What is an Alpha version release?
2.	How do MySQLCC and MySQL Administrator differ ?
3.	How can you change or set Hot Keys with MySQLCC?
4.	What happens when you select different levels on the tree pane of MySQLCC?
5.	What is the MySQL recommendation for buffer size ?
6.	Which of these two GUIs allows you to start and stop the MySQL server by pressing a button?
7.	What four areas of system health can you monitor with MySQL Administrator?
8.	Where do you go in MySQL Administrator to set up a variety of system logs?
9.	How do you change the main display window in MySQLCC?
10.	What causes buttons to appear and disappear from the toolbar in MySQLCC?

Answers

1.	An Alpha version means that the program is still in the development stage and that bugs can be expected. Sections of the code may not be written or entirely completed.
2.	MySQL Administrator is aimed at administering database functions and design. MySQLCC does some administration, but it also allows you to edit, delete, and add to the contents of a database, as well as adjust its format.
3.	The Hot Key link in the Control Center dropdown menu or Toolbar button gives access to the Hot Key Editor where existing Hot Keys can be altered or new Hot Keys defined.
4.	The toolbar buttons change to reflect functions that relate to that particular selection.
5.	The recommended buffer size is 25 percent of your system s available RAM.
6.	MySQL Administrator allows you to start and stop the server by pressing a button.
7.	The four areas you can monitor in the Health section of MySQL Administrator are Connection Health, Memory Health, Status Variables, and System Variables.
8.	The Log Files tab of the Startup Variables section in MySQL Administrator allows you to set up Binary, Query, Error, Slow Queries, Update, and ISAM log files.
9.	Selecting a database or table from the Console Manager listing changes the main console window to reflect data pertaining to your selection?
10.	Choosing a server, database, or table in the Console Manager listing can cause buttons to appear or disappear from the toolbar, depending on whether or not they pertain to the selected item.