Mysql your visual blueprint for creating open source databases- P11

Mysql your visual blueprint for creating open source databases- P11:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database.
Nội dung trích xuất từ tài liệu:
Mysql your visual blueprint for creating open source databases- P11 MANAGE THE MYSQL SERVER 9 You may have noticed that there is often more than one way to achieve the same result. For example, if you want to display a list of MySQL variables and their current values, you can use several commands: show variables from the MySQL monitor, mysqladmin variables from the command prompt, the Variables tab in WinMySQLadmin, or the Show variables button in MySQLGUI. Each of these methods of MySQL administration has its advantages and disadvantages. The MySQL monitor and the mysqladmin utility are available on all operating systems and provide a consistent interface, while the MySQLGUI and WinMySQLadmin utilities provide a graphical interface with easy access to common options. You can use whichever commands are available to you, and whichever you find the most comfortable to work with. In addition to the administrative features discussed here, you can use MySQLGUI to send queries to the MySQL server and display the results. Unlike the command-line MySQL monitor, MySQLGUI includes options to save query results to a file after you view them, and saves a list of the most recent queries for easy access. While MySQLGUI looks simple, keep in mind that it is every bit as powerful as the command-line utilities. You can use it to delete an entire database or shut down the MySQL server. Be sure to select commands carefully.s The variable list is › Click the Display status s The status information is ˇ Click Exit to return to thedisplayed. button to display detailed displayed in a new window. administration panel. server status.‹ Click the Exit button toreturn to the administrationpanel. 187 MySQLOPTIMIZE MYSQL most important factors that affect MySQL serverW hile MySQL will work remarkably well using the default settings, you can change a variety of performance include the speed of the server hardware, the factors to improve performance. Some of the design of tables, and the performance of particular queries.OPTIMIZE THE MYSQL SERVER One aspect of MySQL that is relatively easy to optimize is the speed of the machine running the MySQL server. Upgrading disks, memory, or processor, or switching to a faster machine can dramatically improve performance. Disk Access Processor Speed Disk access is usually the largest bottleneck affecting a While not as important as disk speed, the processor, or MySQL server. Because tables are stored on disk, CPU, of the MySQL server comes into play when virtually every MySQL operation involves disk access. working with data that has been read from disk: A faster MySQL will benefit from a fast disk drive. Additionally, processor will handle MySQL queries faster. It is also you may want to consider using a separate drive for beneficial to analyze the other applications on the MySQL data so that other server functions do not slow server. If a Web server or other software is using the down MySQL. CPU intensively, MySQL would benefit from a faster processor or a dedicated MySQL server machine. Memory A busy MySQL server requires a large amount of memory will often improve performance, especially if memory. This is used to store data temporarily while it the disk drives and CPU are already reasonably fast. is sent to clients, and for temporary tables. AddingOPTIMIZE TABLE DESIGN The design of a table can also affect performance. By considering performance when you design and create a table under MySQL, you can ensure that queries on the table can be quickly handled by the server. Using Fixed-Length Rows ...