MySQL partition table (RPM)

View partition status SELECT * from information_schema. Partitions WHERE table_name=' table_name '; Partition_name: Name of the partitionPartition_method: Type of partitionTable_rows: Number of partitioned data barsRange Partition:

Optimize MySQL, or use a cache? Read an article in the thoughts

Today I would like to compare a variety of performance optimization strategies that can be used on a greenfield project . In other words, the project has not been optimized for the constraints imposed on it by previous decisions.Specifically, the

High performance MySQL (i)

1. Connecting and Managing SecurityWhen the client side connects to the MySQL server, it will have a thread on the server side, and the connected query will be executed in this separate thread. The server is responsible for caching threads, so there

MySQL performance optimization

Home page of http://blog.csdn.net/uestc_huan/article/category/536350 Bo Masterhttp://blog.csdn.net/uestc_huan/article/details/6071081 Blog AddressThis article does not explain how MySQL server parameters are set from a DBA perspective, but from the

MySQL Backup and Restore (ii) Almost hot provisioning based on LVM

LVM (Logical Volume Management Logical Volume management) implements the principle of almost hot-standby: The use of LVM snapshot volume to save the instantaneous state of the database at a certain moment, just take the snapshot back up.The

MYSQL Command line Client commands series

——————————————————————————————————————————————————————————First, start and exit1. Go to MySQL: start MySQL Command line Client (MySQL dos interface) and enter the installation password directly. At this point the prompt is:mysql>2. Exit

MySQL Function summary

1, Date_add (Curdate (), interval-30 Day) Table time Plus, get the current date 30 days before the time. Date_sub (now (), interval 1 days) indicates that the time reduction 2, Unix_timestamp () time conversion 3, CAST () casting. Example: Select

Change MySQL database storage path under Linux

Original: http://www.cnit618.com/html/fwdkf/data/2111.htmUnder Linux, the default data document storage directory for MySQL is/var/lib/mysql. The following steps are required if you want to move the MySQL directory to/home/data: 1. Set up the data

MySQL Basics Summary

Server: mysqld client: MySQLCommon Management Commands : (Note: All commands to be executed on the server end with; Login: Mysql–uuser–ppassword–hhost Specify the user, password and MySQL host can log in, you can also create a. my.cnf

Modify Mysql-root password under Mac-Solve various permissions problems

Official information: Http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unixThere is also a reference to MySQL installation, with Python-mysql installation blog http://hearrain.com/2011/01/498According to

PHP Operation MySQL Summary

Connecting to a databaseSet the document display encodingHeader (' Content-type:text/html;charset=utf-8 ');if ($con =mysql_connect (' localhost ', ' root ', ' 1234 ')) {//Return connection identifierEcho ' Connect success ';}else{Echo ' Connection

Copy of MySQL Series 1----principle

MySQL Replication Introduction:MySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers.The MySQL master server writes the update to the binary log file

Mysql-python Socket Connection Error

Premise: Cygwin connection to Windows version of MySQL via Mysql-python module Cannot connect via socket, instead TCP Connect as follows conn = MySQLdb.connect (host= ' localhost ', port=3306,user= ' xxx ', passwd= ' xxx ', db= ' xxx ', charset= '

Windwos php mysql Apache configuration

First step: Download the installed files1. Mysql:mysql-5.1.49-win32.msi;2. Apache:httpd-2.2.16-win32-x86-openssl-0.9.8o.msi;3. PHP5.3.3 php-5.3.3-win32-vc6-x86 Note: Be sure to download the php-5.3.3-win32-vc6-x86 version, do not download the php-5.3

Install MySQL under Ubuntu and connect to the external network

Pure Beginner Tutorial.1. Install MySQLDuring installation, you will be prompted to set a password for the database root account, enter both sides of the password2. EnterMysql 3, Reset MySQL user root password GRANT all privileges on *

MySQL Create timed tasks

First, preface since MySQL5.1.6, has added a very distinctive feature – event scheduler, which can be used to perform certain tasks on a timed basis (for example: Deleting records, summarizing data, etc.). To replace work that was previously only

Solution Deprecated:mysql_connect (): The MySQL extension is deprecated and would be removed in the future:

Mysqli more rigorous, safe and efficientPHP 5 version, 5.2, 5.3, 5.4, 5.5, afraid to keep up with the times, the new server directly on the 5.5, but the program appears the following error: Deprecated:mysql_connect (): The MySQL extension is

MySQL single-table million data record paging performance optimization

background:One of their own site, because the single-table data record up to 1 million, resulting in slow data access, the background of Google Analytics often report timeouts, especially pages with large page is slow.test Environment:First let's

Analysis of MYSQL REPEATABLE-READ isolation level, repeatableread

Analysis of MYSQL REPEATABLE-READ isolation level, repeatableread The REPEATABLE-READ can be read repeatedly, and the contents of the select table in the set autocommit = 0 or start transaction state will not change. This isolation level may cause

Mysql DATA group obtains all the largest record rows of a field value, mysql Field

Mysql DATA group obtains all the largest record rows of a field value, mysql Field Requirements: The same uid (User) in the table has multiple game level records. Now we need to retrieve the data of the highest level of all users, and the earlier

Total Pages: 3233 1 .... 1324 1325 1326 1327 1328 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.