MySQL

Introduction and installation of the tutorial on using the Percona-toolkit ToolkitHttp://blog.chinaunix.net/uid-20639775-id-3206802.htmlThe Percona-toolkit tool Kit uses the development tools

The use of MySQL WorkbenchThere are multiple visual tools for MySQL, where we use MySQL workbench to create databases and tables. "Visualization tools can improve productivity". We need to use the most convenient method to deal with problems in our

First, MySQL gets the current date time function1.1 Get the current date + time (date + times) function: Now ()Mysql> Select Now (); +---------------------+| Now () |+---------------------+| 2015-01-22 22:20:46

The following is from the MySQL manual:13.5.5.3. Kill syntaxKILL [CONNECTION | QUERY] thread_idEach connection to the mysqld is run in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a

Problem one: When we do the database operation, we will find that the table in the database is encoded with UTF-8, but the DOS command is to use set names GBK(a) The default character set in MySQL is four levels: server level, database level, table

MySQL database insert and UPDATE statementsCitation: SQL used to manipulate the database is generally divided into two types, one is the query statement, which is what we call the SELECT statement, the other is the UPDATE statement, also known as

MySQL Bulk SQL Insert performance optimizationsPosted by Kiki TitaniumOn December 7, 2012 For some systems with large data volume, the problem of database is not only inefficient, but also the data storage time is long. Especially like a reporting

String functionsASCII (str)Returns the ASCII value of the first character of the string str (str is empty when the string returns 0)Mysql> Select ASCII (' 2 ');50Mysql> Select ASCII (2);50Mysql> Select ASCII (' dete ');100ORD (str)If the string str

Simple explanationMySQL Server received a request from-you-to-connect to the database. So next thing it tried to do are to check the name is bound to your IP address (name resolution) and it failed to do s O. So it just denied you access.You can

The extract part is shown here, as below,What's the difference in using Clustervs using replication?In a replication system, one MySQL master server updates one or more slave servers. The transactions are committed sequentially, so a slow

Changing password for database users is one of the more common tasks for DBAs. There are several different ways to password changes to the MySQL user account. The recommended way to use cryptographic functions is to change the password.This paper

Thank you: http://www.111cn.net/database/110/d45124323da8d2d87b80f78319987eda.htmView another blog on the same topic: http://blog.csdn.net/cleanfield/article/details/41447585----------------------------------------------------------------------------

1. Create Categories Admin Page Mainly includes the following pages: A. index.php, prepare various variable data. For display page use. B. categories.html.php, showing categories. C. form.html.php, which is used to edit or add author pages. Page

For a long time not using Ubuntu, come in to play today, the result even the root user password of the MySQL forgot. On the internet to find a bit, found the following solutions, try a bit, feasible! It is important to note that environmental issues

I. MySQL storage engine classification and applicationMyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB), EXAMPLE, Federated, ARCHIVE, CSV, Blackhole.MySQL supports several storage engines as a processor for different types of tables. The MySQL

Excerpt from: http://www.jb51.net/article/33736.htmWith the help of explain, you know when to add an index to the table to use the index to find records and make the select run faster.If some problems arise due to improper use of the index, you can

One: MySQL user managementMySQL database has only one root user by defaultMySQL saves user information in the MySQL database user tableCreate a new User: The Create user usernameidentified by ' Password '; #新用户创建后不能登录, because no permissions are

This article is a computer Quality Pre-sale recommendation >>>> MySQL Troubleshooting guideMySQL Troubleshooting reference books every DBA and database support person should read the booksContent IntroductionThe MySQL Troubleshooting guide, written

MySQL users faq:how do I show/list mysql users, i.e., the user accounts in a MySQL database?To show/list the users in a MySQL database, first log into your MySQL server as an administrative user using the mysql CLI ENT, then run this MySQL

Centos7.1 1053 minimized installation Lnmp through Yum installation, because the CENTOS7 does not have the Yum source MySQL, so to install the MySQL yum source itself, but installed, in my this Yum installed only dozens of K speed, So simply go to