MySQL

1. Configure the Master LibraryYou must turn on the second-level log and assign a unique server ID• If you do not set Server-id or set it to the 0,master node, the slave connection will be rejected• It is recommended to set

2015-10-25DirectoryResources[1] Tang Hanming. mysql database development, optimization and Management Maintenance (2nd edition) [M]. Beijing: People's post and Telecommunications press, 2014[2] Schwartz. High-Performance MySQL (3rd edition) [M].

Recently learning slick, found in MySQL created under the table, can not specify the database engine, the source of research, found that after modification can achieve the desired purpose.The code is as follows and is then used directly in the

Precautions1.mysql Master-slave configuration generates a large number of logs (seen on the web). Some people mainly from the operation of the six-year log accounted for more than 40 g of disk, because the MySQL default configuration

SQL Statement implementation:SELECT COUNT (*) from INFORMATION_SCHEMA. ' TABLES ' WHERE table_name= ' youtablename ';In the WHERE clause, the table name is a string type, and the single quotation mark is added.In the MySQL stored procedureFunction

1, transaction processingInnoDB supports transactional features, MyISAM not supported. Myisam executes faster and performs better.  2,select, UPDATE, INSERT, delete operation MyISAM: If performing a large number of select,myisam is a better choice

========== Solution ============In the source package, edit the file cmd-line-utils/libedit/terminal.cPut the char in the Terminal_set method buf[tc_bufsize]; This line of comments, and then the area = buf, instead of area = NULL;After the changes

View MySQL database server and database character set.mysql> show variables like  '%char% '; +--------------------------+----------------------- --------------+------| variable_name             | Value                                |......+------ --

Transferred from: http://linux.it.net.cn/CentOS/course/2014/0724/3319.htmlVersion Glassfish-4.0.zip1, unzip, copy to the specified installation path Unzip Glassfish-4.0.zip CP CP glassfish4/usr/local/-RF 2. Setting

four ways to start MySQL:1, mysqld start MySQL server:./mysqld--defaults-file=/etc/my.cnf--user=root Client connection: MySQL--defaults-file=/etc/My.cnformysql-s/tmp/Mysql.sock2, mysqld_safe start MySQL

1. List the number of employees and department numbers in each department with wages higher than the department's average salary, sorted by department numberSelect A.deptid, COUNT (*) from employee921 as a INNER JOIN(Select DeptID, AVG (Salary) as

Recently, the colleague executes a MySQL query statement on the line, the data in 9,000 or so, but the use of the left connection when the query speed is about 15 seconds ~ This speed is really unacceptable ~The execution speed is less than 1

Yum-style installation of MySQL 1. Yum remove MySQL mysql-server mysql-libs compat-mysql51 2, Rm-rf/var/lib/mysql 3, Rm/etc/my.cnf See if you have MySQL software:rpm-qa|grep MySQL If it exists, continue with the deletion. RPM-style

SolrDocumentObjectiveBecause SOLRwas used in the project, it took more than a week to study SOLR, and I did not say any of the questions, especially in the two days when I was studying timing incremental indexing, I didn't know how many XXX in the

In the operation of MySQL, often need to convert characters into numbers, this step is simple, but not commonly used words are easy to forget, now will be found on the Internet The method is recorded as follows:1. Convert the number of characters to

MySQL will not find any source, directly with the Debian version of the good.Software that needs to be prepared:Navicat MySQLStart wheezyConnect to DebianInputMysql–versionYou can see that MySQL is not installedInputApt-get Install

MySQL can implement timed triggering functions, such as what to do with a MySQL database at a certain time, or how often to do what work.The second case is widely used, for example, I would like to check my data information every day, more than one

See the official website configuration instructions are a bit different from the actual (CENTOS7), after some groping, the configuration process to record down1. Download Mariadb-galera-server xinetd, the official website of the document is

Not much to say, directly on the code. Baidu above is also a large pile, we ask Baidu on the line.In the process of accessing the database using JDBC, there are mainly three kinds of resources: Connection Object Connection,sql statement object

MySQL Database optimization Summary-----duDescription: The environment for this article is CentOS 5.5 bit/mysql 5.1.50Introduction: The use of MySQL for some time, during the period did a lot of MySQL optimization, design, maintenance work, the two