Jump to content


Photo

Customising Alert Emails


  • Please log in to reply
4 replies to this topic

#1 Steve Bond

Steve Bond

    Member

  • Members
  • PipPip
  • 14 posts
  • Gender:Male
  • Location:Basingstoke, UK

Posted 10 January 2012 - 11:37 AM

Hi Guys,

Does anyone know if it's possible to edit the content of the email alerts? And how this would be done?

One example would be to display the Last Error value in the mail alert for a replication failure.

Thanks,

Steve

#2 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 10 January 2012 - 01:02 PM

You can't edit content of email Alert.
We do have plan to implement different email subject templates for Mobile users and other users.
For people who access their mails on Mobile device for them currently it is difficult to make out what is wrong(Which particular counter has reached threshold value etc..) until opens an email to read in detail about subject and content.

#3 danit

danit

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 21 January 2012 - 01:28 PM

i'm with steve on this. i think the ability to modify email alerts would be a big plus.

i receive slow query alerts when it is hard for me to investigate (for example in middle of the night or when i'm on the road). i would like to add a show process list to the email alert. surprisingly, i'm finding it to be impossible!

#4 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 25 January 2012 - 04:35 AM

You can try WayBack machine feature it displays information about these variables:
1) Threads connected
2) # of slow queries.
The graph displays aggregating values on years/months/days/hours/ minutes depending on the data. If sniffer was running during this interval, aggregated sniffer information will be displayed for the time interval. Also you can see first and last value of (optionally) all or changed variables aggregated values.

#5 Steve Bond

Steve Bond

    Member

  • Members
  • PipPip
  • 14 posts
  • Gender:Male
  • Location:Basingstoke, UK

Posted 10 May 2012 - 09:06 AM

i'm with steve on this. i think the ability to modify email alerts would be a big plus.

i receive slow query alerts when it is hard for me to investigate (for example in middle of the night or when i'm on the road). i would like to add a show process list to the email alert. surprisingly, i'm finding it to be impossible!


@danit,

I had the exact same idea a while back (great minds!), wanted to get a process list dump when the threshold was met. Unfortunately didn't get very far. See :http://www.webyog.co...?showtopic=4971
Outside monyog I created a script that checked the number of running threads and then did a show process list if it hit the threshold. I think our spikes were too short lived though as the number of queries listed was almost always way below the threshold. This might be suitable for your slow query requirement though.I

Would be very interested if you come up with another way to do it!

Steve




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users