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?
-----Original Message----- From: Rekrutacja rekrutacja119@gmail.com To: phpmyadmin-cvs@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)
http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_2_11/php...
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 = 'phpbb_poll_options' |
i suppose it's turned on, the only place i see this options is libraries/config.default.php
# 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. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ Phpmyadmin-cvs mailing list Phpmyadmin-cvs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-cvs