0. Read uncommitted (read uncommitted transaction data-dirty read)
1. Read committed (Only the transaction data can be read and committed-the transaction data cannot be read repeatedly)
2. Repeatable read (New data can be read only when both
Query_cache_min_res_unit: query the minimum block size (in bytes) allocated by the cache)
Query_alloc_block_size: QueryDuring analysis and executionMemory block size allocated to the created objectQcache_free_blocks indicates the number of free
It is fast enough to run a common MySQL with a small amount of data and traffic. However, when the data volume and traffic volume increase sharply, it is obvious that MySQL is slow or even down, we need to consider optimizing our MySQL. An important
Load data infile "/home/mark/data. SQL" into Table orders;
To put it simply, the content in the file data. SQL will be imported into the table orders. Like the mysqlimport tool, this command also has some optional parameters. For example, if you
Use of delayedUse delayed insert operationsThe delayed modifier is applied to insert and replace statements. When the delayed insert operation arrives,The server puts data rows in a queue and immediately returns a status message to the client.You
MySQL provides many table types for selection, including MyISAM, isam, heap, berkeleydb, and InnoDB. Each table Type of MERGE table type has its own attributes and advantages. The following is a brief discussion.
MyISAM Table type:
MyISAM
Table (
A very simple paging technologyMySQL+ JSP uses the MySQL limit parameter
Advantages: 1. I figured out 2. I used the MySQL database's own limit.
Disadvantage: only the next page function is implemented.
Int cateid = 0;If (request. getparameter ("
The company went to MySQL 5.0, and what followed was not how easy it was to use, but how easy it was to use mysqlcc... the error message "[192.168.22.72] Error 1146: Table 'rimkpi. 1 'doesn' t exist. You cannot directly modify the selected data in
MASTER:Show Master Status;-view status:Show processlist;-view MySQL process information under slaveReset master; # Use with caution to clear logs and synchronize the position
Slave end:Show slave status;Show slave logs;Show processlist;Reset slave; #
1. Command Line
Preface:
To know the space occupied by a table, it is equivalent to the data size + index size.
Show databases; (view the number of databases, also known as table Schema; it is a bit of a string)
1.1 view the size occupied by a
MySQL character set support has two aspects:Character Set and collation ).The support for character sets is refined to four layers:Server, database, table, and connection ).
1. Default MySQL Character Set
MySQL can refine the character set
I. Database Operations
A) Check the number of databases currently in showdatabases;
B) Create the createdatabase database name. You can also set the encoding method and calibration rules followed by the characterset encoding method collate
I. operation data (query)
1. Distinct
Syntax: select [distinct] column name [, column name]... from Table Name
Distinct is used to filter duplicate records. If distinct is followed by multiple columns, it filters out duplicates after multiple
Let you quickly review the notes of the statement.
Create Table users (Username varchar (20) primary key,Userpwd varchar (20))
Alter table users add age int
Insert into Stu (sname) values ('sdfdsfdsfeeeeee ')Update CJ set Cj = 60 Where sid =
Reference http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html
1. Download the MySQL JDBC driverHttp://mysql.mirror.vmmatrix.net/Downloads/Connector-J/mysql-connector-java-3.1.13.tar.gzDecompress the package and copy the JAR
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