MySQL

Author: skateTime: 2012/12/4   MySQL thread entry-level analysis   This afternoon, I discussed the thread pool of MySQL with my friends in the group. The discussion was very lively and I had a lot of GAINS. I would like to summarize the

Title: Forgot MySQL passwordSource: water in the Pacific OceanTime: Tue, 14 Mar 2006 12:59:43 + 0000Author: water in the Pacific OceanHttp://blog.ciyi.net/read.php? 936 Content:If MySQL is running, first:# Killall-term mysqld // kill the MySQL

1) if you have not forgotten the password, you can use update to directly edit the user table to change the password: Enter mysql-u RootMysql> use MySQL;Mysql> Update user SET Password = PASSWORD ('newpass') where user = 'root ';Mysql> flush

Author: sakte Time: 2013/02/27   MySQL development specification documentation   1. MySQL database naming rules 2. Table Structure Design and Data Type Selection 3. Development considerations   1. MySQL database naming rules 1.1

Author: skateTime: 2012/07/02 MySQL Optimization-DDL statements When the drop table maintains the MySQL database, the entire system will be hang during the drop operation. The duration of this hang is related to the buffer pool size. The main

About MySQL permission allocation   The MySQL permission system involves two concepts: 1: Authentication-> determine whether the user is allowed to connect to the Database Server 2: authorize-> determine whether the user has sufficient

12.8. Cast functions and operatorsBinaryThe binary operator returns a binary string. This is a simple way to promote column comparison by byte rather than by character. This makes the comparison case sensitive, even if the column is not defined as

In general, there are two possible causes for Garbled text. The first reason is the incorrect encoding (charset) setting, which leads to the incorrect encoding resolution by the browser, resulting in the "tianshu", which is full of screens ",

Author: skateTime: 2012/02/18   MySQL table design ------- column type Introduction   Some experience in database design, rational evaluation of table increments, estimated size, number of database/table shards, and the number of whole database

Author: skateTime: 2012/02/17 MySQL records time-consuming SQL statements MySQL records time-consuming SQL statements or SQL statements without indexes in slow log for optimization analysis. 1. MySQL slow query log enabled:MySQL slow query logs are

1. Use the show statement to find out the current database on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | +----------+ 3 rows in set (0.00 sec) 2. Create a database, abccsMysql> Create

Author: skateTime: 2012/05/24   MySQL analyzes existing tables and provides column-optimized data types to reduce the table size, for example, in French: Select... from... where... procedure analyse ([max_elements, [max_memory])   Note:Max_elements:

Author: skateTime: 2012/08/28 MySQL memory principle and Data Structure     The general content is as follows: 1. How does MySQL complete a session?2. MySQL Memory Structure3. Mysql Data Structure4. MySQL architecture ideas     ........ Notes for

Author: skateTime: 2012/11/28 MySQL partition ---- column Partition   MySQL supports column partitioning from MySQL 5.5. It can also be considered as an upgraded version of range and list partitions. The column partition can require the partition

Author: skateTime: 2012/05/18 Modify the character set and default storage engine of MySQL   1. Modify the MySQL Character Set MySQL library's existing Character SetMysql> show variables like 'character % ';+ -------------------------- + ------------

Author: skateTime: 2013/03/25 Install and use tpcc-MySQL Download ToolkitTpcc-MySQL is a product derived from tpcc. It is used to test the system performance of OLTP (online transaction processing, TPCC-MYSQL is open source TPC-C testing software.

Mysqldump [Options] database [Tables] If you do not specify any table, the entire database will be exported. Run mysqldump -- help to obtain the option table supported by your mysqldump version. Note: If you run mysqldump without the -- quick or --

In Vim editing mode, the number of lines "sudo VI/etc/Vim/vimrc" can be displayed. Add "set nu" to the opened file and save the settings and exit. Use: "vi. bash_history" to view the previously entered commands If the system prompts that MySQL

In the website background, you often have to deal with databases. This article describes how to use XAMPP to manage MySQL Databases and How to Use PHP to access MySQL databases. 1. Use XAMPP to manage MySQL Databases Use XAMPP to open the MySQL

Reference blog: http://lhflinux.blog.51cto.com/1961662/506467 Thank you very much for sharing this information! The following is the script I modified based on the above blog! 1. Complete backupVI full_mysqldump.sh#! /Bin/sh# Test by XXXXX# Time