Re: 45 minutes to check table to complete
Peter J. Schoenster wrote: Hi, I've got a database that is closed to 7G. I'm using the Standard4.1.14 version. The table was corrupt and I had to do a lot of moving of data to free up enough space on the partition as I discovered I needed at least twice the database size to do a recover. Well, using myisamchk -o worked. I then ran check table in the mysql client to see what it would say. It said all was well. I'm just suprised that it took 45 minutes to run. Anyone run check table on large databases? What kind of times did you encounter? I must say this is on an OLD box ... maybe 512 RAM and right now I don't now the disk drives used. 45 minutes makes sense. You need more memory for things to go faster, as caching more of the 7GB database would help things a lot, otherwise things become disk i/o bound, and that is likely what you are seeing here. Once you have the extra memory the next step is tuning MySQL to take advantage of it depending on the storage engine you are using. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
45 minutes to check table to complete
Hi, I've got a database that is closed to 7G. I'm using the Standard 4.1.14 version. The table was corrupt and I had to do a lot of moving of data to free up enough space on the partition as I discovered I needed at least twice the database size to do a recover. Well, using myisamchk -o worked. I then ran check table in the mysql client to see what it would say. It said all was well. I'm just suprised that it took 45 minutes to run. Anyone run check table on large databases? What kind of times did you encounter? I must say this is on an OLD box ... maybe 512 RAM and right now I don't now the disk drives used. Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight
Gleb Paharenko wrote: Hello. I've taken this information from documentation at http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html Did it solve your problem? If didn't, send me you my.cnf file and information about version of MySQL and operating system. The docs are old, they changed the syntax mysql 4.1.7 running on windows 2000 server, dual 2.8 xeon with 1 gig of ram I do not have any myisamchk options specified in the my.ini I let it run for 2 weeks, and I killed it the data file is good, it sat for 2 weeks indexing, at least as far as I can tell is this normal for mysql? I have some bigger tables, guess I better migrate to a database that handles big files quick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight
Hello. I've taken this information from documentation at http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html Did it solve your problem? If didn't, send me you my.cnf file and information about version of MySQL and operating system. matt_lists [EMAIL PROTECTED] wrote: Gleb Paharenko wrote: Hello. There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or in my.cnf. myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M it's no longer -O sort_buffer=xxxM it's now --sort_key_blocks and I set it to 512M and it still said there was not enough -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk sort buffer too small, check table has ran 1 week and no end in sight
Are these critical errors? It keeps on going, saying it's fixing records I tried doing a check table on the main server, it's been running a week and who knows how long that'll take myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M --read_buffer_size=8M 321st_stat - parallel recovering (with sort) MyISAM-table '321st_stat' Data records: 0 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 myisamchk: error: sort_buffer_size is to small MyISAM-table '321st_stat' is not fixed because of errors Try fixing it by using the --safe-recover (-o), the --force (-f) option or by no t using the --quick (-q) flag - recovering (with sort) MyISAM-table '321st_stat' Data records: 0 - Fixing index 1 3287000 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight
Hello. There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or in my.cnf. matt_lists [EMAIL PROTECTED] wrote: Are these critical errors? It keeps on going, saying it's fixing records I tried doing a check table on the main server, it's been running a week and who knows how long that'll take myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M --read_buffer_size=8M 321st_stat - parallel recovering (with sort) MyISAM-table '321st_stat' Data records: 0 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 myisamchk: error: sort_buffer_size is to small MyISAM-table '321st_stat' is not fixed because of errors Try fixing it by using the --safe-recover (-o), the --force (-f) option or by no t using the --quick (-q) flag - recovering (with sort) MyISAM-table '321st_stat' Data records: 0 - Fixing index 1 3287000 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight
Gleb Paharenko wrote: Hello. There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or in my.cnf. myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M it's no longer -O sort_buffer=xxxM it's now --sort_key_blocks and I set it to 512M and it still said there was not enough -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CHECK TABLE looks up all databases.
Fredrik Carlsson [EMAIL PROTECTED] wrote: I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run these commands on table1 mysql seems to lock up all other databases, is it possible to run these things in the background so that other databases can be accessible. No. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CHECK TABLE looks up all databases.
Hi, I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run these commands on table1 mysql seems to lock up all other databases, is it possible to run these things in the background so that other databases can be accessible. // Fredrik Carlsson. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
check table
All: I would like to run the check table tablename medium statement on a regular basis. We use InnoDB exclusively (go Heikki!). My problem is that the documentation seems to indicate the data can be changed. I am specifically referring to this phrase in the docs: So, these are my questions: Note: In some cases, CHECK TABLE will change the table! This happens if the table is marked as ``corrupted'' or ``not closed properly'' but CHECK TABLE doesn't find any problems in the table. In this case, CHECK TABLE marks the table as okay. 1. What causes this statement to change data? I think what is being said is that if, during the check, the table is found to be corrupt or not closed properly, it will be changed. This leads to the next question: 2. What are the nature of the changes to the data? 3. What information do I get about data that has changed from the server? 4. The doc is unclear about what is performed for InnoDB specifically. I am assuming it the same operation as for MyISAM but would like to have this clarified. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Performance of CHECK TABLE REPAIR TABLE
Gowtham Jayaram [EMAIL PROTECTED] wrote: - Are there any benchmarks that provide information on time taken to run 'CHECK TABLE' and/or 'REPAIR TABLE' on tables of different sizes ? You can run your own benchmarks and find out the statistics you need. - What are the factors that effect the time taken to run 'CHECK TABLE' and/or 'REPAIR TABLE' on a table other than its size? MySQL server parameters, number of indexes, hardware, disk throughput .. - Are there any pointers to optimize the performance of these commands ? Read about myisam_sort_buffer_size, myisam_max_extra_sort_file_size, myisam_repair_threads, myisam_max_sort_file_size options: http://www.mysql.com/doc/en/SHOW_VARIABLES.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Performance of CHECK TABLE REPAIR TABLE
Hello All: - Are there any benchmarks that provide information on time taken to run 'CHECK TABLE' and/or 'REPAIR TABLE' on tables of different sizes ? - What are the factors that effect the time taken to run 'CHECK TABLE' and/or 'REPAIR TABLE' on a table other than its size? - Are there any pointers to optimize the performance of these commands ? Thank you. Gowtham. __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CHECK TABLE results
I'm getting an error when trting to update a table: ERROR 1034: Incorrect key file for table: 'Jan04'. Try to repair it So I ran CHECK TABLE, What does this result mean: mysql CHECK TABLE Jan04 QUICK; +---+---+--++ | Table | Op| Msg_type | Msg_text | +---+---+--++ | logs.Jan04 | check | warning | Table is marked as crashed | | logs.Jan04 | check | warning | 4 clients is using or hasn't closed the table properly | | logs.Jan04 | check | error| Can't read key from filepos: 22400088064 | | logs.Jan04 | check | error| Corrupt | +---+---+--++ 4 rows in set (14 min 23.80 sec) Thanks Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: check table type
Daniel Rossi [EMAIL PROTECTED] wrote: hi i was wondering if there is a way to check for a table type ? SHOW CREATE TABLE, SHOW TABLE STATUS. ie i have an authentication class, in some situations it uses innodb and sometimes its myisam and currently its not autocomitting -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
check table type
hi i was wondering if there is a way to check for a table type ? ie i have an authentication class, in some situations it uses innodb and sometimes its myisam and currently its not autocomitting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Check table script
Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Jean, Have you tried adding [mysqladmin] user=root password=blabla to the .my.cnf file for the user running the script? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
At 15:14 -0500 8/4/03, Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: -p doesn't take '=[pswd]'. If you wrote something like -p=pswd, it would take the '=' character as part of the password. You should use either -ppswd (no intervening space) or --password=pswd if you want to do this. /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
At 16:57 -0400 8/4/03, walt wrote: Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Jean, Have you tried adding [mysqladmin] user=root password=blabla to the .my.cnf file for the user running the script? You probably meant to say the [mysqlcheck] group here. The [mysqladmin] group would be read only by the mysqladmin program. walt -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Check table wildcard syntax?
I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no smart way of doing this? version 3.23.49-log regards, -sig -- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og såntSystems consultant and such Linpro A/S http://www.linpro.no/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table wildcard syntax?
The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery - Original Message - From: Sigurd Urdahl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:26 PM Subject: Check table wildcard syntax? I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no smart way of doing this? version 3.23.49-log regards, -sig -- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og såntSystems consultant and such Linpro A/S http://www.linpro.no/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table wildcard syntax?
Matthew McNicol [EMAIL PROTECTED] writes: The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM I thought the recommended way was using CHECK/ REPAIR TABLE from inside mysql for the supported backends? Also, (my)isamchk can't be run while the database is running, can it? (I might be confused here) -sig -- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og såntSystems consultant and such Linpro A/S http://www.linpro.no/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table wildcard syntax?
I thought the recommended way was using CHECK/ REPAIR TABLE from inside mysql for the supported backends? Also, (my)isamchk can't be run while the database is running, can it? (I might be confused here) I'm just reading from the manual... it's not totally clear... perhaps someone else will help out. 4.4.4 CHECK TABLE Syntax CHECK TABLE works only on MyISAM and InnoDB tables. On MyISAM tables, it's the same thing as running myisamchk --medium-check table_name on the table. 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery Starting with MySQL Version 3.23.13, you can check MyISAM tables with the CHECK TABLE command. To check/repair MyISAM tables (`.MYI' and `.MYD') you should use the myisamchk utility. If you mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and ensure that no one is using the tables while you are running myisamchk. In MySQL Version 3.23 the easiest way to avoid this problem is to use CHECK TABLE instead of myisamchk to check tables. - Original Message - From: Sigurd Urdahl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Matthew McNicol [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:04 PM Subject: Re: Check table wildcard syntax? Matthew McNicol [EMAIL PROTECTED] writes: The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM I thought the recommended way was using CHECK/ REPAIR TABLE from inside mysql for the supported backends? Also, (my)isamchk can't be run while the database is running, can it? (I might be confused here) -sig -- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og såntSystems consultant and such Linpro A/S http://www.linpro.no/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table wildcard syntax?
Hi! On Jul 29, Sigurd Urdahl wrote: Matthew McNicol [EMAIL PROTECTED] writes: The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM I thought the recommended way was using CHECK/ REPAIR TABLE from inside mysql for the supported backends? Also, (my)isamchk can't be run while the database is running, can it? (I might be confused here) Use mysqlcheck Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table wildcard syntax?
At 16:26 +0200 7/29/03, Sigurd Urdahl wrote: I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no smart way of doing this? mysqlcheck is a command line interface to the CHECK TABLE statement. If you invoke it like this, it will check all tables in the named database by figuring out the necessary CHECK TABLE statements and sending them to the server for you: mysqlcheck db_name Use mysqlcheck --help for more information about available options. version 3.23.49-log regards, -sig -- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og såntSystems consultant and such Linpro A/S http://www.linpro.no/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table wildcard syntax?
At 15:53 +0100 7/29/03, Matthew McNicol wrote: The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery That'll work, BUT you'd better make sure you keep the server from accessing the tables at the same time. mysqlcheck can check tables, and there is no risk of interaction with the server. Also, mysqlcheck can be run from a remote host, whereas myisamchk/isamchk must be run on the server host. - Original Message - From: Sigurd Urdahl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:26 PM Subject: Check table wildcard syntax? I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no smart way of doing this? version 3.23.49-log regards, -sig -- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og såntSystems consultant and such Linpro A/S http://www.linpro.no/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Case Sensitivity for CHECK TABLE TABLENAME??
Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark - 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
Re: Case Sensitivity for CHECK TABLE TABLENAME??
Mark: Do you have my.ini (or my.cfg) set to ignore case in table names? set-variable = lower_case_table_names=1 Gerald Jensen - Original Message - From: Mark Weiler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 5:56 PM Subject: Case Sensitivity for CHECK TABLE TABLENAME?? Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark - 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 - 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
myisampack, CHECK TABLE REPAIR TABLE
Hello all, I would like to compress some tables which have an archive purpose and thus will not suffer from the restriction of using myisampack, which implies that the tables will be read only after packing. However, we also have a database problem detection program, which will check each table in specified intervals with CHECK TABLE and if that reports a problem with REPAIR TABLE. Is it possible without a problem to run these two commands on a packed table? I couldn't find anything specific on this topic in the manual. Or is it a grey area which has not been tested yet? The MYSQL server version in use is: 3.23.47-log on Linux thanks, Markus - 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
check table
is there a way to instruct check table to check all tables without listing each table in the sql statement? - 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
MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld
Hello list! We have a dual-CPU machine with FreeBSD 4.1.1 (well-known problem with MySQL, eh? ;)) Yesterday, after our server died 4 or 5 times during 8 hours, I compiled MySQL with LinuxThreads. It works pretty cool now, but two things annoy me very much: 1. MySQL dies when I try to CHECK TABLE (output is: illegal instruction in mysqld; mysqld ended) 2. Then, I can't REPAIR TABLE. MySQL dies on it again ;) Could anyone help me? Thanks! Best regards, Konstantin Smirnov, eHouse, Moscow, Russia - 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
Re: MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld
Hi Konstantin, You don't mention what version of MySQL you are using so I will assume that you are using the most recent. There were many problems with the threads libraries and even some compiler bugs on 4.1 and 4.2. The are resolved by 4.3 and 4.4 (and soon to be 4.5) Is there any chance that you can update your server to one of these newer version. Also if you are running any other services than MySQL you may have security problems on that version. If you really need to get that particular setup going I think you will have to provide the developement team with more information. I also will assume since you build with Linux Threads you are using the latest ports. If you have with makefile you can modify confgiure to add a --with-debug to the MySQL configuration. The run MySQL with gdb and see exactly where it crashes.Also if you want to edit the Makefile you might try and remove --enable-assembler option. I would really suggest upgrading if you are going to use threaded progams. Best of luck. Ken - Original Message - From: Smirnov Konstantin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 4:24 AM Subject: MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld Hello list! We have a dual-CPU machine with FreeBSD 4.1.1 (well-known problem with MySQL, eh? ;)) Yesterday, after our server died 4 or 5 times during 8 hours, I compiled MySQL with LinuxThreads. It works pretty cool now, but two things annoy me very much: 1. MySQL dies when I try to CHECK TABLE (output is: illegal instruction in mysqld; mysqld ended) 2. Then, I can't REPAIR TABLE. MySQL dies on it again ;) Could anyone help me? Thanks! Best regards, Konstantin Smirnov, eHouse, Moscow, Russia - 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 - 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
always get error when check table
Hi, I use php to connect to mysql server. after that I check my table, myisamchk report that client not properly close the connection how to avoid this error? where should I check? thx. - 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
CHECK TABLE
Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Re: CHECK TABLE
Check table didn't exist in 3.22 Werner Stuerenburg wrote: Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 - 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
Re: CHECK TABLE
On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber [EMAIL PROTECTED] wrote: it doesn't work on 3.23.32 either! Check table didn't exist in 3.22 Werner Stuerenburg wrote: Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 - 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 Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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
RE: CHECK TABLE
3.23.38 does -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Saturday, June 30, 2001 4:35 PM To: [EMAIL PROTECTED] Cc: Werner Stuerenburg; [EMAIL PROTECTED] Subject: Re: CHECK TABLE On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber [EMAIL PROTECTED] wrote: it doesn't work on 3.23.32 either! Check table didn't exist in 3.22 Werner Stuerenburg wrote: Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 - 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 Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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 - 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