[Phpmyadmin-devel] [Phpmyadmin-cvs] DisableIS in

[Sebastian Mendel]

Rekrutacja schrieb:
> Marc Delisle wrote:
>> Sebastian Mendel a écrit :
>>> Hi,
>>>
>>> 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
>>>
>>> Marc?
>>>
>>> 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)
>>
>> http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_2_11/phpMyAdmin/libraries/database_interface.lib.php?r1=11196&r2=11215 
>>
>> 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?


-- 
Sebastian Mendel