MySQL

Use INFORMATION_SCHEMA;--Querying a database storage sizeSelect Concat (Round (sum (data_length/1024/1024), 2), ' MB ') as data from tables where table_schema= ' database Nane '; 85MB--Query a table storage sizeSelect Concat (Round (sum (data_length/

What is a table partitionIn layman's terms, a table partition is a large table, divided into several small tables according to the conditions. mysql5.1 started supporting data table partitioning.For example, if a user table has more than 6 million

The first step: MySQL installation directory under the configuration file My.ini all default-character-set changed to Default-character-set = UTF8;Part II: Setting the database when the character Set option is selectedThe third step: background code

   $value)  {$data [] =  $key  .  ' = '  . parse_value ($value);} return  $data;}This article is from the "Hello I am Forest" blog, please make sure to keep this source http://chensenlin.blog.51cto.com/10559465/1844018PHP's custom functions for

I. BACKGROUNDBecause of the project needs, the MySQL database needs to be connected to the Sbt+scala project. As a result of the previous use of Maven+java to rely on management, in the Sbt+scala aspect is also constantly groping, hereby recorded,

Before talking about isolation, we need to talk about the acid characteristics of relational databases.A (atomicity, atomicity), which means that a transaction is either fully completed or rolled back to the starting state, and there is no

Probably a lot of people used to use RPM package in the deployment of MySQL after the binary package does not understand how to use (concrete MySQL binary deployment can see HTTP://JIM123.BLOG.51CTO.COM/4763600/1835010), in fact, do not worry, After

Original address: http://www.linuxbrigade.com/back-up-all-of-your-mysql-databases-nightly/Put the following into something like/usr/local/bin/mysql_backup.sh and since it have MySQL ' s root password in it, make Su Re that you chmod for it so no one

Heard is very old things, learning when found still very useful, so learn to reprint, stay prepared to learn.MySQL Export a word　　 Method 1: Popular methods on the Internet Process: (1) Build Table---> (2) Insert Data---> (3) Select

Turn on Slow queryFirst we check if the MySQL server's slow query status is turned on. Execute the following command:650) this.width=650; "Src=" http://images.cnitblog.com/blog/44702/201301/ 23175454-351c6f142b774ac9bbe923faf9482c85.jpg "style="

MySQL backup and restore details under Centos 6.4We described in the previous article in CentOS 6.4 installation and configuration of MySQL, after installation in order to ensure the security of data so we also have to learn to back up and restore,

Centos 6.4 Under MySQL configuration master-slave service (cluster)Two of our previous articles are described in MySQL installation and configuration, backup and restore, today we continue to the previous environment described in CentOS 6.4 mysql

In MySQL database system, char and varchar are very common, and they are two very similar, are used to save relatively short string, such as saving the article title, message, email, user name and so on. The main difference between the two is the

Then talk about how to modify the transaction isolation level:1. Global modification, modify the Mysql.ini configuration file, at last add1 #可选参数有: read-uncommitted, read-committed, Repeatable-read, SERIALIZABLE.2 [mysqld]3 Transaction-isolation =

MySQL Master-slave replicationMySQL supports unidirectional two-way chaining cascading real-time asynchronous replication, where one server acts as the primary server (master) during replication, while one or more other servers act as slave servers (

master-Slave form MySQL master-slave replication flexibility One Master one from Primary master replication One master multiple reads from the---extended system, because reads are read from the library; Multi-master One

1) about the configuration file pathSometimes I find that although I try to modify some variables of the configuration file, it does not take effect. It turned out that the modified file was not a configuration file read by the MySQL server.If you

Where the original password is known: How to change the password (need to log in with the root user)Go to MySQL Database[Email protected] System name ~ "#mysql-uroot-p original password650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/86/28/

The code is as follows:12 connect the database with mysqli process-oriented methods! -Yao Yuan's blog 3$_server[' php_self ']); /using the Htmlspecialchars () function to?> the output of the ">4Server address: 56Server account: 78Server password:

Mysql master-slave replication practicesAsynchronous master-slave Replication  Master-slave deployment steps: Backup and Restoration Use mysqldump or xtrabackup Restore the existing basic data of the master database to the slave