Edilson, Friday, May 3, 2002, 3:17:11 AM, you wrote:
EVdMJ> I have a table that has now about 100000 records (about 100bytes each one). EVdMJ> My queries were too slow and some time a lost connection. But now i can't do EVdMJ> anything with this table :( Show us the structure of the table and provide more information: what is the hardware you are running MySQL on, how many RAM the box has, which MySQL version are you using, how MySQL is compiled, configured and so on. EVdMJ> Even "SELECT * FROM mytable LIMIT 1" doesn't EVdMJ> return a value... Is my table crashed? What should i do now? I can't drop EVdMJ> the table because some data (about 100records) is important. You may try to recreate indexes. See http://www.mysql.com/doc/T/a/Table_maintenance.html for more information on that. EVdMJ> Dirso. -- For technical support contracts, goto https://order.mysql.com/ 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