HI,
We are running our forum in a VPS server,
with 1.5 GB RAM,
1.96GHZ processor
recently for the past few days, sql server process taking high load on server,
so our vps is getting down often,
our hosting provider replied the following,
We are running only one vbulletin based forum on this VPS.
our database size is around 1.5 GB,
_________________________________________________________________________________
Hosting Wrote,
The MySQL server is associated with some unoptimized database queries and this seems to be causing the memory-shortage issue. The DB under concern is "ladyswin_gscom". Please refer the link given below to see a few sample queries:
---
http://support-tools.com/?b283e126a017ccf2#yLkVrztVYTvVJSItwc8rZfS73w6YCkblpXNB+v3h4QA=
---
Please note that all such queries are very resource intensive and can slow down your operations to a great extent. I would suggest you to check the database table structures and these "select queries" to make sure that the indexes you have in your DB tables correspond to the select operations which you're trying to run. When select/order_by/group_by/join operations are performed on tables with incorrect indexes, MySQL will be forced to create a new temporary table, copy data into it and perform these sorting operations on a temporary table. Such operations might take significant amount of CPU and Disk I/O bandwidth, which in turn, increase the server load and reduce performance of your sites!
the next reply,
Nevertheless, I've faced slowness issue while loading the site. On further checking, it's seen that the server-load has gone to a higher extend and this seems to be causing the issue. See the snippet given below:
---
root@vps [~]# uptime
09:37:58 up 9 days, 18:54, 1 user, load average: 19.46, 20.53, 18.17
---
As updated before, the MySQL service in the server is associated with a lot of unoptimized long queries and this seems to be causing the issue. All these queries are related to the database "ladyswin_gscom". Please refer the link given below for some sample queries:
---
http://support-tools.com/?09314ede46c8bb34#5/iDeNAAfbmK4ikEn8pICjOT6xrwfwt8idqbbhdk+gk=
---
The only way to resolve this issue is to get in touch with your database developer to check this further and optimize the DB queries associated with the aforementioned database. Please be informed that we won't be able to provide you assistance in optimizing your databases. This will have to be done from your end.
Hope this helps. Let us know if you need any further concerns.
__________________________________________________________________________________________ ____
it seems like, All these started , after the 4.2.2 Patch 4 upgrade,
we need to solve this asap.
our site is getting down often,
please help with us.
We are running our forum in a VPS server,
with 1.5 GB RAM,
1.96GHZ processor
recently for the past few days, sql server process taking high load on server,
so our vps is getting down often,
our hosting provider replied the following,
We are running only one vbulletin based forum on this VPS.
our database size is around 1.5 GB,
_________________________________________________________________________________
Hosting Wrote,
The MySQL server is associated with some unoptimized database queries and this seems to be causing the memory-shortage issue. The DB under concern is "ladyswin_gscom". Please refer the link given below to see a few sample queries:
---
http://support-tools.com/?b283e126a017ccf2#yLkVrztVYTvVJSItwc8rZfS73w6YCkblpXNB+v3h4QA=
---
Please note that all such queries are very resource intensive and can slow down your operations to a great extent. I would suggest you to check the database table structures and these "select queries" to make sure that the indexes you have in your DB tables correspond to the select operations which you're trying to run. When select/order_by/group_by/join operations are performed on tables with incorrect indexes, MySQL will be forced to create a new temporary table, copy data into it and perform these sorting operations on a temporary table. Such operations might take significant amount of CPU and Disk I/O bandwidth, which in turn, increase the server load and reduce performance of your sites!
the next reply,
Nevertheless, I've faced slowness issue while loading the site. On further checking, it's seen that the server-load has gone to a higher extend and this seems to be causing the issue. See the snippet given below:
---
root@vps [~]# uptime
09:37:58 up 9 days, 18:54, 1 user, load average: 19.46, 20.53, 18.17
---
As updated before, the MySQL service in the server is associated with a lot of unoptimized long queries and this seems to be causing the issue. All these queries are related to the database "ladyswin_gscom". Please refer the link given below for some sample queries:
---
http://support-tools.com/?09314ede46c8bb34#5/iDeNAAfbmK4ikEn8pICjOT6xrwfwt8idqbbhdk+gk=
---
The only way to resolve this issue is to get in touch with your database developer to check this further and optimize the DB queries associated with the aforementioned database. Please be informed that we won't be able to provide you assistance in optimizing your databases. This will have to be done from your end.
Hope this helps. Let us know if you need any further concerns.
__________________________________________________________________________________________ ____
it seems like, All these started , after the 4.2.2 Patch 4 upgrade,
we need to solve this asap.
our site is getting down often,
please help with us.
Comment