You need to identify what the bottleneck in the system is? Is it disk I/O? Do you need more MySQL child processes running. Do you need to spread your MySQL data accross different drive spindles? Is memory the bottleneck? Is it an open files bottleneck? You really need to set up scripts to gather performance metrics so you have snapshots of the system at different intervals of the day, including peak times, and start tuning from their. (from what I have seen a lot in the past, people cram everything onto a single IDE disk, the web content, the access logs, the database, and you have to remember, every hit to your site can potentially require several reads and/or writes to the same disk. and with IDE, this can be a very large bottleneck). -----Original Message----- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 8:19 AM To: [EMAIL PROTECTED] Subject: Re: Very slow to connect In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Leonardo Dias) writes: > [1 <text/plain; us-ascii (7bit)>] > I don't know if any of you people have ever had this trouble, but it's > been a messy one here. > Whenever a website of ours get lots of traffic, MySQL gets too slow to > connect. Whenever it connects, the queries are fast. Since lots of our > scripts relies on database connections, it has become a big problem to > our website and we've been unable to answer to our costumers what is > going on. Use connection caching, e.g. mod_perl with Apache::DBI. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
