My Opencart website was loading like a rocket till yesterday.
Yesterday MySQL was upgraded by cPanel officially across all servers and since then, my site is almost dead.
Pages and refresh or click takes forever to load.
Whats wrong ?
Isn't it compatible with latest MySQL ?
MysqlI Support enabled
Client API library version 5.7.18
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.7.18
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
Yesterday MySQL was upgraded by cPanel officially across all servers and since then, my site is almost dead.
Pages and refresh or click takes forever to load.
Whats wrong ?
Isn't it compatible with latest MySQL ?
MysqlI Support enabled
Client API library version 5.7.18
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.7.18
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
No OC version posted.
Vague information to troubleshoot this problem.since then, my site is almost dead.
Opencart uses MySQLi library since a few years now as it has never encountered a systematic issue other than the reserved field names that were used to insert / replace values on the database. More information would be needed in order to track down the problem you are reporting about - including URL / screenshot.Isn't it compatible with latest MySQL ?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Still with still missing information.Still spiking up MySQL crazy and sites are dead.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
OpenCart
Version 3.0.2.0
PHP INFO is here https://goo.gl/hMNig2
This issue has started exactly after MySQL upgrade to 5.7.x
You can see here http://prntscr.com/igrsfi, how its killing the CPU each second, even if hardly 1-2 hits in a second.
Contact your host to see how the resources could be re-handled due to this upgrade.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
straightlight wrote: ↑Tue Feb 20, 2018 1:21 amContact your host to see how the resources could be re-handled due to this upgrade.
Im the host itself, its my dedicated server.
I have contacted cPanel and CLOUDLINUX both and they said, its something to do with opencart with latest mySQL, because all other sites and CMS run fine in my server after the upgrade, but just this opencart websites doesnt work.
Contradiction. Other servers you own works with the latest version of mySQL but only one server does not provide the same results with the latest version of mySQL while using Opencart. How does that indicate it's an Opencart issue exactly if you are indicating that only one server is having an issue among other servers with the latest version of mySQL already?its something to do with opencart with latest mySQL, because all other sites and CMS run fine in my server after the upgrade, but just this opencart websites doesnt work.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
It would be good start to inform was it blank white, infinite loading, any error log you can share etc.sites are dead
I'm not sure what is your previous MySQL version, but your issue might be related to sql mode change only_full_group_by that enabled by default since MySQL 5.7.5. There is lot of solution out there to disabled only-full-group-by sql mode.
Of course the best solution would be editing mysql driver configuration considering you use dedicated server. In shared hosting, I would override the sql-mode session through query.
Code: Select all
"SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"
And it's only 1 of 2 of OpenCart get this issue is possibly because your other opencart site have a modification that change sql-mode silently.
and of course the best solution seeing as you have root access would be to migrate over to MariaDB ;-)
It just takes a lot of time to load and when I monitor server, I can see MySQL usage is super high due to this 2 accounts.
This server has 30 websites, and only 2 opencart 3.x and only those 2 are affected.
This server has 30 websites, and only 2 opencart 3.x and only those 2 are affected.
qahar wrote: ↑Wed Feb 21, 2018 2:11 amIt would be good start to inform was it blank white, infinite loading, any error log you can share etc.sites are dead
I'm not sure what is your previous MySQL version, but your issue might be related to sql mode change only_full_group_by that enabled by default since MySQL 5.7.5. There is lot of solution out there to disabled only-full-group-by sql mode.
Of course the best solution would be editing mysql driver configuration considering you use dedicated server. In shared hosting, I would override the sql-mode session through query.
Code: Select all
"SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"
And it's only 1 of 2 of OpenCart get this issue is possibly because your other opencart site have a modification that change sql-mode silently.
If this issue occurs only from two domains among other domains on the same server since the upgrade to mySQL v5.7+ , please follow these steps and provide the query logs that the issues may indeed originate from Opencart: https://stackoverflow.com/questions/368 ... ries-error
In addition, you can also implement this step as followed: https://stackoverflow.com/questions/377 ... 7/37743777
In addition, you can also implement this step as followed: https://stackoverflow.com/questions/377 ... 7/37743777
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Ok questions :uksitebuilder wrote: ↑Wed Feb 21, 2018 4:54 amand of course the best solution seeing as you have root access would be to migrate over to MariaDB ;-)
1. Can we have MariaDB installed alongside mySQL in the same server ?
2. Do you think MariaDB will perform better than this MySQL 5.7 ?
3. Is there any automated method to convert the MySQL database dump directly to MariaDB import file ?
Please note, I am no server Guru, so depending on your server set-up I would advise exploring the Maria DB knowledgebase
Maria DB is a drop in replacement for MySQL, but it can run on the same server:
https://mariadb.com/kb/en/library/insta ... ide-mysql/
Maria DB does perform better than mySQL in my opinion.
SQL Queries, dumps etc work in the same way as mySQL dumps and queries.
The only difference is if you convert the antiquated myISAM storage engine to Aria, you will obviously not be able to import Aria storage engine tables in your mySQL Databases.
You can of course use myISAM storage engine tables in Maria DB, but it is advisable to either switch to Aria storage engine or innoDB
Maria DB is a drop in replacement for MySQL, but it can run on the same server:
https://mariadb.com/kb/en/library/insta ... ide-mysql/
Maria DB does perform better than mySQL in my opinion.
SQL Queries, dumps etc work in the same way as mySQL dumps and queries.
The only difference is if you convert the antiquated myISAM storage engine to Aria, you will obviously not be able to import Aria storage engine tables in your mySQL Databases.
You can of course use myISAM storage engine tables in Maria DB, but it is advisable to either switch to Aria storage engine or innoDB
I copied the site to my another server which is running same MySQL 5.7 and it works perfect there.
But not in my main server.
Is there a way to track down what exactly is lagging the performance ?
It used to load like rocket few days back and been like this sluggish now, so for sure, something is dragging down.
But not in my main server.
Is there a way to track down what exactly is lagging the performance ?
It used to load like rocket few days back and been like this sluggish now, so for sure, something is dragging down.
Who is online
Users browsing this forum: No registered users and 20 guests