Zen Cart 1.5.4
Server OS: Linux 2.6.32-696.16.1.el6.x86_64 (We use dedicated Server)
Database: MySQL 5.6.38
PHP Version: 5.5.37 (Zend: 2.5.0)
We are having major problems with our zen cart website which happened suddenly without changed any settings or touched code etc (this has happened about 1 month ago and we are still stuck).
Server Load is super high, website is slow, we could not use following function of admin because it times out or super slow.
* Making a Feed File for Search Engine (we use doofinder)
* Inserting special price from Price Manager (we could edit existing price etc, but not installing new special price).
>> We had to increase set_time_limit() from 60 to 300. This did not work at first (did not increase time limit). We contacted server and there was some error on litespeed (boost) software. This is fixed but this is not solving the problem... Still slow.
* Take ages to search order number sometimes 1-2 mins.
We have contacted Server however, according to them, they have never changed any setting / upgrading and server is working fine so must be our problem.
We don't think so cause when it started this problem following error occurred at admin log in section....
Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/********/public_html/********/login.php on line 13
>> We have fixed this but Server must done something!!??.... <<
Any how, according to our server:
Regarding the server load, mysql seems to be the highest in terms of CPU usage. The best way of reducing load would be to optimize your databases and queries. It looks like the CPU usage is hovering around 200% at the moment, but not too many processes are running:”
>>We have run repair on MySQL but this does not seem to solve the problems.
Further info from our server company
mysql> show processlist;
+---------+------------------+-----------+----------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+------------------+-----------+----------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
| 1152668 | *********_*****2| localhost | *********_******* | Query | 36 | Sending data | SELECT distinct o.* FROM zen_orders o left join zen_orders_products op on (op.orders_id = o.orders_ |
| 1152685 | *********_*****2| localhost | *********_******* | Sleep | 0 | | NULL |
| 1152713 | *********_*****2| localhost | *********_******* | Sleep | 0 | | NULL |
| 1152714 | *********_*****2| localhost | *********_******* | Query | 0 | Writing to net | SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'index'
AND
associated_d |
| 1152716 | *********_*****2| localhost | *********_******* | Query | 0 | Writing to net | SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'index'
AND
associated_d |
| 1152717 | *********_*****2| localhost | *********_******* | Query | 0 | Writing to net | SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'index'
AND
associated_d |
| 1152720 | *********_*****2| localhost | *********_******* | Sleep | 0 | | NULL |
| 1152721 | *********_*****2| localhost | *********_******* | Query | 0 | statistics | SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'index'
AND
associated_d |
| 1152722 | *********_*****2| localhost | *********_******* | Sleep | 0 | | NULL |
| 1152725 | *********_*****2| localhost | *********_******* | Sleep | 2 | | NULL |
| 1152726 | *********_*****2| localhost | *********_******* | Query | 0 | Creating sort index | select c.categories_id, cd.categories_name, c.parent_id
from zen_categories c, zen_categor |
| 1152727 | root | localhost | NULL | Query | 0 | init | show processlist |
| 1152728 | *********_*****2| localhost | *********_******* | Query | 0 | Sending data | select b.banners_id, b.expires_date, b.expires_impressions,
sum(bh.bann |
| 1152729 | *********_*****2| localhost | *********_******* | Sleep | 0 | | NULL |
+---------+------------------+-----------+----------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
14 rows in set (0.00 sec)
We have seen following log errors in short period of time (over 100 errors in short time. This happens now and then randomly and not too sure what is causing this...)
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
[19-Feb-2019 11:53:29 Asia/Tokyo] PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in ***/public_html/includes/classes/db/mysql/query_factory.php on line 62
We will be much appreciate it if someone can enlighten us and what is most likely causing this error....
We are newbie here so if you need any further information etc., please feel free to contact us.
and thank you very much for your time in advance.
Bookmarks