Hace un par de dias saque un Hosting Dedicado en SoftLayer, el problema que tengo es que me tarda mucho en responder y yo lo noto muy lento de a ratos.. quisiera saber si hay algun experto en el tema que me diga si es normal este comportamiento.
En la imagen 1, tengo una consulta un archivo que pesa 1kb!! y tardó mas de 20 segundos!! en responder..
En la imagen 2 hice una simple consulta a la base de datos MySql , un simple select con LIMIT 1, y tardo
mas de 8 segundos..
El server es un:
Intel Xeon CuadCore speed: 2.40 MHz
2Gb Ram
total used free shared buffers cached
Mem: 2074412 1991996 82416 0 267212 1334720
-/+ buffers/cache: 390064 1684348
Swap: 2096440 104 2096336
Total: 4170852 1992100 2178752
Hable con el Hosting y me dijeron esto...
SoftLayer escribió:
We could not find any slow queries on checking mysql status.
==============
root [~]# mysqladmin proc status
+--------+-----------------+-----------+----------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-----------------+-----------+----------------+---------+------+-------+------------------+
| 406464 | beatsg_phoxer | localhost | beatsg_games | Sleep | 77 | | |
| 406687 | beatsg_phoxer | localhost | beatsg_games | Sleep | 0 | | |
| 406688 | beatsg_phoxer | localhost | beatsg_games | Sleep | 0 | | |
| 406689 | root | localhost | | Query | 0 | | show processlist |
+--------+-----------------+-----------+----------------+---------+------+-------+------------------+
Uptime: 126536 Threads: 4 Questions: 1180356 Slow queries: 0 Opens: 39 Flush tables: 1
Open tables: 29 Queries per second avg: 9.328
root [~]# w
01:29:17 up 1 day, 11:10, 1 user, load average: 0.07, 0.09, 0.09
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0 10.0.80.131 01:28 0.00s 0.01s 0.00s w
root [~]# free -m
total used free shared buffers cached
Mem: 2025 1686 338 0 277 1030
-/+ buffers/cache: 379 1646
Swap: 2047 0 2047
===============
==============
root [~]# mysqladmin proc status
+--------+-----------------+-----------+----------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-----------------+-----------+----------------+---------+------+-------+------------------+
| 406464 | beatsg_phoxer | localhost | beatsg_games | Sleep | 77 | | |
| 406687 | beatsg_phoxer | localhost | beatsg_games | Sleep | 0 | | |
| 406688 | beatsg_phoxer | localhost | beatsg_games | Sleep | 0 | | |
| 406689 | root | localhost | | Query | 0 | | show processlist |
+--------+-----------------+-----------+----------------+---------+------+-------+------------------+
Uptime: 126536 Threads: 4 Questions: 1180356 Slow queries: 0 Opens: 39 Flush tables: 1
Open tables: 29 Queries per second avg: 9.328
root [~]# w
01:29:17 up 1 day, 11:10, 1 user, load average: 0.07, 0.09, 0.09
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0 10.0.80.131 01:28 0.00s 0.01s 0.00s w
root [~]# free -m
total used free shared buffers cached
Mem: 2025 1686 338 0 277 1030
-/+ buffers/cache: 379 1646
Swap: 2047 0 2047
===============
Saludos.
