Webserver appears sluggish, Noticed Sentora_core DB >300MB

[americanninja]

Hi fellow Sentora users. So I noticed when doing a backup of my server files and databases today that it took a while to dump the sentora_core database, which I thought was strange. So I went and had a look at the filesize of this database by running this command at the mysql prompt:

SELECT table_schema "database", sum(data_length + index_length)/1024/1024 "size in MB" FROM information_schema.TABLES GROUP BY table_schema;

The result showed that the sentora_core database is 310MB. Is this normal?!?!

I only run 5 Wordpress and Drupal websites on this server and have about 8 email addresses registered. I find it strange that my Drupal website with more than 4000 pieces of content and articles has only a 315MB database size.

So has something gone wrong? Also, I have noticed that my websites, which get very little traffic start stuttering when I try to open more than 2-3 website tabs of the same site, which seems strange. I'm running this server on Digitalocean droplet, with 1CPU, 1GHZ, 1GB memory. As I mentioned I have 5 sites in total, 4 wordpress 1 drupal and they get very little to no traffic. These sites were loading fast in the past, and it seems lately things have started to really slow down. Even after a reboot I see it. So perhaps something has gone run on the server?

Can someone suggest a few things I can check? I'm no linux server expert, but I know enough on how to get around and configure different things. Thanks!

---

Hi fellow Sentora users. So I noticed when doing a backup of my server files and databases today that it took a while to dump the sentora_core database, which I thought was strange. So I went and had a look at the filesize of this database by running this command at the mysql prompt:

SELECT table_schema "database", sum(data_length + index_length)/1024/1024 "size in MB" FROM information_schema.TABLES GROUP BY table_schema;

The result showed that the sentora_core database is 310MB. Is this normal?!?!

I only run 5 Wordpress and Drupal websites on this server and have about 8 email addresses registered. I find it strange that my Drupal website with more than 4000 pieces of content and articles has only a 315MB database size.

So has something gone wrong? Also, I have noticed that my websites, which get very little traffic start stuttering when I try to open more than 2-3 website tabs of the same site, which seems strange. I'm running this server on Digitalocean droplet, with 1CPU, 1GHZ, 1GB memory. As I mentioned I have 5 sites in total, 4 wordpress 1 drupal and they get very little to no traffic. These sites were loading fast in the past, and it seems lately things have started to really slow down. Even after a reboot I see it. So perhaps something has gone run on the server?

Can someone suggest a few things I can check? I'm no linux server expert, but I know enough on how to get around and configure different things. Thanks!

Okay, I did just check the database tables one by one, and the x_logs table has a whopping 2,729,296 records of data. Any idea why this would happen or why this doesn't get cleared through the system?

---

   

Here is a screenshot of the records in the table. It seems these are just happening over and over again.

Execute hook file (modules/apache_admin/hooks/OnDaemonRun.hook.php)
Execute hook file (modules/dns_manager/hooks/OnDaemonRun.hook.php)
Execute hook file (modules/mysql_databases/hooks/OnDaemonRun.hook.php)
Execute hook file (modules/zpx_core_module/hooks/OnDaemonRun.hook.php)
Execute hook file (modules/webalizer_stats/hooks/OnDaemonHour.hook.php)
Execute hook file (modules/backup_admin/hooks/OnDaemonDay.hook.php)
Execute hook file (modules/updates/hooks/OnDaemonDay.hook.php)