Good day guys (and girls if any)
I am constantly in a position where variables on a
production mysql database needs to be changed.
The database runs a 24/7 system and thus to reboot is not
preffered and should be the absolute last resort.
I just would like to know which version of MySQL support the creation of
database triggers with the same action and event for one table.
I'm not sure there is any plan to implement support for multiple triggers
with
the same action and timing.
I certainly hope so... If not, it seems yet anot
Hi,
After analysing slow query log i found that some queries are not using index
and so i used the force index command in query and test it and now it starts
using index properly.Accordingly i implemented the same query with force index
in my application code and regeneratet the slow query log.
On Wed, 9 Dec 2009 16:39:33 Jeetendra Ranjan wrote:
> Hi,
>
> I just would like to know which version of MySQL support the creation of
> database triggers with the same action and event for one table.
I'm not sure there is any plan to implement support for multiple triggers with
the same action a
Hi,
I just would like to know which version of MySQL support the creation of
database triggers with the same action and event for one table.
Because if i create the the triggers as below i am getting error.
First trigger (Succesfull)
++
CREATE TRIGGER CONSUMER_PROFILE_before_delete BEFO
Eric,
>> There are ways to resync data that don't involve all
>> this as well: Maatkit has some tools
>
> I've looked with great interest at Maatkit, but their tools are replete
> with warnings about dangers, bugs, and crashes. They certainly do not
> inspire confidence.
I'm the primary author o
