MySQL

caused by:com.mysql.jdbc.PacketTooBigException:Packet for query is too large (1856352 > 1048576). You can change this value on the server by setting the Max_allowed_packet ' variable. Because the packet size setting of the communication for MySQL

1.1 Get the current date + time (date + times) function: Now ()In addition to the now () function to get the current datetime, MySQL has the following function:Current_timestamp () Current_timestampLocalTime () localtimeLocaltimestamp ()

  When you are using the Explain tool to view the run schedule of the SQL statement. If the Select_type field appears in theDEPENDENT subquery"When you have to pay attention." You have fallen into the MySQL sub-query slow "pit" ...Let's look at a

Today, MySQL errors error No. 1451 when deleting a table of type InnoDB.Mysql:cannot Delete or update a parent ROW:A FOREIGN KEY constraint failsWorkaround:This could be because MySQL set the Foreign Key association in InnoDB, causing the data to

My MySQL learning experience (a) simple grammarMy MySQL learning Experience (ii) data type widthMy MySQL learning Experience (iii) View field lengthMy MySQL learning experience (iv) data typeMy MySQL learning experience (v) operatorMy MySQL learning

MySQL 5.5 (5.6) Later, need to compile with cmake (cross make, https://cmake.org/)My environment is as follows:　　　　VMware virtual machine, CentOS 5.5 x86_64 (kernel: 2.6.18-194.el5), SECURECRT clientFirst step: Install the development

DirectoryFirst, the basic concept1, MySQL multi-instanceis to open multiple different ports on a single machine and run multiple MySQL service processes. These MySQL multi-instance common set of installers, using different (can also be the same)

MySQL failed to open Filemysql failed to open file '/usr/xxx/fff.sql 'A problem, when using the source command to import data under Linux, reportERROR:Failed to open file '/data/xxx/fff.sql ', error:2Ii. Solutions(First remember to use the database

1. Install MySQL# sudo apt-get install Mysql-serverThe installation process needs to enter the root password, which is the root password of MySQL, then connect to MySQL will be used, this to remember.After the installation is complete, you can use

Previously on the internet to see crooked people specifically wrote this mysql stored procedures, feel very powerful ah. Just recently the optimization of the new project to use the stored procedure, I took the previous study notes to tidy up a bit.

MySQL master-slave (MySQL Replication), mainly used for MySQL backup or read-write separation. Before you configure the configuration, configure two MySQL servers, and if your machine cannot run two Linux VMs at the same time, consider running two

CentOS just installed MySQL generally need to reset the MySQL password, can be reset in the following ways.Method One,JS Code#/etc/init.d/mysqld Stop# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &# mysql-u Root MySQLmysql> UPDATE

MySQL ProgrammingNote: line: # OR--Defining variablesSet Variable name = variable nameNote: In order to differentiate system variables and fields at the plus of an @ identifierFor example Set @who = ' Korean ';Use Select to get the value of the

MySQL backup and recoveryNote: The backup is not successful because the version may not be the same, you need to execute the command #cp/usr/local/mysql/bin/mysqldump|mysqlhotcop|mysqlimport/usr/local/bin/(1) mysqldump Backup toolBack up the tables

A lot of MySQL statements don't remember when they're used, so let's take a simple example./*SQLyog Ultimate v11.33 (+ bit)Mysql-5.1.49-community:database-db_book**********************************************************************//*!40101 SET

The operation is very simple, just 5 steps, as follows:1. Go to MySQL:? 1 /usr/local/mysql/bin/mysql -u root -p 2. Use the MySQL library:? 1 use mysql; 3. View the user table:?

MySQL 5.1 Upgrade compile install 5.6 Convert the original MyISAM table to InnoDB and back up the global one at a time1."Backup specified database" Do not use commas mydb hellodb[Email protected] ~]# mysqldump-uroot-p--databases mydb hellodb

For me who has been using Oracle, today is very surprised, MySQL in the same function at different orders of magnitude of performance incredibly large.First Look at Table ibmng (id,title,info) Unique ID key index titleLet's take a look at two

MySQL functions are divided into several Mathematical functions String functions Date and Time functions Conditional Judgment function System Information functions Cryptographic functions Formatting functions

Ptmalloc is GLIBC's memory allocation managementTcmalloc is Google's memory allocation management moduleJemalloc is BSD's provided memory allocation managementThe performance of the three Jemalloc and Tcmalloc is not the same, but the Ptmalloc is