I. OverviewThis paper mainly introduces the basic methods and steps of Java database, and gives a brief description of several key points.Second, the database access stepsThere are several main steps to accessing a database in Java:
Load
With the rapid development of our business, the average daily traffic of our servers increased from two hundred thousand or three hundred thousand in the beginning of the year to about 8 million, which is a great challenge to the original
1. What is a transactionA transaction is a combination of one or more database operation statements with acid,4 characteristics.Atomicity: Either all succeeds or all is undoneIsolation: Transactions are independent from one another and are not
MySQL Export DataIn MySQL you can use SELECT ... into OUTFILE statement to simply export the data to a text file.
Use SELECT ... into OUTFILE statement to export dataIn the following example we export the data table TUTORIALS_TBL data to
Database query Optimization There are many things you can do. Here's a summary of some:Basic principles:
Reduce the number of disk I/Os that occur during database queries
Rational use of indexes
Avoid full table traversal,
Installing MySQL on Ubuntu is very simple and requires just a few commands to complete. 1. sudo apt-get install mysql-server 2. sudo apt-get isntall mysql-client 3. sudo apt-get install Libmysqlclient-dev Log in to MySQL database by the following
Environment Introduction:CentOS 6.5MySQL 5.5.40Hardware: 4-core, 4GBReference Links:Http://dev.mysql.com/doc/refman/5.5/en/insert-speed.htmlHttp://dev.mysql.com/doc/refman/5.5/en/server-system-variables.htmlDue to the rapid expansion of business
InnoDB extends the primary key columns by automatically adding them to each two-level index:CREATE TABLET1 (I1INT not NULL DEFAULT 0, I2INT not NULL DEFAULT 0, D DATEDEFAULT NULL, PRIMARY KEY(I1, i2),INDEXK_d (d)) ENGINE=InnoDB;The table
For INNODB data storage files, there are two conceptual issues to be solved first: shared tablespace and exclusive table space. (The InnoDB engine differs greatly from the MyISAM engine.) Especially the way it stores data.)1. Introduction to shared
150210 10:29:16 InnoDB:Warning:trying to delete tablespace '/tmp/#sql2069_87b001_1d. IBD ',Innodb:but there is 1 flushes and 0 pending I/O ' s on itInnodb:loop 1016.150210 10:29:16 InnoDB:Warning:trying to delete tablespace '/tmp/#sql2069_87b001_1d.
Amoeba is a proxy that uses MySQL as the underlying data store and provides the MySQL protocol interface to the application. It responds centrally to the application's requests, sending SQL requests to a specific database based on the rules that the
1. Set or modify the MySQL root password:Default post-installation blank password, set password with mysqladmin command:Mysqladmin-uroot Password "password"MySQL command set Password:mysql> Set password for [email protected]=password (' password
Grant WGDP user Query permission: Grants select on wg_dp.* to ' WGDP ' @ '% ' identified by ' weigou123 ';Grant all privileges on * * to' Yangchao ' @ '% 'identified by ' weigou123 'Query MySQL Other user rights: show grants for WGDP; cancel WGDP
MySql Performance Tuning (3) Table Design
I. first introduce several concepts:1. full function dependency: in the relational mode R (U) of the property set U, if X-> Y, and for any real subset of X ', if both have x' <> Y, Y is fully dependent on X.
Tutorial on using CONCAT functions in MySQL
This article describes how to use the CONCAT function in MySQL. It is the basic knowledge of getting started with Python. For more information, see
Use the MySQL CONCAT () function to connect two strings
Mysql deadlock caused by full disk
Today, I encountered a problem because the disk of the machine where mysql is located is full, leading to a mysql deadlock and not even querying the select statement. If I did not read the mysql Log, I could not
MySQL index type overview enables MySQL to run efficiently
Index is the key to quick search. The establishment of MySQL indexes is very important for the efficient operation of MySQL. The following describes several common MySQL index types.
Index
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