Page 1 of 1

Need expert opinion on MySQL queries and server conf

Posted: Fri May 10, 2013 10:55 pm
by 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.

Re: Need expert opinion on MySQL queries and server conf

Posted: Sat May 11, 2013 12:40 am
by 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?

Re: Need expert opinion on MySQL queries and server conf

Posted: Sat May 11, 2013 2:19 pm
by Jos
globalcontentblock.snippet_noticias_list_v3
Doesn't this ring a bell to you?
then do a ctrl-F on cgblog_data there