Hi list.
I have a server that is having a little MySQL load issue. I have done many hours of reading and can't quite get this worked out. I am asking for your help please. The server is to be a dedicated MySQL server only. The following is the current setup but currently is doing some apache aswell.( around 1gb total data out per day ) I would like the advice on setting this up purely for a dedicated MySQL server. There is a mix of both MyISAM and INNODB stuff. I am told by the programmers that they use the MyISAM stuff cause of the indexing power.:S Dont need transactions. My questions are: 1. Is this hardware going to be enough ?
The hardware you have is just fine. But start thinking about a clustered solution. As the traffic increases, you eventually reach a point where no hardware is good enough on one box.
2. What sort of gain is to be had if I linux software raid-1 the 2 x sata 150 drives ??
Other than the regular RAID-1 redundancy, not much. Trying to optimize MySQL with a beefy HDD is like trying to improve your travel time from New York to San Francisco by buying a faster car.
3. If this is sufficient hardware then what can I do to improve my.cnf and the overall server performance. ????
99% of the time the problem is bad queries or bad/non-existent keys. Tweaking my.cnf rarely makes a significant difference. Enable log-slow-queries and log-long-format and start fishing out and optimizing the slow culprits, the slowest ones first.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
