Re: Temporary tables created on disk: 99%

2010-06-01 Thread Rob Wultsch
On Tue, Jun 1, 2010 at 8:40 AM, John G. Heim wrote: > On my db server, mysql has 2 gigabytes for temporary tables and yet its > creating 99% of temporary tables on disk. > > According to mysqltuner, 99% of temporary tables are created on disk. Probably blobs: "Instances of BLOB or TEXT columns in

Temporary tables created on disk: 99%

2010-06-01 Thread John G. Heim
On my db server, mysql has 2 gigabytes for temporary tables and yet its creating 99% of temporary tables on disk. According to mysqltuner, 99% of temporary tables are created on disk. I've confirmed this via the "show global status like 'created%'" command. This is in spite of having the foll