On Thu, Apr 8, 2010 at 9:33 AM, spacemarc wrote:
> 2010/4/7 Carsten Pedersen :
> > AFAIR, MySQL 4.x supports LIKE, e.g.
> >
> > SHOW TABLE STATUS LIKE 'tab_%'
>
> yes, but if the tables have different names (table1, tab_2, abcd... )
> your syntax will not work. How to do?
>
Multiple statements.
2010/4/7 Carsten Pedersen :
> AFAIR, MySQL 4.x supports LIKE, e.g.
>
> SHOW TABLE STATUS LIKE 'tab_%'
yes, but if the tables have different names (table1, tab_2, abcd... )
your syntax will not work. How to do?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
AFAIR, MySQL 4.x supports LIKE, e.g.
SHOW TABLE STATUS LIKE 'tab_%'
/ Carsten
spacemarc skrev:
hi all,
in MySQL 4.1.x i want to obtain the status of more tables with one only query.
In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')"
In 4.1.x i tried to use but it doesn'
My experience with innodb is that show table status is slow. It's
better to do show table status like 'my_table'
-Eric
On Thu, 10 Feb 2005 16:47:41 -0500, Zhe Wang <[EMAIL PROTECTED]> wrote:
> Hi, there,
>
> We have a huge database (84 tables of about 360 G of data in MyISAM
> tables). Rece
lto:[EMAIL PROTECTED]
Sent: Wednesday, December 29, 2004 6:23 PM
To: Robinson, Eric
Cc: Mikael Fridh; mysql@lists.mysql.com
Subject: RE: SHOW TABLE STATUS: Update_Time Is Wrong?
Eric,
I'm glad that last answer worked, but I'm wondering what exactly you did
to resolve the problem? I see the
Eric,
I'm glad that last answer worked, but I'm wondering what exactly you did
to resolve the problem? I see the bug report and work around. But what
specifically did you do, what did you type to fix it? By the way, what
operating system are you using for your servers?
--
MySQL General Mail
That looks like a direct hit. Thanks!
--
Eric Robinson
-Original Message-
From: Mikael Fridh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 29, 2004 1:06 PM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: SHOW TABLE STATUS: Update_Time Is Wrong?
Robinson, Eric wrote
Robinson, Eric wrote:
When I execute SHOW TABLE STATUS on my master replication server, it
shows an Update_Time for some tables that is more than 2 hours earlier
than the Update_Time for the same tables on the slave server. However
the bin log names, positions, and number or records are correct.
Wh
esday, December 28, 2004 8:15 PM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: SHOW TABLE STATUS: Update_Time Is Wrong?
Robinson, Eric wrote:
> When I execute SHOW TABLE STATUS on my master replication server, it
> shows an Update_Time for some tables that is more than 2 hours ear
Robinson, Eric wrote:
When I execute SHOW TABLE STATUS on my master replication server, it
shows an Update_Time for some tables that is more than 2 hours earlier
than the Update_Time for the same tables on the slave server. However
the bin log names, positions, and number or records are correct.
Wh
Paul,
> >> >From the MySQL doc :
> >>
> >> The ENGINE and TYPE options specify the storage engine for the table.
> >> ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is
the
> >> preferred option name as of those versions, and TYPE has become
> >> deprecated. TYPE will be su
At 14:36 +0200 7/28/04, Martijn Tonies wrote:
Hi Jocelyn,
>From the MySQL doc :
The ENGINE and TYPE options specify the storage engine for the table.
ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the
preferred option name as of those versions, and TYPE has become
deprec
In the last episode (Jul 28), Martijn Tonies said:
> Hi Jocelyn,
> > >From the MySQL doc :
> >
> > The ENGINE and TYPE options specify the storage engine for the table.
> > ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is
> > the preferred option name as of those versions, and
Hi Jocelyn,
> >From the MySQL doc :
>
> The ENGINE and TYPE options specify the storage engine for the table.
> ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the
> preferred option name as of those versions, and TYPE has become
> deprecated. TYPE will be supported throughou
Hello,
Thank you very much, everyone.
Yes, I want to know the table "jean1" status.
I tried:
show table status like "jean1"
It works.
Thanks a lot.
Jean
--- mos <[EMAIL PROTECTED]> wrote:
> Jean,
> The "from jean1" is looking for a database
> named "jean1", it is
> not the table n
Jean,
The "from jean1" is looking for a database named "jean1", it is
not the table name. See
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
If you are already connected to the database, just use:
Show Table Status;
If you want status for a particular table then try:
Sh
Jean Zhong wrote:
mysql> show table status from jean1;
It gave me the following error:
ERROR 12: Can't read dir of './jean1/' (Errcode: 2)
In "SHOW TABLE STATUS", the thing after the "FROM" is a database name.
See here:
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
You want
SHOW TAB
Jean,
Here is the format for the SHOW TABLE STATUS command from
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html:
SHOW TABLE STATUS [FROM db_name] [LIKE wild]
You are using FROM not your database's name. Try this:
SHOW TABLE STATUS FROM jeandatabase
and see if it works better ;)
Respe
Daniel Kasak wrote:
Andrew Barnes wrote:
When I run the "SHOW TABLE STATUS" query against a database with 4
tables, 3
of the tables come have the correct row count, but 1 table changes the
No of
rows every time I run the query. The correct row count for this table is
313, but the query returns an
Andrew Barnes wrote:
Hi
When I run the "SHOW TABLE STATUS" query against a database with 4 tables, 3
of the tables come have the correct row count, but 1 table changes the No of
rows every time I run the query. The correct row count for this table is
313, but the query returns anywhere from 97 to 5
At 8:10 +0200 11/25/03, Jozsa Boti wrote:
> >Hi!
Please reply to the list, not to me personally, so that others can
follow this discussion. Thanks.
Sorry,
No apology required. It's just that others may have something to
contribute.
I was able to duplicate your results and raised the question
On Nov 25, 2003, at 1:10 AM, Jozsa Boti wrote:
Please reply to the list, not to me personally, so that others can
follow this discussion. Thanks.
Sorry,
Don't feel bad. The list admins could easily set up the list so that
the default action when replying is the correct one, but apparently
choo
> >Hi!
>
> Please reply to the list, not to me personally, so that others can
> follow this discussion. Thanks.
>
Sorry,
> >
> >
> >
> >> At 13:21 +0200 11/21/03, Jozsa Boti wrote:
> >> >Hi!
> >> >
> >> >How an i get the last Check-time of a specific table without using
LIKE
> >> >state
ot; command in the database directory take?
less than 1 sec.
Thanks,
Mikhail.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jozsa Boti" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 5:36 PM
Subject: Re: SHO
Hi!
Please reply to the list, not to me personally, so that others can
follow this discussion. Thanks.
At 13:21 +0200 11/21/03, Jozsa Boti wrote:
>Hi!
>
>How an i get the last Check-time of a specific table without using LIKE
>statements?
There isn't another way.
>There's the SHOW TABLE
At 13:21 +0200 11/21/03, Jozsa Boti wrote:
Hi!
How an i get the last Check-time of a specific table without using LIKE
statements?
There isn't another way.
There's the SHOW TABLE STATUS command, but if there are many tables in a
database this command is very slow, even if a specific table name is
>From the manual :
Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimization. Table and index reserved
sizes in bytes are accurate, though.
CB.
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Ju
Crecrio,
- Original Message -
From: ""Crercio O. Silva"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 3:49 AM
Subject: BUG: SHOW TABLE STATUS & InnoDB Tables
> Hi,
>
> I have just noticed that SHOW TABLE STATUS is returning different number
of
>
Hi,
> For show table status command in MySQL, which field is indicate the
> table size? Or, Which command is to find out the database size.
The 'Data_length' field in the SHOW TABLE STATUS output will tell you how
big the data is (in bytes). Bear in mind this doesn't give the actual size
taken
29 matches
Mail list logo
