.:.:.:.:
RTTP
.
Mobile
:.:.:.:.
[
<--back
] [
Home
][
Pics
][
News
][
Ads
][
Events
][
Forum
][
Band
][
Search
]
full forum
|
bottom
Reply
[
login
]
SPAM Filter:
re-type this
(values are 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E, or F)
you are quoting a heck of a lot there.
[QUOTE]blah blah blah[/QUOTE] to reply to the_reverend.
Please remove excess text as not to re-post tons
message
[QUOTE="the_reverend:358241"]no.. there is something up with the sql server lately. I need to optimize it... but I'm not sure how. I've tried all the tweaks for my.cnf I could find, but it still runs so much slower than 3.28 my.cnf --------------------------- [rttp@returntothepit ~]$ more my.cnf [mysqld] basedir = /usr datadir = /var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb max_connections = 650 key_buffer = 64M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 2M sort_buffer_size = 2M table_cache = 1500 thread_cache_size = 128 wait_timeout = 900 connect_timeout = 10 tmp_table_size = 128M max_allowed_packet = 16M max_connect_errors = 99999 read_rnd_buffer_size = 524288 bulk_insert_buffer_size = 8M query_cache_limit = 2M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 16384 query_alloc_block_size = 16384 [mysqld_safe] open_files_limit = 8192 err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M -------------------------------------------------- if you can think of anything else to add... for some reason I can't get slow query logging to work on it either[/QUOTE]
top
[
Vers. 0.12
][ 0.003 secs/8 queries][
refresh
][