Top ten web hosting - server. The Startup Variables menu has aseries of
server. The Startup Variables menu has aseries of tab controls that group the configura- tion parameters into manageable chunks, asshown in Figure 44-3. Figure 44-3:The Startup Variables menu. With the tabs on this menu, you can adjust manyconfiguration parameters, including the following: General Parameters:On this tab, check theDisable Networking box to restrict access toyour MySQL server to those clients on thesame machine as the server. Log Files:On this tab, click the Slow QueriesLog box to generate a log file that displays slow queries. If you find that performance islagging, this tells you which queries are con- suming the most resources. Security: On this tab, check the Make AllTables Read-Only box for your replicationslave servers. You shouldn t modify replicatedtables from slave servers. Check out all the tabs and the options theyinclude to find new ways to customize and opti- mize your MySQL server. User Administration: Click User Administration inthe menu listing to open the User Administrationmenu. MySQL user accounts are listed in thelower-left frame of the window, as shown inFigure 44-4. Figure 44-4:The User Administration menu. To create a new MySQL user account, click theNew User button. Complete the user informationand then click Apply Changes. Use the SchemaPrivileges and Resource Limits tabs to view (or modify) user privileges. If you re running a version of MySQL youngerthan version 4.0, you ll get an error messagewhen you modify user information. Ignore themessage and consider upgrading to a morerecent version of MySQL. Server Connections: Click Server Connections toview all active connections and see what usersare up to. The User Connections tab displays adetailed list of user sessions. Highlight a username to display the active threads for that user, as shown in Figure 44-5. If you have runaway (or really slow) queries, you can kill them off on the User Connectionstab with the Kill Thread button, or terminateall threads for a single user with the Kill Userbutton. Just highlight the thread or user nameand click the appropriate button. Health: Click Health in the left panel to accessgraphs of performance and server statistics foryour MySQL server. The Health menu opens, dis- playing a trio of Connection Health graphs, asshown in Figure 44-6.
Please visit Domain Name Hosting services for high quality webhost to host and run your jsp applications.