Sridhar, Wednesday, September 25, 2002, 6:11:30 PM, you wrote: >> SP> Currently i get around this issue by analyzing the BDB tables, but this >> SP> seems to be a temporary solution. The issue is intermittent, keeps >> SP> surfacing >> SP> again after a certain no of days. Did not find any related bugs with the >> SP> MySQL version we use (3.23.51). From what i can understand so far, the >> SP> index >> SP> statistics related to the BDB tables are not getting updated. >> >> SP> What can be done to correct this issue ? >> SP> Are there any other alternative's to this issue ? >> SP> Would converting the BerkleyDB (BDB) tables to InnoDB tables solve the >> SP> issue ? >> >> I tested your query on the test BDB table and it worked well, here is >> ther result that I got: >> +-----------+----------+------+ >> | order_uid | status | age | >> +-----------+----------+------+ >> | 5 | verified | 501 | >> | 4 | verified | 267 | >> +-----------+----------+------+ >> 2 rows in set (0.00 sec) >> >> Could you provide a repeatable test case? >> >> BTW if you send bug report, send output of SHOW CREATE TABLE or output >> of mysqldump, not the output of DESC table_name. >> >> I tested it on 3.23.52.
SP> Victoria, SP> As said earlier, i cannot reproduce the problem because i analyzed the SP> BDB tables yesterday. SP> If i don't analyze the tables for a week, then the above said problem SP> surfaces again. The SP> application is still in test phase and will be put into production the SP> following Monday. I SP> strongly believe this issue is some how related to BDB index link list SP> statistics that might SP> be getting corrupted. I do not know if this is due to a bug, if so i SP> cannot reproduce it, until SP> i hit the problem again. Speaking of bug, would i abe able to submit SP> this as a bug ? We need a repeatable testcase if this is a bug. Could you inform me if it appears again? In my part I'll try to play with your table. Thanks for CREATE TABLE! SP> I am seriously pondering if i had a mistake in choosing MySQL for our SP> transactional application. What about InnoDB tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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