MySQL

Since the website system was launched, the data volume reaches 500 mb, nearly records. Database Operations are basically slow, and users will feel angry ~~ Then I posted this situation in the group, including the machine configuration and so on.

BLOB is a large file. A typical BLOB is an image or sound file. due to their size, it must be processed in a special way (for example: upload, download, or store data in a database ). According to Eric Raymond, the main idea of processing BLOB is to

Test Table Structure:Copy codeThe Code is as follows:---- Table structure 'tet'--Create table if not exists 'tet '('Id' int (11) not null,'Name' varchar (255) not null,'Url' varchar (255) NOT NULL) ENGINE = InnoDB default charset = utf8;---- Store

Problem (Multiple Primary auto-growth IDs are repeated)1: First, we use the test table structure of A and B.2: Drop A, insert the data table test (with an auto-increment ID) on B, and return the insert ID as 1.3: Stop B and insert the data table

1. Introduction to XtrabackupA. What is Xtrabackup?Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup.Xtrabackup has two main

Table Structure:Mysql> desc demo;+ ------- + ------------------ + ------ + ----- + --------- + ---------------- +| Field | Type | Null | Key | Default | Extra |+ ------- + ------------------ + ------ + ----- + --------- + ---------------- +| Id |

I have summarized the common methods for determining whether a record exists:SQL statement: select count (*) from tablename;Then read the value of count (*) to determine whether the record exists. The performance of this method is a waste. We just

Replace and regexp usage0 Comments | This entry was posted on Apr 08 2010.Mysql replace usage1. replaceReplace into table (id, name) values ('1', 'A'), ('2', 'bb ')This statement inserts two records into the table. If the primary key id is 1 or 2

In MySQL database operations, we often write some SQL statements to implement the functions we want. However, it seems difficult for beginners of MySQL databases. This article summarizes six useful SQL statements. Beginners can use the following

MySQLDatabaseVarcharWhat is the maximum length? In fact, this is not a fixed number. The length of varchar isRestriction rules. In this article, we will introduce the varchar restriction rules in the MySQL database, and describe the restriction

Regular mysql backupPut/etc/cron. hourly/Copy codeThe Code is as follows:#! /Bin/bashDUMP =/usr/local/webserver/mysql/bin/mysqldumpOUT_DIR =/data1/backup/DB_NAME = Database NameDB_USER = Database UserDB_PASS = Database Password# How much days backup

I. Automatic Backup: Save the following code as a *. bat batch processing script, and then add Windows scheduled jobs, such as running at every day:Set s = % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2% % time :~ 1, 1% % time :~ 3,2% % time :~ 6, 2%

ERRNO: 256TEXT: SQLSTATE [HY000]: General error: 1436 Thread stack overrun: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. use 'mysqld-O thread_stack = # 'to specify a bigger stack. According to the MySQL manual "The default (192KB)

Statement: alter table tableName engine = InnoDB;Tables UsedCopy codeThe Code is as follows:Create table if not exists 'test '('Id' int (10) not null auto_increment,'Websitename' varchar (200) character set utf8 not null,'Websiteurl' varchar (200)

My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what shoshould be tuned in MySQL Server straight after installation, assuming it was installed with default

Currently, you can set options to operate the connection timeout of two client extension libraries, such as mysqli:Copy codeThe Code is as follows:// Create an object$ Mysqli = mysqli_init ();// Set the timeout Option$ Mysqli-> options

Run the cd command on the terminal to enter the file directory.Note: here is an example of the project.1. create a project: Enter zf create project Airline in the format of zf create action project-name in the terminal. Note: You can enter zf in the

Environment: master server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.22 slave server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.33 configuration: 1. master server 1.1, create a copy user, has the replication slave permission. Mysql>

I. Major changes from 4.0 to 4.1If an InnoDB table containing the TIMESTAMP field is created in MySQL from version 4.1.0 to version 4.1.3. You need to recreate the table when upgrading to 4.1.4 and later, because the storage format has

1. Optimize Your MySQL query Cache You can enable the High-Speed query cache for queries on the MySQL server. It is one of the most effective ways to improve performance by quietly processing the database engine in the background. When the same