- Desde
- 24 Ago 2006
- Mensajes
- 44
recientemente tuve problemas con el vps a ver si me pueden ayudar a optimizarlo para un mejor desempeño aqui les dejo lo que saque del my.cnf y las caracteristicas del vps si falta algo haganmelo saber
vps , con cpanel y virtuazzo
my.cnf
[mysqld]
skip-bdb
max_connections = 400
max_user_connections = 100
thread_concurrency = 2
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
record_buffer = 1M
max_allowed_packet = 16M
table_cache = 500
thread_cache_size = 128
wait_timeout = 15
connect_timeout = 15
interactive_timeout = 15
max_connect_errors = 10
query_cache_type = 1
Processor Information
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU 5140 @ 2.33GHz
Processor #1 speed: 2333.357 MHz
Processor #1 cache size: 4096 KB
Current Memory Usage
total used free shared buffers cached
Mem: 1048576 309612 738964 0 0 0
-/+ buffers/cache: 309612 738964
Swap: 0 0 0
Total: 1048576 309612 738964
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/vzfs 30G 7.3G 23G 25% /
segun esto
Guaranteed Memory (RAM) 512 MB
Burst Memory (RAM) 1024 MB
vps , con cpanel y virtuazzo
my.cnf
[mysqld]
skip-bdb
max_connections = 400
max_user_connections = 100
thread_concurrency = 2
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
record_buffer = 1M
max_allowed_packet = 16M
table_cache = 500
thread_cache_size = 128
wait_timeout = 15
connect_timeout = 15
interactive_timeout = 15
max_connect_errors = 10
query_cache_type = 1
Processor Information
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU 5140 @ 2.33GHz
Processor #1 speed: 2333.357 MHz
Processor #1 cache size: 4096 KB
Current Memory Usage
total used free shared buffers cached
Mem: 1048576 309612 738964 0 0 0
-/+ buffers/cache: 309612 738964
Swap: 0 0 0
Total: 1048576 309612 738964
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/vzfs 30G 7.3G 23G 25% /
segun esto
Guaranteed Memory (RAM) 512 MB
Burst Memory (RAM) 1024 MB