> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, July 08, 2013 2:11 PM
> To: mysql@lists.mysql.com
> Subject: Need query to determine different column definitions across
tables
>
> I'm noticing that across our several databases and hundreds of tables
The level is the height of a B-tree table or a B-tree index in mysql 5.6.
My question is how to get the height(blevel) of a B-tree table or a B-tree
index in mysql 5.6?
Thanks.
In oracle database,we can use the following statement to query the blevel of a
index
select index_name,blevel from
See if you like this:
SELECT TABLE_SCHEMA as db, TABLE_NAME, COLUMN_NAME,
CHARACTER_SET_NAME, COLUMN_TYPE
FROM `COLUMNS`
ORDER BY 3,4,5;
You might be able to embellish on it to avoid consistent definitions, etc.
> -Original Message-
> From: Daevid Vincent [mailto:dae...
Or maybe the number of levels in the BTree?
Rule of Thumb: logarithm base 100
> -Original Message-
> From: Hartmut Holzgraefe [mailto:hart...@skysql.com]
> Sent: Monday, July 08, 2013 6:38 AM
> To: mysql@lists.mysql.com
> Subject: Re: how to get the levels of a table or a index in Mysql
I'm noticing that across our several databases and hundreds of tables that
column definitions are not consistent. I'm wondering if there is a tool or
query (using INFORMATION_SCHEMA perhaps) that will show me all databases,
tables and columns where they don't match (by column name).
For example i
On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote:
> how to get the levels of a table or a index in Mysql 5.6?
Level? What is level supposed to be in that context?
Cardinality? Or something completely different?
/me confused ...
--
Hartmut Holzgraefe
Principal Support Engineer (EMEA)
SkySQL AB - ht
Have you used pt-online-schema-change.html from
http://www.percona.com/doc/percona-toolkit/2.0/pt-online-schema-change.html ?
What do you think about this tool?
Best regards,
Rafal Radecki.
2013/7/8 Rafał Radecki
> Hi All.
>
> I would like to change the layout of my production database, I woul
- Original Message -
> From: "Rafał Radecki"
>
> I would like to change the layout of my production database, I would
> like to add a column to an existing table. As I think before the ALTER
> TABLE statement all access to the database should be denied/ended, then the
> ALTER TABLE should
Hi All.
I would like to change the layout of my production database, I would like
to add a column to an existing table. As I think before the ALTER TABLE
statement all access to the database should be denied/ended, then the ALTER
TABLE should be performed, and then user/applications should be able
