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 of
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
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 and
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
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
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.
