At 10:36 AM 6/25/2006, Santiago del Castillo wrote:
Hi, thanks for answering!
I am using MyISAM tables.
So, based in your answer i assume that is usual to have a lot of HD
Writing, isn't it?
Only if your application is writing to the database. If you have no
application running, then MySQL should have no activity. So you must have
some sort of application writing or reading from the database.
What does "Show ProcessList" display? (Run MySQL.Exe and run this command.)
This will tell you which user is connected to the database and what sql
command is executing. Post the results here so we can look at it.
Mike
Thanks!
Santiago
mos wrote:
At 06:55 PM 6/24/2006, Santiago del Castillo wrote:
Hi, is usual to have a lot of HD writing on a MySQL server where (according
to mytop) there are between 800 and 1200 queries per second? my MRTG is
showing a lot of HD Writing and i wanted to know if it's usual. The database
is growing about 11 MB every 3 minutes.
FYI, I don't have any log-type (binlog, queries log or slow queries log)
activated.
Well, if this keeps up, you better run out and buy more hard drives.<g>
Are you using InnoDb or MyISAM tables?
You can run "Show ProcessList" to see what task is currently executing on
the MySQL server.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
