News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Getting the Most Out of SMF

Started by 3guk, May 21, 2008, 09:43:09 AM

Previous topic - Next topic

3guk

Just doing some routine house cleaning on my new dedicated server, and wondered if you guys had any recommendations about optimal mysql Values.

Current my.conf
[mysqld]
set-variable = max_connections=500
safe-show-database
set-variable = table_cache=512
set-variable = query_cache_size=16M
set-variable = thread_cache_size=30M


Current Status.php Reading
Operating System:  Linux 2.6.18-53.el5xen
Processor: Intel® Xeon® CPU X3210 @ 2.13GHz (2133.418MHz)
Load averages: 0.00, 0.00, 0.00
Current processes: 132 (128 sleeping, 3 running, 1 zombie)
Processes by CPU: httpd (13) 1.9%, (other) (62) 0.2%
Memory usage: 96.806% (2030176k / 2097152k)
Swap: 0.001% (60k / 4194296k)
MySQL processes
Total processes: 8 (7 sleeping, 1 running, 0 locked)
MySQL Statistics
MySQL 5.0.x
Connections per second: 0.2614
Kilobytes received per second: 1.7877
Kilobytes sent per second: 63.8322
Queries per second: 9.2939
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 2.2587 (should be <= 80)
Table cache usage:
(table_cache) 0.5586 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size) 0.0012 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 0.6106 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 608.45 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0.0007 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 0.4332 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer) 0 (should be <= 0.001)
Query cache enabled:
(query_cache_type) 1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit) 0.5609 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 0.1318 (should be <= 0.05)


Got 2GB of Ram in this machine, wondering if I could change the mysql conf to be any more optimal ??

Cheers

Ben_S

Optimization is an ongoing process, & reading that is almost impossible given you haven't linked to the actual file (status.php) what you have posted is all but meaningless.

Oh and set-variable = is depreciated and not needed in my.cnf. If thats your entire my.cnf file, you have a long way to go with optimizing it.
Liverpool FC Forum with 14 million+ posts.

3guk

#2
This is the link >

Sarge


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

3guk

I ran the mysql tuner script and did the things it asked of me, now since I'm not an expert I'm wondering where to go next to provide my users with the most optimal forum.

Ben_S

What is the current contents of your my.cnf file?

Are you running an accelerator such as APC, with your current level of activity, an accelerator will probably have far more impact than tweaks to MySQL.
Liverpool FC Forum with 14 million+ posts.

3guk

Currently running APC and did see a massive change once running it, I'm a bit of a speed freak, and even if it took me hours to shave off a couple of 0.0001s then I'd do it !! :D

Code (my.conf) Select
[mysqld]
max_connections=300
safe-show-database
table_cache=750
query_cache_size=16M
thread_cache_size=30M
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
tmp_table_size=128M



Advertisement: