Web server address - Chapter 14 . Performance Tuning 389 Figure 14-15:
Chapter 14 . Performance Tuning 389 Figure 14-15: Examples of the myisamchk command to sort indexes on tables within the ecommerce database Summary The use of various MySQL logfiles is a major asset when troubleshooting the server or dealing with other database problems. . The error log is an important tool for helping to determine why the server crashes or won t start. . The binary update log and the query log can help you watch for updates that cause problems; they can also help you look for any SELECT statements that create performance problems. . The slow query log shows queries that take longer than the specified time or don t use an index. . The mysqladmin command contains useful functions for troubleshooting the server including flush functions and status and variable functions. . The flush functions with mysqladmin reset or clear counters, logfiles, and even the MySQL privilege system. . The MySQL CLI also includes flush functions along with functions to show variables and monitor server performance.
You want to have a cheap webhost for your apache application, then check apache web hosting services.