Hi What else is running on the machine ?
What processes are using the computers resources ? Use top to find out. What are the memory parameters used in my.cnf ? The answers to these questions will provide some helpfull answers to your problem. Simon On Monday 30 Dec 2002 11:16 am, BPF Webmaster wrote: > I migrated my site from a low end PC mutualized hosting to a brand new > P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL > slower now, the time for a PHP page is now about 6 seconds and was about > .6 before!!! > > I haven't done any optimization and the DB is the same, so the size > (about 10,000 records). > > The only 2 weaknesses I saw is that: > 1- I use a RedHat 7.3 RPM (haven't compiled myself) > 2- the database folder is on another partition linked from /var/... to > /home/... but on the same disk (a fast 10Krpm UW-SCSI). > > What would you advise? > > JM > > An example at http://www.labdv.com/forum/index.php > > > --------------------------------------------------------------------- > 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 -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 --------------------------------------------------------------------- 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