Need expert opinion on MySQL queries and server conf

[otelo]

Hi
We've made a site for an online newspaper. We used CGBlog but are calling the articles through user define tags. This site is a bit complex and the homepage calls different articles from differente categories.
We've seen some slow queries in the slow queries log as well as warnings in the apache error log.
We need to make sure this go away and that no issues arises in the future.
We are looking for expert help to review the queries we have made and check why the error log is throwing a bunch of warnings.

[otelo]

I'm getting a lot of these in the apache error log

Code: Select all

[Fri May 10 19:55:08 2013] [warn] [client 66.249.74.165] mod_fcgid: stderr: PHP Notice:  Undefined index: cgblog_data in /var/www/vhosts/7dias.com.do/7diascomdo/html/tmp/templates_c/4c23743d5e102922bf515aed78a4545554bc6631.globalcontent.snippet_noticias_list_v3.php on line 221

And the site lost its CSS and a bunch of other stuff for a little while. I cleared the CMS cache and went back to normal. Are these things related?

[Jos]

globalcontentblock.snippet_noticias_list_v3

Doesn't this ring a bell to you?
then do a ctrl-F on cgblog_data there