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
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
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
Hi
how to get the levels of a table or a index in Mysql 5.6?
thanks
The information in this email is confidential and may be legally privileged. If
you have
Hi Peter (and MySQL list),
On Wed, Jan 13, 2010 I (Ricardo Dias Marques) asked the following :
>>It would be convenient for me to get a list of those fields ordered by
>>field / column name.
... and on the same day, Peter Brawley
kindly replied:
> SELECT *
> FROM information_schema.columns
>
It would be convenient for me to get a list of those fields ordered by
field / column name.
SELECT *
FROM information_schema.columns
WHERE table_schema='db' AND table_name='tbl';
PB
-
Ricardo Dias Marques wrote:
Hi all,
I have a Linux server with MySQL 5.0 (5.0.67) installed.
In that
Hi all,
I have a Linux server with MySQL 5.0 (5.0.67) installed.
In that server, I have a database that has a table with many fields (around 60).
It would be convenient for me to get a list of those fields ordered by
field / column name. Unfortunately, a "DESC tablename ("DESCRIBE
tablename") co
[EMAIL PROTECTED],
hi,
i'm created a 'configuration' table:
create cofiguration (
config_key VARCHAR(25) NOT NULL PRIMARY KEY,
config_value VARCHAR(255) NOT NULL
) ENGINE=MyISAM;
I have about 30 records (store_name, store_owner, template_name,
website_width, owner_address, prodcuts_per_page,..
hi,
i'm created a 'configuration' table:
create cofiguration (
config_key VARCHAR(25) NOT NULL PRIMARY KEY,
config_value VARCHAR(255) NOT NULL
) ENGINE=MyISAM;
I have about 30 records (store_name, store_owner, template_name,
website_width, owner_address, prodcuts_per_page,..).
now i wonder is m
Daniel, you might look into the use of MERGE tables, which are
essentially multipule identical MyISAM tables that look like one
table.
Dan
On 11/27/06, Chris White <[EMAIL PROTECTED]> wrote:
On Monday 27 November 2006 13:50, Daniel Smith wrote:
> Assuming a decent spec server, would a simple s
On Monday 27 November 2006 13:50, Daniel Smith wrote:
> Assuming a decent spec server, would a simple search query on a big
> indexed table be quicker than searching the amount of data divided into
> separate tables?
I'd recommend a single large table with a DATE/DATETIME field which would be
con
Assuming a decent spec server, would a simple search query on a big
indexed table be quicker than searching the amount of data divided into
separate tables?
The kind of situation I have in mind is a database of events during a
year, this table could top 1,000,000 enteries on the vague kind of
sche
On Mon, 2006-10-09 at 14:13 -0700, Bruce Dembecki wrote:
> On Oct 9, 2006, at 7:15 AM, Ow Mun Heng wrote:
>
> > Hi All,
> >
> > Just wanted to know if it would be faster/better to implement this
> > option into my.cnf
> >
> > innodb_file_per_table = 1
> >
> > which would essentially make each tabl
On Mon, 2006-10-09 at 15:42 -0600, James Eaton wrote:
> - Original Message -
> From: "Bruce Dembecki" <[EMAIL PROTECTED]>
> To:
> Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
> How do you go about converting InnoDB databases from the single tablespace
> to those using the table-per-file file o
- Original Message -
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To:
Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2006 3:13 PM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
There are some minor performance benefits here whe
On Oct 9, 2006, at 7:15 AM, Ow Mun Heng wrote:
Hi All,
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's own rather than
have it all in 1 file.
My belief is that it would be sl
In the last episode (Oct 09), James Eaton said:
> From: "Dan Nelson" <[EMAIL PROTECTED]>
> >I don't think that the number of files has any impact on query
> >speed. The advantage file-per-table gives you is the ability to
> >recover unused space easily by running OPTIMIZE TABLE. With a
> >single t
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Ow Mun Heng" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 09, 2006 9:12 AM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
In the last episode (Oct 09), Ow Mun Heng said:
Ju
In the last episode (Oct 09), Ow Mun Heng said:
> Just wanted to know if it would be faster/better to implement this
> option into my.cnf
>
> innodb_file_per_table = 1
>
> which would essentially make each table a file on it's own rather
> than have it all in 1 file. My belief is that it would b
Hi All,
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's own rather than
have it all in 1 file.
My belief is that it would be slightly more advantageous compared to 1
BIG file.
At 08:54 AM 7/13/2006, abhishek jain wrote:
Dear Friends,
I was to create a site with quite some heavy mySQL database.
I wanted to know which is better longer rows in a table or two short rows
tables.
When compared in terms of speed etc.
Pl. help me , with this question and any other tip you
y, July 13, 2006 7:54 AM
Subject: which is better long rows in table or two short row tables
Dear Friends,
I was to create a site with quite some heavy mySQL database.
I wanted to know which is better longer rows in a table or two short rows
tables.
When compared in terms of speed etc.
Pl. hel
Dear Friends,
I was to create a site with quite some heavy mySQL database.
I wanted to know which is better longer rows in a table or two short rows
tables.
When compared in terms of speed etc.
Pl. help me , with this question and any other tip you may find can be
useful to me.
Thanks,
Abhishek
Dave Shariff Yadallee wrote:
I am trying to set up a chem structures table.
column 1 is the key, column 2 is the description, column 3 is the structure
which is a blob.
In PHP the first 2 columns comes out as text as expected, but the
3rd I am trying to tell PHP please ignore this initially since
t
I am trying to set up a chem structures table.
column 1 is the key, column 2 is the description, column 3 is the structure
which is a blob.
In PHP the first 2 columns comes out as text as expected, but the
3rd I am trying to tell PHP please ignore this initially since
this is a blob.
Should I be
"Scott Fletcher" <[EMAIL PROTECTED]> wrote:
> I wanna know is do I do the Analyze the table before the Optimize the
> table or should I do it the other way around???
If you need to defragment the table, you can just run OPTIMIZE TABLE.
--
For technical support
I wanna know is do I do the Analyze the table before the Optimize the
table or should I do it the other way around???
Thanks,
FletchSOD
Here are some tables:
Create Table FN (
FNunid varchar(32) not null,
...,
PRIMARY KEY (FNunid)
);
Create Table Dependent (
DEPunid varchar(32) not null,
FNunid varchar(32) not null,
...,
PRIMARY KEY (DEPunid),
CONSTRAINT `0_69` FOREIG
> I am new to mysql. I have installed, created a database and also some
created tables. Now any one who can login to the host are able to drop the
table or also the database. How do I protect it?
You should read this:
http://www.mysql.com/doc/en/User_Account_Management.html
or maybe inst
Hi,
I am new to mysql. I have installed, created a database and also some created tables.
Now any one who can login to the host are able to drop the table or also the database.
How do I protect it?
-mysql
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading
At 18:47 +1000 10/5/03, Wang Feng wrote:
Greetings,
I'm so curious about this:
If a new MySQL database account need to be created, do you insert the
account info to the *user* table of the *mysql* database OR do you grant the
new account by the GRANT query? What are the differences andn which one
Greetings,
I'm so curious about this:
If a new MySQL database account need to be created, do you insert the
account info to the *user* table of the *mysql* database OR do you grant the
new account by the GRANT query? What are the differences andn which one do
you prefer?
(I got some trouble whe
wow. yeah it works.
Thanks a lot.
-N.
> On Mon, 01 Sep 2003 17:13:20 +0900
> Nishant <[EMAIL PROTECTED]> wrote:
>
> > I dont know why my brain stopped working :)
> >
> > I have two tables T1 and T2, both of which have a column : Seria
On Mon, 01 Sep 2003 17:13:20 +0900
Nishant <[EMAIL PROTECTED]> wrote:
> I dont know why my brain stopped working :)
>
> I have two tables T1 and T2, both of which have a column : SerialNo
>
> Now I want to select those rows from T1 whose SerialNo is not present in
> T2.
>
> This dont work:
>
I dont know why my brain stopped working :)
I have two tables T1 and T2, both of which have a column : SerialNo
Now I want to select those rows from T1 whose SerialNo is not present in
T2.
This dont work:
select T1.*
from
table1 as T1
straight_join
table2 as T2
where
gregory lefebvre wrote:
Hye the list,
There is my problem.
I have to register about 400 large arrays (~1 lines each) in my
MySQL database and I don't know which of the following choices is better.
Either create a large tables as a stack, which contains all arrays
Either create as many tables
2003 10:07 AM
Subject: Large table or several tables ?
> Hye the list,
>
> There is my problem.
>
> I have to register about 400 large arrays (~1 lines each) in my
> MySQL database and I don't know which of the following choices is better.
> Either create a large table
s no where near
an issue, I run a app against mysql that has arrays around 250-300K at the
moment and its fine.
Jerry
- Original Message -
From: "gregory lefebvre" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 3:07 PM
Subject: Large table
Hye the list,
There is my problem.
I have to register about 400 large arrays (~1 lines each) in my
MySQL database and I don't know which of the following choices is better.
Either create a large tables as a stack, which contains all arrays
Either create as many tables as there are arrays and
I am just starting to use mysql and I need some help on probably some
simple items
I have created a database and now I want to just do a simple query and
display the results on the screen and that is where I am having the
trouble. How do I get it to print the variables on the webpage.
Thanks
Rya
BRACHET,STEPHAN (Non-HP-France,ex1) wrote:
> Hello,
>
> I need to do an update on a table :
>
> * Something like this : *
> UPDATE my_table mt
> SET mt.field1 = mt.field1 + 1
> WHERE mt.id = 100
> *
>
> And there can have concurrent updates on this record
Hello,
I need to do an update on a table :
* Something like this : *
UPDATE my_table mt
SET mt.field1 = mt.field1 + 1
WHERE mt.id = 100
*
And there can have concurrent updates on this record. is there a risk of 2
(or more) updates done at the same time an
Hello,
I need to do an update on a table :
UPDATE my_table mt
SET mt.field1 = mt.field1 + 1
WHERE mt.id = 100
And there can have concurrent updates on this record. is there a risk of 2
(or more) updates done at the same time and my field and the result of the
query to damage the field or does a
43 matches
Mail list logo
