Forum LAMS for Tech-Heads - General Forum: Re: Re: Re: MySQL "dead" processes

By: Jun-Dir Liew

[ Reply | Forward ]

I just had a look at the event related code (I'm not familiar with it).

The query is run by the scheduler in order to resend unsuccessful events. Do you have a mail server configured in your lams configuration? If not, one possibility is that mail notifications build up in the events tables.

In any case, can you do a dump of your lams_events and lams_event_subscriptions tables and attach/send them? Using mysqldump:

mysqldump lams lams_events lams_event_subscriptions > C:\dump.sql -u root -p

where the first argument is the database name.

Posted by Jun-Dir Liew