MYSQL (iii)The previous chapter to everyone said is the database view, stored procedures and so on, this chapter is mainly about indexing, as well as indexing considerations, if you want to see the previous article, the URL is as follows:
Summary: 1, configure the master server 2, configure the server 3, master and slave server Status View and problem handlingMySQL master-Slave synchronization architecture is currently a popular database architecture, using MySQL master-slave
Operation of the listCreate a tableWhen creating a table, make sure that the table does not exist before, and if it does, it should be deleted and then createdAuto_increment indicates automatic increaseWith default values, the default constants are
1. Select the most applicable field propertiesMySQL is good at supporting large data volumes, but in general, the smaller the tables in the database, the faster queries are executed on it. Therefore, in order to achieve better performance when
CREATE database database_name; Delete databases: DROP database database_name; using database: use database_name; View the types of storage engines supported by the system: Show Engines: ALTER TABLE offices rename Offices_new; Modify the data type of
Get to know the common interface of JDBC in the first1. Driver Interface DriverThe driver for each database should provide a class that implements the Java.sql.Driver interface, referred to as the driver class. Typically, the driver class to connect
Original Document Address: http://www.itpub.net/thread-1766546-1-1.html1, on the Linux server through the wget command to obtain the RPM package:Wget–c
I. Introduction to the DatabaseWhat is a database?Data warehouses, such as: In an instance of ATM we create a DB directory called a databaseWhat is MySQL, Oracle, SQLite, Access, MS SQL Server, and more?They are database software, the main function
Student (id,sname,age,sex) Student tableCourse (id,cname,t_id) timetableSC (s_id,c_id,score) score tableTeacher (id,tname) Teacher tableProblem:1. Check the number of all students with "001" courses that are higher than the "002" course;Select Aa.id
1. Connection data:Format is:-P port number-H mysql hostname \ip-u root (user)-P2. Display the database:show databases;3. Select the database:Use DatabaseName; DatabaseName is the name of the database you want to select4. Display the table of the
Apache: is a Web server (similar to IIS)PHP: All called hypertext preprocessor.PHP is an HTML embedded language, is a Web site (web) development language (with ASP, JSP,. NET, etc.)MySQL: is a database (similar to SQL Server, etc.)To access Web
MySQL index types and syntaxTo view all the indexes on a single table: Show index from table name;To build an index: Alter Table name Add index Normal index/unique unique index/fulltext full-text index/primary key primary key index + column
This article mainly introduces the basic methods of user and rights management in MySQL, including some common command statements that can be manipulated by various rights and operations, and is the basic knowledge of MySQL beginner learning, and
One, other data operations (advanced operations)
worm Replication (insert into table name (field list) Select *| Field List from table name)
primary KEY repeat:insert into table name (field list)values(Value list)on duplicate key update field 1
A. under/usr/locar/src/, download the source package to the directoryDownload Source package: wget http://mirrors.sohu.com////download MySQL source package under this URLInitialization1. Decompression: Tar-xvzf mysql-5.1.73-linux-i686-glibc23.tar.gz2
Engine INNODB Storage OptimizeWhen MySQL tables grow to a stable period or grow 10 or 100Mb in a row, you can use the Optimize table statement to refactor MySQL tables, increase the availability of MySQL tables, and reduce the storage fragmentation
Modify the Mysql root Password
1. Start the command line and enter taskkill/f/im mysqld.exe // close mysql
Ii. Transfer to the bin directory of mysql
Iii. Input: mysqld -- skip-grant-tables // skip password detection
4. Do not close the
MySQL5.6 master-slave replication (mysql Data Synchronization configuration), mysql5.6mysql
Planning
Master 192.168.56.2
Slave 192.168.56.5
1. On the master database, set a REPLICATION account rep1 and grant the replication slave
Install the basic configuration of mysql
1. Add Environment VariablesRight-click the computer and choose Properties> advanced system Settings> environment variables. Find Path in the system variables and double-click. Click Edit to add the path of
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