On Thu, 24 Feb 2005, Chris Aitken (The Web Hub) wrote: > Hi all, > > I have just created a databased website that is working with a fairly large > number of records (well, 10 million records is the biggest database ive > ever worked on so far) but also have a large number of searches of these > records happening regularly. > > The problem ive come across, is my hosting providers box is setup so that > if the server load gets to 5, sendmail packs it in.
"packs it in"? Do you mean like you say that sendmail actually crashes when load goes above 5? I would guess sendmail is rather throttling itself and that you are seeing log messages about sendmail refusing connections. Is this a correct assumption? Sendmail can be configured to operate with higher loads. If sendmail actually dies, there's something really unusual going on. > When someone does a search of the records, mysql jumps up to 100% cpu usage > (which is fine) but the more searches that are being done (the website is > getting more users daily) the longer the cpu is at 100% and the higher the > load gets. To me it sounds like you are having problems with your database design and that you could benefit from some indexes perhaps. Do you have any indexes? If you list your table structure and queries that are bogging things down, the mysql list will be more than happy to help you. :) One thing your server admin can do in the meantime is to lower max number of concurrent connections, assuming you are the only one using the mysql server. Atle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
