440hz
php.ru
Создание временных таблиц на диске
правильно ли я понимаю, что при наличии полей типа TEXT мне этого не избежать?
| Created_tmp_disk_tables | 19265 |
| Created_tmp_tables | 27651 |
# The MySQL server
[mysqld]
skip-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 32M
read_buffer_size = 32M
net_buffer_length = 8K
myisam_sort_buffer_size = 32M
max_connections = 150
join_buffer_size = 32M
query_cache_size = 32M
tmp_table_size = 32M
max_heap_table_size = 64M
last pid: 2947; load averages: 3.35, 2.83, 2.37 up 4+19:44:27 11:08:56
88 processes: 10 running, 78 sleeping
CPU states: 89.5% user, 0.0% nice, 9.7% system, 0.8% interrupt, 0.0% idle
Mem: 460M Active, 177M Inact, 124M Wired, 22M Cache, 112M Buf, 220M Free
Swap: 1024M Total, 65M Used, 959M Free, 6% Inuse
50194 mysql 34 0 326M 59580K RUN 116:37 6.10% 6.10% mysqld
Uptime: 239742 Threads: 17 Questions: 25926600 Slow queries: 11 Opens: 1313 Flush tables: 1 Open tables: 256 Queries per second avg: 108.144
правильно ли я понимаю, что при наличии полей типа TEXT мне этого не избежать?
| Created_tmp_disk_tables | 19265 |
| Created_tmp_tables | 27651 |
# The MySQL server
[mysqld]
skip-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 32M
read_buffer_size = 32M
net_buffer_length = 8K
myisam_sort_buffer_size = 32M
max_connections = 150
join_buffer_size = 32M
query_cache_size = 32M
tmp_table_size = 32M
max_heap_table_size = 64M
last pid: 2947; load averages: 3.35, 2.83, 2.37 up 4+19:44:27 11:08:56
88 processes: 10 running, 78 sleeping
CPU states: 89.5% user, 0.0% nice, 9.7% system, 0.8% interrupt, 0.0% idle
Mem: 460M Active, 177M Inact, 124M Wired, 22M Cache, 112M Buf, 220M Free
Swap: 1024M Total, 65M Used, 959M Free, 6% Inuse
50194 mysql 34 0 326M 59580K RUN 116:37 6.10% 6.10% mysqld
Uptime: 239742 Threads: 17 Questions: 25926600 Slow queries: 11 Opens: 1313 Flush tables: 1 Open tables: 256 Queries per second avg: 108.144