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.
Does MySQL use indexes? You can check it with EXPLAIN SELECT:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
Some optimization tips you can find at:
http://dev.mysql.com/doc/mysql/en/MySQL_Optimisation.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
