How to write a shell script to notify when certain texts appear in a file?

I have a server and occasionally the file mysqld.log would show something like

[ERROR] /usr/libexec/mysqld: Disk is full writing './example_com_-_wordpress/wp_statpress.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs

How do I write a simple shell script to check mysqld.log every 15 mins and email me once it detects "Waiting for someone to free space"

Hello!

Per forum rules, and the benefit of all users, please search the network and the forums before posting a question.

You can easily search the forums using our internal Google search engine or our advanced internal search engine. You can also search our huge UNIX and Linux database by user generated tags or search the database for unanswered questions and provide an answer.

Search for: disk space email

Thank you.

The UNIX and Linux Forums