Original: http://tech.uc.cn/?p=634For 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 system, the time spent on data import every day can be as
Defined (' ACC ') | | Exit (' Access Denied ');Encapsulates the MySQL operation class, including the connection function, and the query function.Class MySQL extends absdb{protected static $ins = NULL;protected $host; Host Nameprotected $user; User
The Products table is as follows:1. Basic character MatchingUsing regular expressions and like, the regular expression is searched throughout the column, as long as the prod_name contains the characters that are searched, and if you do not use
MySQL wildcard charactersThe pattern match for SQL agrees that you use "_" to match any single character, while "%" matches the random number of characters (containing 0 characters). In MySQL, the default mode of SQL is to ignore uppercase and
The Server_audit module is a mariadb or skysql developed by a MySQL plugin. Can do some auditing on the above work.As is known to all, MySQL is inside is very difficult to record user's Operation command. You can use this. Supports two formats of
1. Back up all databases mysqldump-uroot-p--all-database >C:\all.sql backing up all databases to the All,sql file under the C drive2. Back up a database mysqldump-uroot-p foo >C:\foo.sql backup only foo database3. Back up a table mysqldump-uroot-p
1.RAID Redundant Array of inexpensive Disks 2. Symbolic links Easy to understand is that through the connector point to the operation, artificial to distribute some databases to other folders/disk Linux: Mysql Data path:/opt/mysql/data
1.Key_buffer index block size set global Hot_cache. key_buffer_size =1024x768; //set Size show variables like'key_buffer_size'; View size PS::cannot delete the default Key_buffer size cacheIndexEMP in Hot_cache; //Assigning an Hot_cache index block
Previously built PHP development environment on Ubuntu12.04, according to http://budongzhenren.blog.51cto.com/2288320/991365 installed here. But the system replaced 14.04, and then use this method of installation has been unsuccessful, let me very
MySQL Specifies that search criteria can be searched using the where condition.In the SELECT statement, the data is filtered according to the conditions specified in the Where child statement, which is given after the table name.The product table is
1. The RANGE partition creates an instance:CREATE TABLEEMP (IDint not NULL Primary Keyauto_increment, nameChar( -) not NULL default "') PARTITION byRANGE (ID) (the field ID is defined as the field of the partition PARTITION P0VALUESLess THAN ( -),
Installation of 64-bit Apache server under WindowsThe first thing to note is that the APACEH server does not have the official 64-bit version, only the folk master himself produced. The following are the specific installation steps.
on the
1. MyISAM with memory support table level lock BDB page level lock 2. Table lock (not cousin) lock table read // read-only table lock, This means that after the lock is executed, the operation in the lock can only be read for the
/** Create a new user * * Log in to the root user using the command line tool or IDE. (Command: Mysql-u root-p)*/--Execute SQL statement insert user, want to use password method unified encryption, otherwise can't use. INSERT
It is always known that MySQL paging is written like this:select * From ' yourtable ' limit start,rowsNow, I have a table with 9969W data in my database, and it's called Tweet_data.Select COUNT (*) from Tweet_data Execute the first SQL statement,
MySQL processing millions above data to improve query speed method, other database applications also have a certain reference value:1. Try to avoid using the! = or <> operator in the WHERE clause, or discard the engine for a full table scan using
Common functions:Concat connection function Lower to lowercase upper to uppercase length SUBSTR substring now current time year current years ...Process functions:Ifnull (COLUMN,RESULT1,RESULT2) decision word blank return result2, not empty
How to Improve the paging efficiency of MySQL Data
The data editing and inserting tutorial in this section briefly introduces how to improve the paging efficiency of MySQL Data. The following code is a test code that improves the paging efficiency
13. mysql partition RANGE & LIST, mysqlrange
1. range partition creation instance: create table emp (id int not null primary key auto_increment, name char (25) not null default '') partition by range (id) (define the field id as the PARTITION field
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