John, Tuesday, August 20, 2002, 5:27:27 PM, you wrote: JW> Ta,
JW> But is it normal to have Temp table bigger than 10meg? And a lot of them? JW> Here is my latest data from STATUS JW> Created_tmp_disk_tables 46598 JW> Created_tmp_tables 87839 JW> Uptime 81773 JW> And I have set tmp_table_cache to 10M JW> I know I could just up the tmp_table_size but I am more concerned about the JW> size of the tmp tables and the number of them. JW> I am running an in house build CMS and running phorum. I get about 100,000 JW> page views an hour. It depends on your queries and tables that are involved. MySQL uses temporary table for some queries. So, if tables are large, temporary tables are also large.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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