Hi, I am running 2 database on the same MySQL server on one machine. When running this configuration, I notice that the disk usage is very high. On other hand, If run just one workload, the disk usage is very low. To be certain, I ran 2 servers running 1 database each on different ports. I see the same results with config too.
Just some numbers to clarify: I ran "vmstat 1". The bi is ~4000 when running 2 databases while only ~500 when running 1 database. Questions: Does MySQL flush its cache or some internal memory everytime it executes a query for another database? Thanks, Gokul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]