MySQL Slow Queries
Permalink
I noticed on some of our C5 sites, there are multiple error logs being generated every day in tmp > mysql_slow_queries. Our clients web hosting company said that these types of errors can really slow a website down.
Does anyone know anything about this, and how to avoid them?
Thanks in advance.
Does anyone know anything about this, and how to avoid them?
Thanks in advance.
What errors are you seeing?
I'm not sure exactly how to read these logs, I've taken a screen shot you can view at -http://i.imgur.com/3SwhDjA.jpg?1...
hi
actually these are not errors or something. "The slow query log consists of SQL statements that took more than long_query_time seconds to execute."
mysql logs these queries, let developers know which of your app queries cause slow-downs.
about slow queries of apps like c5 i think you can't do anything. just let the c5 core team developers know about these ones.
actually these are not errors or something. "The slow query log consists of SQL statements that took more than long_query_time seconds to execute."
mysql logs these queries, let developers know which of your app queries cause slow-downs.
about slow queries of apps like c5 i think you can't do anything. just let the c5 core team developers know about these ones.
Thanks for the reply. The hosting guys said these types of errors were greatly slowing the site down. He mentioned something about requests to the database taking way longer than it should. Does this make sense, or is this something I shouldn't worry about? I'm just curious because we've been using C5 for about 4 years now and the sites are generally much slower than sites on other platforms (such as WP).
the hosting guys are right, except these are not errors, just some non-optimized queries takes longer than usual.
Is there anything that I can do on my end to optimize the queries?
which version are you using? try upgrade yo newer version.
We're using the latest version, and always upgrade as soon as the new versions become available.
your site has been runing 4 years? how much page do you have? how big your db size?
The website in question (that these errors are for) is only about 4 months old, and has under 20 pages of static content. The DB is fairly small since there is not much content on the site.
I have many Concrete5 sites that are not showing slow queries. But, one site is REALLY slow. The TTFB is over 2 seconds long and I am not sure where to turn.
Here is my environment info (redacted any private info)
Here is my environment info (redacted any private info)
# concrete5 Version 5.6.0.2 # concrete5 Packages None # concrete5 Overrides css/popup.css, css/tabs.css, css/style.css, css/winxp.blue.css, css/simplified, css/issues.css, css/nds.css, css/custom, single_pages/page_not_found.php, themes/images, themes/materials, themes/bon # Server Software Apache # Server API cgi-fcgi # PHP Version 5.3.16 # PHP Extensions bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, filter, ftp, gd, gearman, hash, homeloader, iconv, imagick, imap, intl, ionCube Loader, json, libxml, mbstring, mcrypt, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, soap, sockets, SPL, SQLite, sqlite3, standard, tidy, timezonedb, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend Guard Loader, zip, zlib. # PHP Settings
Viewing 15 lines of 40 lines. View entire code block.
Just in case your problem is related to caching, you might want to read this post:http://www.concrete5.org/index.php?cID=385743&editmode=...
