2010/4/7 Carsten Pedersen cars...@bitbybit.dk:
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
On Thu, Apr 8, 2010 at 9:33 AM, spacemarc spacem...@gmail.com wrote:
2010/4/7 Carsten Pedersen cars...@bitbybit.dk:
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
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't works: how to set the query?
Thanks
--
MySQL General Mailing List
For list archives: http
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't
$ watch -d mysqlshow --status myDB #shows the count of rows is
constantly fluctuating for some tables, even though the database is
offline. There ought to be a note about it here and on HELP SHOW TABLE STATUS;
Must use
o --count
Show the number of rows per table.
(Which also
.
The first task I need to run is to determine the database table storage engines
(all make use of MyISAM, InnoDB and Archive), then update frequency and row
numbers.
Now if I use:
show table status from database name;
It will list all the table information I need however, what I am trying to
figure
version, some installations
have just 2 or 3 databases some have 20 or more.
The first task I need to run is to determine the database table storage
engines (all make use of MyISAM, InnoDB and Archive), then update frequency
and row numbers.
Now if I use:
show table status from database
databases some have 20 or more.
The first task I need to run is to determine the database table storage
engines (all make use of MyISAM, InnoDB and Archive), then update frequency
and row numbers.
Now if I use:
show table status from database name;
It will list all the table information I
Hi,
we are using MySQL Cluster 5.0.27 on Solaris 9 Sparc.
The packages are from mysql.com.
Doing an show table status on a database with the ndb
engine returns 0 for rows count, average row length etc.
Hm, i have read that such a bug existed and has been
fixed with 5.0.3. So i am wondering what
I have a serius probleam , my backup system see the FK's with show
table status like 'tablename' , and read the Comment column...
in mysql 4.x works fine... but em 5.x the FK's has cuted
ex:
| apresentante | InnoDB | 9 | Redundant | 44 |372
| 1
6384
Hi,
I have a serius probleam , my backup system see the FK's with show
table status like 'tablename' , and read the Comment column...
in mysql 4.x works fine... but em 5.x the FK's has cuted
This didn't work fine in 4.x at all. The comments columns
was being misused to report FKs. Even
the size of my databases I use the 'show table status'
command and I ignore .frm file size.
Kind regards,
--
Martijn
--
The information contained in this communication and any attachments is
confidential and may be privileged, and is for the sole use of the intended
recipient(s). Any
Jaspreet Singh wrote:
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Qus 2. Is there any other way
Hello,
Does anyone know where (c-api functions perhaps) SHOW TABLE STATUS
gets its info from?
Specifically, the new columns added in 4.1.2 and 4.1.3, are they the
result of underlying c-function changes, new functions, or something
else.
Thanks
Michael
--
MySQL General Mailing List
For list
Hi, there,
We have a huge database (84 tables of about 360 G of data in MyISAM
tables). Recently, we converted the entire database to InnoDB (in one
table space) and set up replication. Then we experienced some slower
performance.
For example, show table status on the master took more
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). Recently
defined
tables does not exceed 10.The size of each table also does not exceed 10 rows.
We executed 'show table status' command and it gave innodb freespace:4092 KB.
What does that mean?How come system tables and user defined tables(which are
not more than 10) occupy 6MB?Does mysql does 10MB
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 bug report and work
, 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 earlier
than
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
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
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
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.
What's
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
Hi,
Currently, a VIEW lists NULL as value for the Engine column in
the SHOW TABLE STATUS resultset. Is this the right behaviour?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL
Hi all,
I just noticed that the MySQL 4.1.latest version handles
a SHOW TABLE STATUS different from 4.1.1!
Instead of a field Type that holds the table type, it's
now Engine.
Just a quick question: who makes up these changes in
a minor minor (x.x.x) release What do they expect
from third
the 4.x series, but likely
will be removed in MySQL 5.1.
So I assume it makes sense to change it also for SHOW TABLE STATUS :)
Well, in that case - the documentation fails to document the behaviour :-)
The latest 4.1 beta does NOT have a Type column.
Remove it in 5 or 5.1, fine - that's a major
become
deprecated. TYPE will be supported throughout the 4.x series, but likely
will be removed in MySQL 5.1.
So I assume it makes sense to change it also for SHOW TABLE STATUS :)
Well, in that case - the documentation fails to document the behaviour :-)
The latest 4.1 beta does NOT have
deprecated. TYPE will be supported throughout the 4.x series, but likely
will be removed in MySQL 5.1.
So I assume it makes sense to change it also for SHOW TABLE STATUS :)
Well, in that case - the documentation fails to document the behaviour :-)
The latest 4.1 beta does NOT have a Type column
the 4.x series, but
likely
will be removed in MySQL 5.1.
So I assume it makes sense to change it also for SHOW TABLE STATUS :)
Well, in that case - the documentation fails to document the behaviour
:-)
The latest 4.1 beta does NOT have a Type column.
The current manual does document
I try to take a look on the table1 status
by:
mysql show table status from jean1;
It gave me the following error:
ERROR 12: Can't read dir of './jean1/' (Errcode: 2)
I think it supposes that there would be a sub-directry
under .../jeandatabase/, and named jean1.
But when I cd to /usr/local
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 TABLENAME not your database's name. Try this:
SHOW TABLE STATUS FROM jeandatabase
and see if it works
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 TABLE
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:
Show
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 name. See
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
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 574. I am running
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
I'm running 4.1.1a-alpha-max-nt using innodb tables with foreign keys .
I know how to use SHOW TABLE STATUS to see the referential linkages in the
COMMENT column.
Supppose I am typing away in MySQL monitor:
Q: Is there a way to create a table from the SHOW TABLE STATUS command ?
Q: Does v5 have
Richard A. DeVenezia [EMAIL PROTECTED] wrote:
I'm running 4.1.1a-alpha-max-nt using innodb tables with foreign keys .
I know how to use SHOW TABLE STATUS to see the referential linkages in the
COMMENT column.
Supppose I am typing away in MySQL monitor:
Q: Is there a way to create a table
On Fri, 2004-04-30 at 06:03, Richard A. DeVenezia wrote:
I'm running 4.1.1a-alpha-max-nt using innodb tables with foreign keys .
I know how to use SHOW TABLE STATUS to see the referential linkages in the
COMMENT column.
Supppose I am typing away in MySQL monitor:
Q: Is there a way
(),$sql)); }
The result is expected:
B MySQL error: Table 'f' was not locked with LOCK TABLES
SQL: SELECT * FROM firmy AS f
C MySQL error: Table 'test' was not locked with LOCK TABLES
SQL: INSERT INTO test SET id = NULL
The output doesn't change, until PhpMyAdmin sends
SHOW TABLE STATUS
It looks as though, when I go into my databases, and use the command
SHOW TABLE STATUS, that InnoDB tables do not have some information.
I am on MySQL 4.1.0-alpha-debug. Has this been fixed in later versions?
Example:
mysql show table status
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
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
after
the LIKE statment.
Slow? How many tables
STATUS command, but if there are many tables in a
database this command is very slow, even if a specific table name is
after
the LIKE statment.
Slow? How many tables are we talking about?
I'm talking about nearly 20 000 tables in a database.
In this case a SHOW TABLE STATUS commande takes about
Hi,
I have noticed also that SHOW TABLE STATUS became slower in 5 times at least
(from 1 sec to 5-6 secs).
Since I've switched to version 3.23.53 to version 4.0.14.
But I have changed type of all my tables (~30 tables) from MyISAM to InnoDB
as well.
How long does an ls command in the database
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
after
the LIKE statment.
Slow? How many tables are we talking about?
I'm talking about nearly 20 000 tables in a database
Hi!
How an i get the last Check-time of a specific table without using LIKE
statements?
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 after
the LIKE statment.
Thanks
--
MySQL General Mailing List
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
Hi all,
My MySQL crashed during simultaneous execution of ALTER TABLE ... ENABLE
KEYS
and SHOW TABLE STATUS statements.
There were 2 threads: #3 and #4.
In thread #4 I executed:
4 Query DROP TABLE IF EXISTS History
4 Query CREATE TABLE History ...
4 Query
-variables' from a shell prompt crashes the database. the
database then restarts. this appears to be 100% repeatable on my
install.
Also, I cannot execute 'show table status from [tablename]'. All of my
tables happen to be InnoDB tables.
However, executing only 'show table status' or 'mysqlshow --status
, July 03, 2002 01:51
To: [EMAIL PROTECTED]
Subject: BUG: SHOW TABLE STATUS InnoDB Tables
Hi,
I have just noticed that SHOW TABLE STATUS is returning different number of
rows each time you execute the query. This seams to affect only InnoDB
Tables (Although I have tested only with ISAM/MyISAM/InnoDB
Hi,
I have just noticed that SHOW TABLE STATUS is returning different number of
rows each time you execute the query. This seams to affect only InnoDB
Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables).
I'm using MySQL 3.23.49Max on WIN2K.
How to repeat the problem:
Execute
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
rows each
sql,query
At 21:50 -0300 7/2/02, Crercio O. Silva wrote:
PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables
with large number of rows (my tables have -+ 30 records each) it take a
few seconds to get the results.
This is not a big issue for me, but I'd like to confirm
hello,
i'm using mysql 3.23.51-max on windows 98. It worked fine up until the
point where I started using a PHP app that used the command SHOW TABLE
STATUS FROM tablename.
Everytime this is executed Mysql gives me a dialog window that says Test
Signal with an OK button, then I get an illegal op
Hi, my problem is that when i do a
show table status like al%
one of my innodb tables (named
'aluno') says to have 255 rows.
But, in fact, it have 286 rows, by:
select count (*) from aluno;
Someone can help me
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.
Thanks in advance
mark
-
Before posting, please check:
http://www.mysql.com
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
Why don't you :
select timestampfield from mytable order timestampfield decs limit 1
Jay Lawrence wrote:
Atle, your suggestion is for the last time a record was updated. I am
interested in the entire table.
The closest that I have seen thus far is:
SHOW TABLE STATUS
The Update_time
Atle, your suggestion is for the last time a record was updated. I am
interested in the entire table.
The closest that I have seen thus far is:
SHOW TABLE STATUS
The Update_time field is most likely what I am after.
However I was hoping to do something more like
select Update_time from
63 matches
Mail list logo
