MySQL 4.1.14 Released

[Hvu]

Will be performing updates soon, I done it on a test server and it works fine.

[elix]

Did cPanel also release this?

[PvUtrix]

cPanel will take ages... they still haven't got 4.1.13 to RELEASE!

[ozgreg]

cPanel will take ages... they still haven't got 4.1.13 to RELEASE!

Actually that is incorrect, Cpanel is running 4.1.13 on 10.6

[PvUtrix]

Actually that is incorrect, Cpanel is running 4.1.13 on 10.6
yep, I stand corrected... have they had it for 6 days?

[capnqwest]

If Cpanel is running 4.1.13 on Release why does it only update to 4.0.25? Do I have to upgrade manually?

[Zaf]

If Cpanel is running 4.1.13 on Release why does it only update to 4.0.25? Do I have to upgrade manually?capnqwest, you are talking of two different generations (not sure if i'm using the right word for it) of mysql, and you can switch to that version from Tweak Settings in WHM. Make sure you have a full backup before you proceed, i'd recommend opening a support ticket if you are unsure.

[elix]

BTW when you switch to 4.1.x (not recommended if you don't need a particular feature included with it) you may need to use "old-passwords" or recompile PHP with the proper libraries in order for user authentication to work properly with some older scripts.

--elix

[capnqwest]

Thanks Elix and Shahzada, I've been thinking about upgrading to the 4.1.x branch of MySQL because alot of the tuning tutorials are written for it rather than 4.0.x. My server load is so outta control due to MySQL.

Advice heeded and I'll stick with trying to optimize 4.0.25

[elix]

Thanks Elix and Shahzada, I've been thinking about upgrading to the 4.1.x branch of MySQL because alot of the tuning tutorials are written for it rather than 4.0.x. My server load is so outta control due to MySQL.

Advice heeded and I'll stick with trying to optimize 4.0.25
Post your current my.cnf file here if you like and also tell us how much RAM your VPS has.

[capnqwest]

Post your current my.cnf file here if you like and also tell us how much RAM your VPS has.

I have a Cpanel 3 with 768 MB RAM and the entire contents of my /etc/my.cnf file are:

[mysqld]
set-variable = max_connections=500
safe-show-database


According to Cacti (which runs on it's own dedicated box), my load averages around 3.5 and WHM/Cpanel are usually unreachable during the daytime due to load. I host two relatively popular MoveableType (3.2) based sites (about 3000 uniques per day for both) and two small Wordpress (1.5.2) sites.

[Hvu]

Try adding index and key caches


[mysqld]
skip-locking
max_connections=500
connect_timeout=15
key_buffer=64M
join_buffer=24M
record_buffer=24M
sort_buffer=24M
table_cache=500
thread_cache_size=286
max_allowed_packet=5M
wait_timeout=15
query_cache_limit=32M
query_cache_size=1M
query_cache_type=1
thread_concurrency=2




Used MySQL memory = key_buffer + max_connections * (join_buffer + record_buffer + sort_buffer + thread_stack + tmp_table_size)

Notice the max_connection and the multiplier.
connection increase = memory usage increase too.

Notice key_buffer
for a given memory :
more you add mem to key buffer, less connections. less is key buffer, more connections

If you change one of these settings for a high value, you system may swap.
If you system swap, try lot decrease these values

Also, about table_cache :
Increasing the size of the table cache may really help you.
But you must be careful not to make the value too large. All operating systems have a limit on the number "open file pointer" (sorry in french it is called pointer, maybe descriptors is the good translation) a single process may have.
If MySQL tries to open a lot of files, the OS may refuse it and MySQL will generate error message in the error log.

[capnqwest]

Thanks HVU, I applied that .cnf about an hour ago and my load dropped from about 4 to just above 1. I'll watch it closely over the next day and see how it helps.