In small memory VPS, kids shoes (including me) generally love to do the so-called "optimization". Among them, MySQL optimization has three parameters:
Skip-innodb/skip-bdb/skip-locking
In particular, the first parameter is said to save memory
Differences between mysql status and variables First, you can use the following two commands to view the corresponding mysql system parameters.Show status like '% abc % ';Show variables like '% abc % '; However, many people do not understand the
Introduction to MYSQLSHOWVARIABLES bitsCN.com
The mysqld server maintains two variables. Global variables affect global operations on the server. Session variables affect operations related to client connection.
When the server is started, all
In the previous development, there are many errors or poor performance, and then checked the data have been corrected, here can share:1. mysql Database issues(1) MySQL database if you have previously installed, the installation may occur after the
Original address: http://www.2cto.com/database/201108/100546.htmlThe MYSQLD server maintains two variables. Global variables affect the global operation of the server. Session variables affect specific client connection-related operations.When the
MySQL configuration parametersVery full MySQL configuration parameter description1. Back_logSpecifies the number of possible connections for MySQL. When the MySQL main thread gets very many connection requests in a short period of time, the
OpenLDAP compilation and installation and configuration, openldap compilation Configuration
Original article published in cu:
Reference:I. Environment
Server: CentOS-7-x86_64-1511 based
Server IP: 172.18.12.2032. The software obtains
# Windows mysql Backup recovery, you do not need to modify my. ini to restore the view (verified) mysqldump-uroot-p123 -- default-character-setgbk -- opt -- ex
# Mysql backup and restoration in Windows. You do not need to modify my. ini to restore
Http://blog.csdn.net/hzcyclone/archive/2010/08/18/5821370.aspxThe MySQL configuration file is/etc/my.cnf, which is configured by modifying it to configure MySQL./etc/my.cnf from the following files:If your memory is ≤64m, copy/usr/share/doc/mysql/my-
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.