[ENG] mysql uses all my disk time

When the mysql starts (as a service) then the hard disk doesn't stop to be
used. Then when I stop the service, the disk isn't used anymore. I've tried
to know what does the mysql server using phpmyadmin but the page doesn't
start as the process seems to take all the computer ressources.

Any idea of what it's appening. I'm using the my-medium.ini as ini file...

Bob

Re: [ENG] mysql uses all my disk time

"Bob Bedford" wrote:

> When the mysql starts (as a service) then the hard disk doesn't stop to be
> used. Then when I stop the service, the disk isn't used anymore.

What do you mean by "the harddisk is being used"? It is spinning all
the time anyway. And sometimes some programm (or the operating system)
reads or writes data from/onto it. How do you know it's MySQL accessing
your harddisk? What is MySQL writing in the errorlog?

> Any idea of what it's appening.

Look into MySQLs logfile. If you can connect to MySQL use SHOW FULL
PROCESSLIST.

My crystal ball offers "MySQL is checking tablespaces because it was
shutdown uncleanly" as well.


XL

Re: [ENG] mysql uses all my disk time

> My crystal ball offers "MySQL is checking tablespaces because it was
> shutdown uncleanly" as well.
Rigth, I've seen in the log and there was an error.

Thanks for help.

Bob