As I've got a lot of mysql I/O on my server I took a look at the status and here's what I got:
| Created_tmp_disk_tables | 181256 | | Created_tmp_tables | 337140 | which should mean that more than half of the queries ends up on disk, even though: | tmp_table_size | 104857600 | Is there a way of knowing which are the queries that end up creating a temporary disk table and/or how big should the tmp_table_size so to have everything (or at least most of it) in memory? -- - .a.c. - Andrea Carpani - <[EMAIL PROTECTED]> http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) _______________________________________ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. _______________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php