[Phpmyadmin-devel] [Phpmyadmin-cvs] DisableIS in
lists at sebastianmendel.de
Tue Apr 29 15:34:12 CEST 2008
> Marc Delisle wrote:
>> Sebastian Mendel a écrit :
>>> Rekrutacja schrieb:
>>>> i've tested latest pma (phpMyAdmin-trunk-20080424-022001), and it seems
>>>> it has DisableIS set to true as default, but when i log in and click any
>>>> of the tables from database, i can see this on the server:
>>>> SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING,
>>>> ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM
>>>> information_schema.TRIGGERS WHERE EVENT_OBJECT_SCHEMA= 'test99_db' and
>>>> EVENT_OBJECT_TABLE = 'phpbb2_bookmarks'
>>>> and is taking very long time, same as without DisableIS.
>>>> does DisableIS is not yet fully implemented or is it a bug?
>>> 1. not fully implemented
>>> 2. IMHO sooner, later or already SHOW will mapped to I_S
>>> 3. the above statement should include TRIGGER_SCHEMA in WHERE
>>> was there any reason not including TRIGGER_SCHEMA in WHERE?
>> The EVENT_OBJECT_SCHEMA seems to always have the same content as
>> TRIGGER_SCHEMA, but I just noticed that in the MySQL manual they suggest
>> using TRIGGER_SCHEMA in the WHERE clause as you suggested, so I merged
>> the change and the doc reference (for version 2.11.7)
>> Rekrutacja, is it faster this way on your server?
> i've tried latest 3.0-dev version, from svn (did checkout just few
> minutes ago), and it is still slow.
> Query | 30 | checking permissions | SELECT TRIGGER_SCHEMA,
> TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT,
> EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS
> WHERE TRIGGER_SCHEMA= 'test99' and EVENT_OBJECT_TABLE = 'phpbb2_confirm'
whats your MySQL server version?
More information about the Developers