forums › forums › Monyog › Using Monyog › Mysql Tuning
- This topic is empty.
-
AuthorPosts
-
-
October 2, 2010 at 8:41 pm #12122M NourMember
Dear all,
I have a dedicated server running our college forum and I want a help in Tuning it's MySQL
It has
– 2 × 2 GHz Intel Core 2 Duo
– 4 GB of ram
– 500 MB Hard disk
The server runs a vBulletin forum with 700 MB Database and some other small applications
The problem is that the forum has more than 15000 visits per day which really kills the server and makes the forum tooooo slaw !
I really want a help in tuning this server, how could MONyog help me in that ?
and what you recommend me for tuning ?
sorry for bothering you and thanks in advance
-
October 3, 2010 at 7:43 am #31392peterlaursenParticipant
1) If you have MONyog installed then start follow advisors in 'Monitors Advisors' page for various buffer settings – both for the server level and the storage engine(s) level (with a Forums software running I will assume that MyISAM is used). The default settings that the server ship with are much too small for a production server.
2) You should try use the MySQL 'query cache' if you don't already. With Forums it is very often a few very popular posts the draws a majority of the request. Also here MONyog will give you advisors on how to configure the settings. But here you may encounter the problem that the software does not consider that user may use 'query cache' and do not use the 'SQL_NO_CACHE' clause for queries that should not be cached. But give 'query cache' a try anyway.
3) Ensure that you MySQL server is not a debug build (they are slow) and if you do not need the general log – what you probably don't – then turn it off in order to reduce disk I/O (but it may be turned off already)
4) You may try to identify slow queries with the MONyog 'query analyzer' – just one more index to a table etc. may improve performance. But is is always problematic 'hacking' such standard applications, as it may very well cause trouble upgrading the software.
-
October 4, 2010 at 4:46 pm #31393M NourMember
Thanks Peter so much : )
-
-
AuthorPosts
- You must be logged in to reply to this topic.