4 messages in com.mysql.lists.win32Re: MySQL reads hardrive for a long time| From | Sent On | Attachments |
|---|---|---|
| Arch Angel | 23 Sep 2002 09:41 | |
| Petr Vileta | 24 Sep 2002 16:05 | |
| David Silvera | 26 Sep 2002 08:37 | |
| Petr Vileta | 27 Sep 2002 18:13 |
| Subject: | Re: MySQL reads hardrive for a long time![]() |
|---|---|
| From: | Petr Vileta (pvil...@top.cz) |
| Date: | 09/24/2002 04:05:41 PM |
| List: | com.mysql.lists.win32 |
Test you to defragment hardisk? This resolve problem sometime.
Petr Vileta http://www.top.cz/pvileta
Ostatne soudím, ze letní cas musí být zrusen !
----- Original Message ----- From: "Arch Angel" <ange...@hotmail.com> To: <win...@lists.mysql.com> Sent: Monday, September 23, 2002 6:41 PM Subject: MySQL reads hardrive for a long time
I have installed mysql 3.23.28, with myodbc 2.50.36 on my Windows 98 computer for a few months now, using PWS as my web server. I am only using this setup for testing of my scripts before uploading them to my server. It has been working well and a considerable speed increase over an access database I was using before.
I have a forum software on my computer that utilizes the mysql database. Since recently, when I access the forum software, the mysql server reads the hardrive for at least 1 minute before displaying the page. This goes for all pages I access in the forum software and any script I access, outside of the forum software. So I know it's not just the forum. It didn't take so long to read the database before. It took less than 1 second on most pages, less than 5 seconds on longer sql queries. But now it takes forever.
I have tried re-installing mysql but that didn't work. The sql queries are nothing intensive. Simple query commands returning very little data. With this problem, mysql now takes longer than an access database.
Anyone has any suggestions on how I can fix this problem?
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.




