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
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