Hi
I have a question on the table_lock_waited and table_lock_immediate
variables
for MySQL.
On my server, am seeing the sum of 'table_lock_immediate' and
'table_lock_waited'
way less than 'Questions' for 'show status' (only about 40%). Although I do
run queries
like 'show status' they are defini
Hi
While tuning the system to minimize locking, I added SQL_BUFFER_RESULT to
some
of my select statements. Since then have been seeing a lot of
created_tmp_disk_tables
e.g. below is what I see after restarting the system for less than an hour.
| Created_tmp_disk_tables | 515 |
| Created_t