Re: How to optimize fulltext selection?

[Michael Monashev]

Hello

Thank you so much. I Just increase the size of some buffers:



# The MySQL server
[mysqld]
default-character-set = cp1251
port            = 3306
socket          = /xxxxx/xxxxxx.sock
basedir = /xxxxx
datadir = /xxxxx/xxxxx
log-error = /xxxxx/error.log
log-slow-queries = /xxxxx/slow.log
pid-file = /xxxxx/pid.file
key_buffer = 512M #was 384
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 8M  # was 4
read_buffer_size = 8M  # was 4
read_rnd_buffer_size = 32M  # was 16
myisam_sort_buffer_size = 128M  # was 64
thread_cache = 8
query_cache_size= 16M
query_cache_type = 2
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections=300

skip-locking
skip-name-resolve
skip-innodb
skip-networking

server-id       = 1
  

Sincerely,
Michael,
 http://xoib.com/ http://3d2f.com/
 http://qaix.com/ http://ryxi.com/
 http://gyxe.com/ http://gyxu.com/
 http://xywe.com/ http://xyqe.com/