Re: Optimizing the MySQL server performance

[bob ly]

I commented out this line
server-id = 1

But still I didn't see any real improvement. I tweaked some variables in my.cnf and restarted mysql. And here are my variables in my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /space/var/lib/mysql
skip-locking
key_buffer = 756M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 16
query_cache_size= 32M
skip-innodb
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4

There is lot if insertion which happens every halfhour. Prorbably around 30K rows get inserted into 3-4 tables. Also every half hour around 30k rows get deleted and again insert the summed up new data. I guess probably I could use a replace instead of delete & insert.
Also after I made the changes to my.cnf I was surprised to see this results
Qcache_lowmem_prunes= 594, do I need to tweak anything so that the read/web access has more pripority then the writes.
Thanks


Open_files | 367 |
| Open_streams | 0 |
| Open_tables | 191 |
| Opened_tables | 1741 |
| Qcache_free_blocks | 254 |
| Qcache_free_memory | 1222048 |
| Qcache_hits | 6804992 |
| Qcache_inserts | 65621 |
| Qcache_lowmem_prunes | 5948 |
| Qcache_not_cached | 266 |
| Qcache_queries_in_cache | 28462 |
| Qcache_total_blocks | 57211 |
| Questions | 22540225 |