MySQL

First, the operating system configuration optimization:1. On the network side, modify the/etc/sysctl.conf file, increase the number of TCP supported queues, reduce the resource recovery when disconnected.2. Limit the number of open files. Modify the/

One, max () optimizationMysql> explain select Max (payment_date) from payment;+----+-------------+---------+------+---------------+------+---------+------+-------+-------+| ID | Select_type | Table | Type | Possible_keys | Key | Key_len | Ref | Rows

MySQL uses a table query and grouping to remove duplicate data// Delete duplicate IDs in table, retain maximum ID Select from user; +----+------+| ID | Name |+----+------+| 1 | A | | 2 | b | | 3 | C | | 4 | D | | 5 | A | | 6 |

Creating a BAT fileYou need to put 7z.dll and 7z.exe in the bat's sibling directory and Mysqldump.exe these 3 filesEcho offCLSCD/D%~dp0REM===========configure (start) ==============Sethost=127.0.0.1SetUser=AdminSetpass=Configure your MySQL

General table data Less words are used graphical interface, looking more convenient.If there is more data in the table, it is very easy to get stuck with a graphical interface, and this is where the command line will be used.Exporting large amounts

And the QQ said there are many Martian and emoji expression pictures, these data, if directly insert to MySQL database, general will error, set to UTF8 are not good, must be changed to UTF8MB4 code, the difference between the two see: MySQL utf8mb4

MySQL User table root Delete solution by mistake1, first to root user login system;2, close the MySQL service:/etc/init.d/mysql stop;3. Privilege start Mysql:/usr/local/mysql/bin/mysqld_safe--user=mysql--skip-grant-tables--skip-networking & (Note:

#!/bin/bash#auto backup MySQL Shell#by Csy 2015-11-11#自动备份数据库, and add a task plan script#定义变量 ===============Bak_cmd=/usr/bin/mysqldumpBak_host=localhostBak_db=csyBak_user=rootBak_pass= "123456"bak_dir=/tmp/mysqlbackup/Bak_date= ' DATE +%f '#环境测试 ..

Disclaimer: The following is the author's original, reproduced please indicate the source (business promotion needs to contact the author authorization). Through the Baidu Encyclopedia we knowApache (full name Apache HTTP server): Is the world's

StatementThe Stars last nightBlog:http://yestreenstars.blog.51cto.com/This article by oneself creation, if need reprint, please indicate source, thank cooperation!ObjectiveFull hot backup of MySQL with InnobackupexEnvironmentOs:centos 6.6

This is a test case that was written a long time ago, to check the number of data inserted into the MySQL database, and to see how the database is performing? Whether the server will be fully written soon.Pre-preparatory work: Mysql database setup,

Design Paradigm (NF = Normal Format)Paradigm: the canonical format.Paradigms are rules that must be adhered to in designing relational databases.If we meet the requirements of the design paradigm, the database will be concise and structurally

1. Pre-preparation1.1 Environment Description:Operating system: CentOS release 6.4 (Final) [view command Cat/etc/redhat-release]mysql:mysql-5.6.261.2 Completely delete the system comes with MySQLYum remove MySQL mysql-server mysql-libs

C:\users\zsh>mysql-h 127.0.0.1-u Root-pEnter Password: * * *Welcome to the MySQL Monitor. Commands End With; or \g.Your MySQL Connection ID is one to server version:5.0.27-community-ntType ' help ', ' or ' \h ' for help. Type ' \c ' to clear the

MySQL database design, which, for Data performance optimization, field type considerations are important, collected some information, organized to share, this is about the MySQL integer bigint, int, mediumint, smallint and tinyint syntax

1, install Nginx:Install package DirectoryMkdir-p/data/tgzCd/data/tgzInstall compilation dependenciesYum Install Wgetyum install Pcreyum install OpenSSL*-y install gcc gcc-c++ autoconf libjpeg libjpeg-deve L libpng libpng-devel freetype

The following actions are performed under root1. Installing NginxA) download Nginx, Pcre, OpenSSL, zlib library, directly extracted to the/usr/local directory.b) After entering the zlib directory, execute chmod +x./configurec) Enter the Nginx

MySQL Maximum connection data said the default is 100, it seems that the number of connections over this value, other connections can not be reached and prompt Error:too many connectionsErrno.: 1040.Here's how to modify the maximum number of MySQL

1,search.aspx (Show page) Input Box Information tips (database) 2.1,server.aspx (Data supply page, this page removes other extra code, leaving only the top row.) If you change your name here, remember to change the page's call to-_-.C #"

1. Assume that there are already mysql-5.5.10.tar.gz and cmake-2.8.4.tar.gz two source files(1) Install CMake First (mysql5.5 is compiled by CMake later)[[email protected] rhel5 Local] #tar-zxv-f cmake-2.8.4.tar.gz[Email protected] rhel5 Local] #cd