GIGAZINE, transfer to the new server completed

That is why we finally moved to the new server. This should reduce the load ... .... In order to cope with the expected load, the number of counts has been limited to the necessary minimum. In addition to that, we redesigned the database structure. Along with this, trackbacks etc are all reset, sorry ....

If there is something wrong, etc. for temporary useThis mail formPlease contact us if you can help.

So, for the settings of old server and new server etc. The second article for those who are interested in customizing the server. This time is the setting of MySQL which made it the most difficult.
◆ MySQL
The more memory you use, the faster the response will be returned, but if MySQL contains only the body of the article like GIGAZINE, that is because you used a lot of memory in a very compact case The reaction rate does not rise dramatically. Rather, if the memory is limited to the extent that swap does not occur, the whole becomes smaller and the load is reduced, and as a result, the response comes back at high speed.

Since this concept itself has not changed fundamentally since the time of MySQL 3, first of all, keep the basics on the following page.

MySQL Reference Manual for version 3.23.16-alpha. - 12 To get maximum performance of MySQL

The configuration file to base is "my-small.cnf" which is included in MySQL. Although it is facing the setting for a small server of 64 Mbytes or less in size, the actual situation is set to lower the load by handling a large number of connections.

Especially as a result of referring to the MySQL page below, it resulted in a very dramatic effect. It is easy to increase the number little by little based on the case of "When there is a large amount of memory with little memory connection" to determine the amount of swap not to occur.

MySQL AB :: MySQL 4.1 Reference Manual :: 5.5.2 Tuning Server Parameters

For adjustment of the value, refer to the following. The point of adjustment is written at the bottom. You can adjust it quite easily if you do this.

MySQL AB :: MySQL 4.1 Reference Manual :: 4.6.8.3 SHOW STATUS

Then finally make further adjustments with reference to the following.

MySQL AB :: MySQL 4.1 Reference Manual :: 5.2.13 Other optimization tips

After adjusting the value, it is safe to check it with "mymemcheck" available at the following site.

DSAS Developer's Room: Can be done in 5 minutes, MySQL memory related tuning!

Let's repeat the fine adjustment according to each manual up to the above while watching the state of "mtop" or "mytop" which should also be called "top" command for MySQL.

Mtop - MySQL Monitoring Tool

Mytop - a top clone for MySQL

Below, a list of articles such as past server load etc.