MySQL

Found in the notepad++ written script, paste to the Linux client, the execution always reported that my script has a problem.I looked and looked, found that the table script itself is no problem, the problem is on the "tab" key and the top of the

When MySQL inserts Chinese into the table, it appears:incorrect string value error, because the character set does not support Chinese. The workaround is to change the character set to GBK, or UTF-8.  First, modify the default character set of the

ObjectiveAs in C + +, how many bytes are required to define an int type, and how many bytes are required to define the double type, MySQL has strict control over the data in each column of the table, which is key to the success of the data-driven

MySQL Default one connection idle 8 hours will automatically disconnect, and then the program thought the connection can also be used, and then in use will appear communications link failure exception.You need to set up two steps at this point,

Com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:Too many connections at Com.mysql.jdbc.SQLError . Createsqlexception (Sqlerror.java:921) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:2822) at

MySQL runs down recently in the build environment, some SQL execution is slow, first check if the slow query log is turned onShow variables like ' slow_query_log% ' Time to watch slow log settingsShow variables like ' long_query_time% '; Can see the

MySQL prompt writing to net resolutionA database has recently been found to have a CPU usage comparison. More than 200%.First look at the database slow log, set slow log 5 seconds, basically no day, no more than 5 seconds statement.Show full

Objective:On the Internet to find a number of common interview questions, found that asked about the structure of MySQL, I think about it, found nothing, only know that there are several engines, so love to search for me, to find the answer to the

Enter MySQL from the command lineSHOW variables like "have_%";The following 3 possible results are shown in the results: Have_innodb YES Have_innodb NO Have_innodb DISABLED These 3 results correspond to each of the following: The

We sometimes need to check whether MySQL is down or not, and if it goes down, you should automatically restart the app and notify the OPS staff!This script is simple to implement the MySQL after the downtime of automatic restart and mail

Long time did not configure the server, took a lot of detours, some parameters change, the search to the online documents are not updated, so the record self-examination.Version of the selection: An important principle of online system is

MySQL Library and table operationsBasic syntaxCreate Database db3; Create a databaseshow databases; //Presentation databaseMySQL library, which holds the authorization table, the user table, the default tableInformation_schema Data dictionary table,

Http://blog.sina.com.cn/s/blog_6d39dc6f0100m7eo.htmlFunctions and keywords are not case-sensitive in MySQL. The datetime parameter of the following function can be used either as a time string or as a time variable or an expression.First, get the

Notice: article written based on Ubuntu system1. About the MySQL character setMySQL Character set support (Character set supports) has two aspects:The character set (Character set) and the Sort method (Collation).MySQL support for character sets is

1. Query: Log, DB, Tables, descriptShow master logs; # #查看日志 the/usr/local/mysql/data/directory; for mysql5.5show databases; # #查看所有数据库Show tables; # #查看当前数据库的所有表Use database name; # #进入一个数据库DESC table name; # #查看一个表的结构2. New, delete db,

two machines, one is 192.168.223.143, one is 192.168.223.144 master-Slave, now to achieve the demand is two machines from + high availability,VIP This is set to 192.168.223.100First, install MySQL on both machines , do the master-slave

The password is many, sometimes even oneself forgot. This article is a solution to the Windows environment, forget the MySQL database root password.1. First check that the MySQL service is started and stop the service if it is started. Available in

http://wiki.ubuntu.org.cn/MySQL%E5%AE%89%E8%A3%85%E6%8C%87%E5%8D%97Install MySQLsudo apt-get install Mysql-serverThis should be very simple, and I think everyone in the installation is not too much problem, so it is not much to say, the following we

1. Backup TypeDepending on whether the server is able to continue to provide services in the case of a backup: hot, warm, cold backup.Hot backup: Online, read, write not affected;Warm backup: Online, but can only perform read operations;Cold backup:

Remotely connect yourself or someone else's MySQL when prompted with a hint: "1130-host ' win7 ' is not allowed to connect to this MySQL server", meaning that the host does not allow connections to the MySQL server, not allowed because the