. 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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,
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
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
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
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
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
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
.
- 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
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
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
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
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
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
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
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:
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
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
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
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
37 matches
Mail list logo