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
encounte
isamchk -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
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 th
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 P
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 s
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,
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_siz
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
> data
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 Ma
All:
I would like to run the "check table 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
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 yo
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
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
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
>
>
--
F
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:htt
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,
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 p
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 passw
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
wo
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 datab
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 (
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 CHEC
ally 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
S
"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 b
uot;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
&g
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 sepera
Sensitivity for CHECK TABLE ??
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
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
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 s
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
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.
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
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:
ht
3.23.38 does
-Original Message-
From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
Corp.]On Behalf Of MikeBlezien
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
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
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> C
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
37 matches
Mail list logo
