I have a script written in python running on Suse linux using mySQL 3.23.32. There are two tables each with an auto-increment key and one index. Table 1 has a maximinum of 1,000,000 records and table 2 has a maxminum of 20,000,000 records. The script performs a mixture of inserts, updates, deletes and selects. it has an output line every 10 seconds saying how many records have been written since the last sample. I set it running @ 6.00 last friday and performance started @ 1200 transaction per second and degraded gradually to about 12 a second. I then connected to mysql and asked for the count of both tables, 'select count(*) from table_name'. After the query, performance went up to 700/sec degrading after an hour or so the aroung 500/sec. Can anyone offer an explanation to this interesting result.
Dave French. NOTICE & DISCLAIMER This email including attachments (this "Document") is confidential and may contain legally privileged information. If you have received this Document in error please notify the sender immediately and delete this Document from your system without using, copying, disclosing or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of this Document. The information contained in this Document is provided solely for information purposes on an "as is" basis without warranty of any kind, either express or implied, including without limitation any implied warranty of satisfactory or merchantable quality, fitness for a particular purpose or freedom from error or infringement. The user relies on the information contained herein, and its accuracy or otherwise, entirely at their own risk. Any opinions expressed in this Document are those of the author and do not necessarily reflect the opinions of Telsis. We will not accept responsibility for any commitments made by our employees outside the scope of our business. --------------------------------------------------------------------- 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
