Author Topic: Server CPU for VM 3 ~ 9000 products ~ Could not connect to MySQL.  (Read 2296 times)

2dmaster

  • Jr. Member
  • **
  • Posts: 92
I think it's all the other left module for vm overload caused !!!!! how to chop ???

Virtuemart and multiple custom field plg&mod toomuch lag`s or my server very slow ???
how muck to boost joomla ??


I`m using virtuemart 3.0.12 with installed ajax-filter for products as Virtuemart 3 Multiple Customfields Filter plg and module.

I have 9000 SKU products with two custom_fields as width (2/3/4/5/6/) and height (180,200,250,300,350,400,450,500,550,600,800,850,900,1000,1050,1100,1200,1400,1600,2000)

Joomla cant open`s - Application Instantiation Error: Could not connect to MySQL.

mysql  5.5.31 mysql.connect_timeout   60
mysqlnd mysqli 5.0.11-dev
PHP     5.5.30
Server & PHP interface   apache2handler
Joomla!   Joomla! 3.4.8 Stable
Max Requests   Per Child: 10000 - Keep Alive: on - Max Per Connection: 100
Timeouts   Connection: 60 - Keep-Alive: 2
cURL Information   7.19.7
libxml Version   2.9.2
GD Version   bundled (2.1.0 compatible) FreeType Version   2.6.0
iconv implementation   glibc
iconv library version   1.14
json version   1.2.1
libXML Compiled Version   2.9.2
mbstring libmbfl version   1.3.2
libxml2 Version   2.9.2

PHP Loaded Modules   core mod_authn_file mod_authn_dbm mod_authn_anon mod_authn_dbd mod_authn_socache mod_authn_core mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_dbm mod_authz_owner mod_authz_dbd mod_authz_core mod_access_compat mod_auth_basic mod_auth_form mod_auth_digest mod_allowmethods mod_file_cache mod_cache mod_cache_disk mod_cache_socache mod_socache_shmcb mod_socache_dbm mod_socache_memcache mod_so mod_macro mod_dbd mod_dumpio mod_buffer mod_ratelimit mod_reqtimeout mod_ext_filter mod_request mod_include mod_filter mod_substitute mod_sed mod_deflate http_core mod_mime mod_log_config mod_log_debug mod_logio mod_env mod_expires mod_headers mod_unique_id mod_setenvif mod_version mod_remoteip mod_proxy mod_proxy_connect mod_proxy_ftp mod_proxy_http mod_proxy_fcgi mod_proxy_scgi mod_proxy_wstunnel mod_proxy_ajp mod_proxy_balancer mod_proxy_express mod_session mod_session_cookie mod_session_dbd mod_slotmem_shm mod_ssl mod_lbmethod_byrequests mod_lbmethod_bytraffic mod_lbmethod_bybusyness mod_lbmethod_heartbeat mod_unixd mod_dav mod_status mod_autoindex mod_info mod_suexec mod_cgi mod_dav_fs mod_dav_lock mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_ruid2 prefork mod_php5

Server Hardware
Производителя   GenuineIntel  ~ Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz   
memory   524288 kB
free memory 13640 kB
Apache 2.4.16   
Exim 4.80.1   
Named 9.8.2rc1
sshd   
dovecot 2.2.19
pure-ftpd 1.0.42   


and what you think about JSON cms-shops ??? how to setup web-server for super fast online store with WM ???
Do they have a boost and performance plugins??
How to setup super fast server for Virtuemart 3 SHOP ??
thanks
Fatal error: Allowed memory size of 272629760 bytes exhausted (tried to allocate 5493656 bytes) in /home/domains/.ru/public_html/plugins/system/advancedmodules/helper.php on line 118

CSVI pro BUGS    when update Available fields
1 !!!!!    ####_virtuemart_product_custom_plg_param_ref   not clean when clean DB
2 <!> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=INSERT INTO `####_csvi_availablefields`

3 set joomla custom tpl and custom vm template
i set in virtuemart 3 cfg custom tpl in ganhtry tpl html /com_virtuemart
when i change site templates setting broken
Code: [Select]
Notice: Undefined property: stdClass::$id in /home/domains/.ru/public_html/libraries/gantry/core/gantrytemplate.class.php on line 420
Notice: Undefined property: stdClass::$id in /home/domains/.ru/public_html/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php on line 66
Fatal error: Uncaught exception 'RuntimeException' with message 'Less Parse Error: expected color value: failed at `#gradient > .vertical(lighten(@menuMobileGradient,5%), darken(@menuMobileGradient,10%));` /home/domains/.ru/public_html/templates/gantry/less/menu.less on line 295' in /home/domains/.ru/public_html/libraries/gantry/core/gantry.class.php:1141 Stack trace: #0 /home/domains/.ru/public_html/templates/rt_paradigm/html/mod_roknavmenu/themes/gantry-dropdown/layout.php(53): Gantry->addLess('menu.less') #1 /home/domains/.ru/public_html/modules/mod_roknavmenu/lib/librokmenu/AbstractRokMenuLayout.php(34): GantryDropdownLayout->stageHeader() #2 /home/domains/.ru/public_html/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php(89): AbstractRokMenuLayout->doStageHeader() #3 /home/domains/.ru/public_html/modules/mod_roknavmenu/lib/renderers/RokNavMenu2XRenderer.php(11): RokMenuDefa in /home/domains/.ru/public_html/libraries/gantry/core/gantry.class.php on line 1141

4 on site
Notice: Undefine property: stdClass::$id in /home/domains/.ru/public_html/plugins/system/gantry/gantry.php on line 234
Notice: Undefined property: stdClass::$id in /home/domains/.ru/public_html/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php on line 66



jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3430
  • using Matomo instead of Google Analytics
Re: Server CPU for VM 3 ~ 9000 products ~ Could not connect to MySQL.
« Reply #1 on: February 06, 2016, 18:16:16 pm »
Reads like you have several problems and I'm not sure if this is helpful:
1. See here: http://www.inmotionhosting.com/support/edu/joomla-3/database-errors
2. I would suggest to switch your site to the beez template temporarily to see if Gantry causes some errors.
3. Can you see the VM memory usage if you turn on VM-Debug in the VM configuration?
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9804
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Server CPU for VM 3 ~ 9000 products ~ Could not connect to MySQL.
« Reply #2 on: February 08, 2016, 00:36:19 am »
Fatal error: Uncaught exception 'RuntimeException' with message 'Less Parse Error: expected color value: failed at `#gradient > .vertical(lighten(@menuMobileGradient,5%), darken(@menuMobileGradient,10%));` /home/domains/.ru/public_html/templates/gantry/less/menu.less on line 295' in /home/domains/.ru/public_html/libraries/gantry/core/gantry.class.php:1141 Stack trace: #0 /home/domains/.ru/public_html/templates/rt_paradigm/html/mod_roknavmenu/themes/gantry-dropdown/layout.php(53): Gantry->addLess('menu.less') #1 /home/domains/.ru/public_html/modules/mod_roknavmenu/lib/librokmenu/AbstractRokMenuLayout.php(34): GantryDropdownLayout->stageHeader() #2 /home/domains/.ru/public_html/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php(89): AbstractRokMenuLayout->doStageHeader() #3 /home/domains/.ru/public_html/modules/mod_roknavmenu/lib/renderers/RokNavMenu2XRenderer.php(11): RokMenuDefa in /home/domains/.ru/public_html/libraries/gantry/core/gantry.class.php on line 1141


There is the problem, I would say
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/