SLow webserver in edit mode with datadisplay

Permalink Browser Info Environment
When in Edit mode on concrete Version 5.6.3.1 using data display we notce some times the pages load very very slowly. I do a show full processlist; I get below queries which are always from some sixeightformsxxx table.(see below) And top command on server shows mysql is uing most of cpu.
sixeightformsAnswers
sixeightformsOptions

Is there anything I can do? Seems the sixeight tables are the culprits and we use the data display add-on on a lot of our pages. All other tables in our database are InnoDB but the sixeight table are MyISAM? Does this matter?
thanks,

Type: Discussion
Status: New
ciresbarb
View Replies:

concrete5 Environment Information

# concrete5 Version
5.6.3.1

# concrete5 Packages
Advanced Forms (1.13.1), Auto-Nav Pro (1.5.5), Code Blocks (1.2.1), Data Display (2.7.1.4), Easy Slider (1.5.1), Flickr Photos (1.2.1), Formigo Social Life (1.0.4), List files from set (1.0.4), Power Slider Lite (1.1.1), Power Slider Pro (1.2.1), Pro Events (11.1.0), Pro Forms (7.5.6), Pro News (5.1.0), Pro Tabs (1.1.1), Search Block Templates (1.0), SQL Buddy (1.0), View Directory (1.3).

# concrete5 Overrides
blocks/power_slider_pro, blocks/power_slider_lite, blocks/easyslider_slideshow, blocks/home_sidebar, blocks/page_list, blocks/content, blocks/home_box, blocks/proforms_list, blocks/proforms_display, blocks/autonav, blocks/home_box_block, blocks/pro_event_list, blocks/list_files_from_set, blocks/search, blocks/pronews_list, controllers/test_form.php, elements/header_required.php, js/html5shiv.js, js/theme_scripts.js, js/layout.engine.js, js/html5shiv-printshiv.min.js, js/layout.engine.min.js, js/jquery.transpose.min.js, js/html5shiv-printshiv.js, js/theme_scripts.min.js, js/html5shiv.min.js, css/style_override.min.css, css/style-ie.min.css, css/images, css/mobile.min.css, css/tree.css, css/style-ie.css, css/general.css, css/style.css, css/general.min.css, css/bg.css, css/style_override.css, css/iconize.css, css/style.min.css, css/iconize.min.css, css/mobile.css, single_pages/peoplesearch, single_pages/publications, themes/default_homepage.php, themes/Education and Outreach, themes/ESOC, themes/CIRES, themes/Limnology, themes/theme_stylesheet_template.css

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 10080 minutes.

# Server Software
Apache/2.2.15 (Red Hat)

# Server API
apache2handler

# PHP Version
5.3.3

# PHP Extensions
apache2handler, apc, bcmath, bz2, calendar, Core, ctype, curl, date, dba, dom, enchant, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, gv, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, memcache, mysql, mysqli, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, phpcups, posix, pspell, recode, Reflection, rrdtool, session, shmop, SimpleXML, snmp, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, uuid, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 30
apc.max_file_size - 1M
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 100M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 100M
ldap.max_links - Unlimited
memcache.max_failover_attempts - 20
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.