[Phpmyadmin-devel] [Phpmyadmin-cvs] DisableIS in
Marc.Delisle at cegepsherbrooke.qc.ca
Mon May 5 23:36:37 CEST 2008
I think Sebastian answered previously that the DisableIS setting is not fully implemented. Also, please provide more information: do you have a large number of databases/tables?
From: Rekrutacja <rekrutacja119 at gmail.com>
To: phpmyadmin-cvs at lists.sourceforge.net
Date: Mon, 05 May 2008 16:29:48 +0200
Subject: Re: [Phpmyadmin-cvs] [Phpmyadmin-devel] DisableIS in
>>>> 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?
> 5.0.51a-3 , from debian package
so, any news? my server is still affected, i've tried latest 3.0
version, snapshot from 5th may, and it is still happening.
got this for example:
Query | 37 | 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 =
i suppose it's turned on, the only place i see this options is
# grep DisableIS libraries/config.default.php
$cfg['Servers'][$i]['DisableIS'] = true;
so i suppose it's enough.
why it's not working?
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
Phpmyadmin-cvs mailing list
Phpmyadmin-cvs at lists.sourceforge.net
More information about the Developers