sorry Egor Egorov, Mutt sent the mail to your private inbox ;) resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote: > Mohammed Sameer <[EMAIL PROTECTED]> wrote: > > I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. > > MySQL 4.0.18 compiled from source. > > > > We have 2 webservers running apache, And this is the backend database server. > > The server is really slow. > > a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about > > 50% CPU > > idle. > > > > using MyISAM table types. > > > > sure I can provide any statistics about the running server. > > Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? > > Any suggestions are welcomed. Thanks for replying... > > Does MySQL use indexes? You can check it with EXPLAIN SELECT: > http://dev.mysql.com/doc/mysql/en/EXPLAIN.html > It's phpBB and phpnuke "still fighting with them to trash phpnuke" default tables. The website is really active, with about 67000 visits/day. We are using a RAID controller for the server. > Some optimization tips you can find at: > http://dev.mysql.com/doc/mysql/en/MySQL_Optimisation.html I tried all this, but no use. CPU idle is usually 0% a 1.5 gig log file was generated in about 12h or so. move to innodb from MyISAM ? Is it a Debian woody problem ? load balancing ? I tried to do what I can, but nothing improved the performance. -- ---------------- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT d-(++)@ s+(++):->+++ a-- C+++$>++++ UL+++$>++++ P+++$>+++++ L+++(++++)$>+++++ E>+++ W++?>$ N+>+++ o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e++>+++ h-->++ !r y? ------END GEEK CODE BLOCK------
signature.asc
Description: Digital signature