Optimizing the mySql server

[Join us @ facebook]

Does anyone knows any good tools or tutorials for optimizing the mySQL server?

I don't mean optimizing the queries, but the DBMS server (my.cnf or whatever else)

It seems that I haven't done my job properly in the new server

Any help will be appreciated

[All cPanel hosting accounts include:]

as far as special optimization goes im not sure with the my.cnf file your referring to. with basically installation it should be fine. what exactly problems are you having? still same as before or totally different? have you considered trying a different host? i know a great host with great plans, cheapest ive ever seen (i have been WSS to long, so im not switching) and this may be the plan for you (by the way this is linux):

50 G Disk (storage)
1000 G Bandwidth
CGI
Shell Access
Unlimited FTP
40 add Domain
Unlimited Park Domain
Unlimited Subdomain
Unlimited POP3 Mail
(or email)
Unlimited Mailing List
Unlimited SQL
C-Panel/Fantastico
PHP
PERL
FrontPage
Free Search Engine Submit
Site builder
$10.84/month w/ 1 year Plan

sorry, forgot the part below. this may be useful in helping u decide

All cPanel hosting accounts include:
Detailed Daily Statistics
 FrontPage Support
 Raw Log File Access
 Email Forwarding
 Your Own CGI-BIN Folder
 
FTP Access
 Sub Domains
 Shopping Cart
 Spam Assassin
 Auto Responders
 
Backup and Restore Tool
 Custom Error Pages
 Password Protected Folders
 Redirects
 Error Log Access
 
Sub Domain Stats
 Search Engine Submit
 cPanel X+
 Fantastico script library
 RVskin - 18 languages
 
Lpanel (Client-side only)
 Instant Account Setup
 Email Accounts
 Mailing Lists
 Webmail - NeoMail/Horde
 
PHP Support
 PERL Support
 MySQL Database
 CGI Library
 Email Filters
 
PHP and java chat
 24/7 Server monitoring
 Hot Link Protection
 IP Deny Manager
 

Our Servers feature:
Operating System: Red Hat Enterprise 3 or better
 Processor: Dual Xeon 2.4 GHz or better
 Memory: 1GB ECC DDRAM or better
 
Connectivity: 100Mbps or better
As technology improves, we will too
 Dual Gigabit (1000Mbps) fiber-optic conncetions
 Ten tier- 1 backbones in network
 
Six 500 kva UPS systems
 Video surveillance (recorded and archived)
 Security patrols through entire facility
 
Secure, patrolled parking lot
 NOC access is restricted and guarded
 24 hour on-site security staff presence
 
VESDA air sampling and early detection
 Two Cummins backup generators
 15-days of backup power before refueling
 
 
IMHO, this is a very very VERY good deal. and quite powerful.

[Join us @ facebook]

No man I am not looking for a new host, I use my own servers.

I just want to optimize the server for better performance.

does the DB use temp tables, and how big is the DB in MB? if its over 100MB it may just be overloaded and u may consider releasing old entries and cleaning temp tables also have u considered allowing anon. and remote conn. to the mysql? also you can disable mysql error logging, speeds it up a little. also i believe there is a fix with new versions of apache, php, and mysql that will make it lots faster.

[Join us @ facebook]

I have done most of the things that you describe here.

I think that the error logging is not a problem, as there are no errors(I think that you should not have any)

The tables and the indexes are ok, and the database is 'clean'.

About the temp tables I use 32mb, but I am not sure if this is a value for the whole server, or for each connection. I am sure that I should raise this number, but I dont know what will be the cost in resources, and right now the server hosts some high traffic sites(which wait for their own servers) so the memory is allways full.

this sounds to me more like the mysql server u use is lagging, to many simultaneous connections at once. id allow less than 32mb for temp man.

[Guest]

[36.906]

Yahoo crawler, Msnbot, Baidu Spider