9 Mar
2008
9 Mar
'08
8:55 a.m.
-----Original Message-----
From: Sebastian Mendel <lists(a)sebastianmendel.de>
To: phpmyadmin-devel(a)lists.sf.net
Date: Sun, 09 Mar 2008 09:45:15 +0100
Subject: Re: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Marc Delisle schrieb:
Here are guidelines for improved speed accessing
information_schema:
http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html
yes, for a long time ... ;-)
but none of the suggested improvements can be used when obtaining whole
database list ...
and we always specify as exact as possible what data we want from the I_S
--
Sebastian
Ok, but here is what MySQL has to say about version 6.0.4
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html
"INFORMATION_SCHEMA implementation changes were made that optimize certain types of
queries for INFORMATION_SCHEMA tables so that they execute more quickly."
10 Mar
10 Mar
3:12 a.m.
New subject: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Marc Delisle schrieb:
yes ... ok ... two month is a long time for me ... ;-)
and i just wanted to say, that we are already as specific as possible when
querieng I_S, and when obtaining the whole database list we can not be more
specific - we just want all databases ... :-/
or what did you want to say?
(please do not replay below '-- ' my email client cuts this off when
clicking on reply)
--
Sebastian
-----Original
Message-----
From: Sebastian Mendel <lists(a)sebastianmendel.de>
To: phpmyadmin-devel(a)lists.sf.net
Date: Sun, 09 Mar 2008 09:45:15 +0100
Subject: Re: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Marc Delisle schrieb:
Ok, but here is what MySQL has to say about version 6.0.4
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html
"INFORMATION_SCHEMA implementation changes were made that optimize certain types of
queries for INFORMATION_SCHEMA tables so that they execute more quickly." Here are guidelines for improved speed accessing
information_schema:
http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html
yes, for a long time ... ;-)
but none of the suggested improvements can be used when obtaining whole
database list ...
and we always specify as exact as possible what data we want from the I_S
9:24 a.m.
New subject: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Sebastian Mendel a écrit :
Marc Delisle schrieb:
yes ... ok ... two month is a long time for me ... ;-)
and i just wanted to say, that we are already as specific as possible when
querieng I_S, and when obtaining the whole database list we can not be more
specific - we just want all databases ... :-/
or what did you want to say?
I just wanted to be sure that we already are as specific as possible in
the queries, thanks.
-----Original Message-----
From: Sebastian Mendel <lists(a)sebastianmendel.de>
To: phpmyadmin-devel(a)lists.sf.net
Date: Sun, 09 Mar 2008 09:45:15 +0100
Subject: Re: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Marc Delisle schrieb:
Ok, but
here is what MySQL has to say about version 6.0.4
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html
"INFORMATION_SCHEMA implementation changes were made that optimize certain types of
queries for INFORMATION_SCHEMA tables so that they execute more quickly." Here are guidelines for improved speed accessing
information_schema:
http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html
yes,
for a long time ... ;-)
but none of the suggested improvements can be used when obtaining whole
database list ...
and we always specify as exact as possible what data we want from the I_S
9:51 a.m.
New subject: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Marc Delisle schrieb:
Sebastian Mendel a écrit :
ah, ;-)
yes, i think so, i try always, whether I_S or not, to be as specific as
possible with my queries.
--
Sebastian
Marc Delisle schrieb:
yes
... ok ... two month is a long time for me ... ;-)
and i just wanted to say, that we are already as specific as possible when
querieng I_S, and when obtaining the whole database list we can not be more
specific - we just want all databases ... :-/
or what did you want to say?
I just wanted to be sure that we already are as specific as possible in
the queries, thanks.
-----Original Message-----
From: Sebastian Mendel <lists(a)sebastianmendel.de>
To: phpmyadmin-devel(a)lists.sf.net
Date: Sun, 09 Mar 2008 09:45:15 +0100
Subject: Re: [Phpmyadmin-devel] MySQL 5.1.23 and information_schema
Marc Delisle schrieb:
> Here are guidelines for improved speed accessing information_schema:
>
> http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html
yes, for a long time ... ;-)
but none of the suggested improvements can be used when obtaining whole
database list ...
and we always specify as exact as possible what data we want from the I_S
Ok, but
here is what MySQL has to say about version 6.0.4
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html
"INFORMATION_SCHEMA implementation changes were made that optimize certain types of
queries for INFORMATION_SCHEMA tables so that they execute more quickly."
6025
days inactive
6026
days old
3 comments
2 participants
participants (2)
-
Marc Delisle -
Sebastian Mendel