MySQL

Technical preparationHosted under the Ubuntu14.04.2 platform, based on the MYSQL5.5.46 version.Log files record the various types of MySQL database activities, as a daily location problem of the most common analysis means, MySQL database commonly

Probably do not pay much attention to the development of this aspect, but to the operation of the maintenance. That's a concern. As we all know, Root has too much authority. It's not easy to use. We usually better use some of the less privileged

Originally in the 5.1 version, in order to solve the Chinese garbled problem set the default character set is UTF8, in the My.ini in the [MySQL] and [mysqld] entries are written:INI Code Default-character-set=utf8 In the 5.5 version, [MySQL]

MySQL Database installation Complete the default administrator's login password is empty, so you can not enter the password to log in directly to the database, which is not secure, the following article briefly describes how to set the Administrator

MySQL Dual Master replication configuration test processServer environment:+-------------------+---------------------------------------------------| | server Node 1 | server Node 2 |+-------------------+------------------------+----------------------

ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)As noted above, the Mysql.sock file is missing.Workaround:Ln-s/tmp/mysql.sock/var/lib/mysql/mysql.sockKThere may be some homecoming error in the/

Altas Introduction:Atlas is a MySQL protocol-based data mid-tier project developed and maintained by Qihoo, a web platform infrastructure team. It is based on MySQL's official launch of the Mysql-proxy 0.8.2 version, modified a large number of bugs,

Because of the need for work, need to learn PHP, originally wanted to install lamp but considering today Nginxserver has good performance and wide application. Here I decided to build webserver under Linux (centos7+nginx+mysql+php).

Requirements: Due to business needs, Tmp_employees's Emp_no primary key field type int has not satisfied the business requirements, you need to change the table primary key field type from int to bigintUse tool:

One: The method of killing MySQL connection:Kill thread_id: Kills the current process, disconnectsKill query thread_id: Only Kill a connection to the current SQL, and keep the connection open.Several ways to kill MySQL connections in bulk:1>

Change to: http://lizhenliang.blog.51cto.com/7876557/16574651. database table Design to avoid slow query, inefficient query statements, not properly indexed, database congestion (deadlock), etc.2. Database deploymentProject initial visits are not

Packagecom.simope.test;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importcom.mysql.jdbc.Connection;Importcom.mysql.jdbc.Statement; Public classConntomysql { Public Static FinalString url =

Scenario: MySQL cannot perform a select command query, and for existing databases, there are other databases such as Nova, Keystone, cinder, and so on, in addition to MySQL and INFORMATION_SCHEMA databases.The following error is reported in the

The explain command is the first recommended command to address database performance, and most performance issues can be easily resolved with this command, explain can be used to see how SQL statements are executed, to help select better indexes

Our production platform used Zabbix,zabbix database is MySQL, and the data volume is relatively large, each month produced data files more than 10G, after the "MySQL master and slave data plus keepalive" drill, with the production system to apply

Lao Xu, sharing the test project can actually solve the problem of dry!Share today:How to import MySQL script file data via mysql command line?－－－－－Solve the actual problem:In the process of working , you often need to import MySQL script filesMany

Then on a "configuration MySQL database master-Slave synchronization Experiment", this paper mainly from the perspective of application, in two MySQL server deployed keepalived service, can do in any one MySQL server failure situation, does not

1. Export the imported Excel file2 export Word files3. IO Stream upload Download file4. Mass mailing, can be sent in HTML, plain text format, can be sent to any mailbox (to achieve the bulk delivery of advertising mail)5. Mass or send SMS separately,

SQLite, sqlite3What is SQLiteSQLite? It is a lightweight embedded database, which occupies very low resources. In embedded devices, it may only require several hundred KB of memory, which is faster than Mysql and PostgreSQL. What is Database) A

Use SQL statements to back up, restore, and SQL statements to back up databases Only one method is used here. Back up the database file to the disk and restore it. /* 2: Use an SQL statement TO back up DATABASE 3: */4: BACKUP DATABASE mydb 5: TO