Welcome! Log In Create A New Profile

Advanced

Re: High Load mysql server

Кирюшкин Владимир
October 28, 2011 01:36PM
Hello,

> So, what i`ve must to do again.?

you should do this:

> General recommendations:
>     Add skip-bdb to MySQL configuration to disable BDB
>     Run OPTIMIZE TABLE to defragment tables for better performance
>     Reduce your overall MySQL memory footprint for system stability
>     Enable the slow query log to troubleshoot bad queries

also you should lower key_buffer_size to e.g. 64M (recommendation = "Reduce your overall MySQL memory footprint for system stability")


Cheers,

Vladimir

_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx
Subject Author Posted

High Load mysql server

MyName October 28, 2011 09:13AM

Re: High Load mysql server

Кирюшкин Владимир October 28, 2011 09:22AM

Re: High Load mysql server

MyName October 28, 2011 01:11PM

Re: High Load mysql server

Кирюшкин Владимир October 28, 2011 01:36PM

Re: High Load mysql server

Nginx User October 28, 2011 03:18PM

Re: High Load mysql server

Thinke365 October 29, 2011 02:00PM

Re: High Load mysql server

MyName October 29, 2011 02:03PM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 184
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready