MySQL

Core tips: This article summarizes the mysql-noinstall version, that is, the installation and configuration application of the decompressed version. These operations are commonly used. The article does not describe the executable installation

Here, we will introduce the exclusive threads used in MySQL memory. The exclusive thread memory is mainly used for various client connection threads to store exclusive data for various operations, such as thread stack information and grouping and

MySQL database is an open source database based on structured data. SQL statements are the core language of MySQL databases. However, when executing SQL statements in the MySQL database, you need to be careful with two traps. Trap 1: NULL values are

1. log on to the MySQL database server from the command line1. log on to MySQL with the default port 3306/Usr/local/mysql/bin/mysql-u root-p2. manage multiple MySQL instances with different ports through TCP connections (note: this function is

In actual work, we often accidentally delete the database or table and regret it. Is there any regret to take? The delayed backup described today can be achieved. Delayed backup causes slave to lag behind the master for a period of time. When a

Author: skateTime: 2012/02/17Installation and Use of MySQL SLA1. Download mysqlsla[Root @ localhost tmp] # wget http://hackmysql.com/scripts/mysqlsla-2.03.tar.gz-- 19:45:45 -- http://hackmysql.com/scripts/mysqlsla-2.03.tar.gzResolving hackmysql.com..

I found a MySQL technical article on the Internet. It feels good. I have translated it and shared it. Author: Mike Peters I have sorted out seven methods to fix the MySQL database. When a simple restart does not work for the database or a table

Change innodb_log_file_size to solve InnoDB: ERROR: the ag... sometimes Mysql reports an ERROR: 120418 8:00:14 InnoDB: ERROR: the age of the last checkpoint is 9434204, InnoDB: which exceeds the log group capacity 9433498. innoDB: If you are using

Allow external ip addresses in linux to access your mysql database 1: Set the mysql configuration file/etc/mysql/my. cnf, find bind-address = 127.0.0.1, and comment it out. // This function no longer allows local access only. Restart mysql:/etc/init.

MySQL experience 10-1-transaction 1. In the MySQL environment, a transaction is composed of one or more SQL statements as a separate unit. Each SQL statement in this unit is mutually dependent, and the Unit as a whole is inseparable. If a statement

I forgot the password of the root account of the MySQL database. How can I modify the background:MySQL Database root Account is generally known only to MySQL DBAs, And the password of this account must be kept strictly confidential. Once the leakage

MySQL audit plug-in installation instructions-the upgraded version is based on the mysql audit plug-in designed and developed earlier, and the MySQL audit plug-in installation instructions http://www.bkjia.com/database/201207/143906.html To add and

[Intrinsic column flags] (basic field type identifier)-PK: primary key (column is part of a pk) primary key-NN: not null (column is nullable) non-null-UQ: unique (column is part of a unique key) unique-AI: auto increment (the column is auto

MySQL lock usage-table-level lock mechanism is an important feature of a database that is different from the file system and an effective way to manage concurrent access. MySQL locks include table-level locks, page-level locks, and row-level locks.

Shell simple full-backup mysql script case [root @ cacti mysql] # cat backup. sh #! /Bin/sh www.2cto.com # created by taiyang #2012-9-16 # function: backup mysql database # set local variablesDBname = backupBackupPath =/mysqlbak/DumpFile =$

Run the mysql SQL file mysql-uroot-proot in linux to enter mysql and then run source/var/ftp/pub/sogoodsoft. SQL. Go to www.2cto.com for the following content: Summary of mysql commands in linux-essential for learning linux + mysql I. Summary of

The method for returning mysql auto-increment IDs to 0 is always to initialize data for the current project, which is a headache and the auto-increment of database IDS is getting bigger and bigger, to re-start auto-increment from 1: Use the

MySQL learning footprint record 04 -- Data Filtering -- WHERE 1. Use the WHERE clause eg: mysql> SELECT prod_name,prod_price FROM products WHERE prod_price=2.50;+---------------+------------+| prod_name | prod_price |+---------------+----------

MySQL big data warehouse receiving (single table) has been studying data warehouse receiving recently. For the INSERT command, a small amount of data can be satisfied, while for a large amount of data to be inserted into the same table, the speed is

What is database/table sharding technology I. Overview table sharding is a popular concept. Especially under heavy load, table sharding is a good way to distribute database pressure. First, you need to understand why Table sharding is required. What