mysql documentation

1: How to retrieve MySQL dataUsing repair table can retrieve most of the data, but there are still some error records (These records are in the copy data file when the record is read and write) in the repair is deleted directly. So, I realize that

Background-3 Import and export related operations explained load_file () export FileLoad_file (file_name): reads the file and returns the contents of the file as a string.Conditions of Use:A. Must have permission to read and the file must be

View MySQL Execution planUse Navicat to view the MySQL execution plan:Open Profile Analysis tool:Check to see if it takes effect: Show variable like '%profil% ';View process: Show Processlist;Select database: Use Db_jiakao;Type of all analysis: Show

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

What is an API?An application interface (application programming interface abbreviation) that defines the classes, methods, functions, variables, and so on everything in your application that needs to be called in order to complete a particular task.

MySQL Lock Processing Analysis turn http://hedengcheng.com/?p=771 Ten 13th, 2013 comments | Trackback1 background 11.1 Mvcc:snapshot Read vs current Read 21.2 Cluster Index: Clustered Indexes 31.3 2pl:two-phase Locking 31.4 Isolation Level 42 A

optimization of cache parameters for MySQL database performance optimizationThe database is an IO-intensive application whose primary responsibility is to manage and store the data. And we know that the time to read a database from memory is the

PrefaceThe global share is mainly the MySQL Instance (mysqld process), and the underlying storage engine is used to stage various global operations and shareable staging information, such as query cache to store queries cached, thread cache of the

1. Optimize your query for query cachingMost MySQL servers have query caching turned on. This is one of the most effective ways to improve sex, and this is handled by the MySQL database engine. When many of the same queries are executed multiple

The following mentioned software everyone can search on the Internet, or through QQ 121088825 find me, I send you.1th step: Download an ODBC data source connection first, note that 32-bit system installs 32-bit software, 64-bit system installs

Transferred from: http://chenling1018.blog.163.com/blog/static/14802542010320112355598/The MySQL permissions system revolves around two concepts:Authentication, determining whether a user is allowed to connect to a database serverAuthorization,

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

A solution for MySQL assertion Failure Fil_nullhttp://michaelfranzl.com/2014/01/25/solution-mysql-assertion-failure-fil_null/A Defective RAM module recently caused data corruption in MySQL tables. MySQL would log the following to/var/Log/syslog in

20 Experience tuning MySQL performance optimizationPublished: February 15, 2012 published by: OurmysqlSource: Web Base is read: 3,354 kills 0 comments This article will introduce you to 20 MySQL performance optimization experience, these little

When I recently looked at the help documentation for the MySQL lock table, I found a bit of a problem with the lock table before using Mysqldump Backup, which was the mysql-a-bse "flush tables with read lock" when doing the backup script. Back to

The security of the database is usually the most serious in the security operations, so in peacetime need to do firewall security policy, as well as master-slave replication real-time hot-standby and the corresponding disaster capacity backup

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

Http://coolshell.cn/articles/1846.htmlToday, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database

Excerpt from: http://stackoverflow.com/questions/5317889/sql-keys-mul-vs-pri-vs-uni/15268888#15268888 SQL keys, MUL vs PRI vs UNI DESCRIBE ; Acutally a shortcut for: SHOW COLUMNS from ; In any case, there is three possible values for the "Key"

1. BackgroundMysql/innodb's locking analysis has been a difficult topic. In the course of my work, my colleagues have often consulted on this issue. At the same time, the micro-blog also often receive the MySQL lock-related private messages, let me