The master-slave synchronization of the MySQL database has been performed for one year, and some errors are encountered during this period. You can find and solve the problem by yourself. 1. If: Slave_IO_RunningNO, Slave_ SQL
The master-slave
(Monty gave a speech at OReillyOpenSourceConvention2000.) [compile and organize Yan Zi] I. what can and should we optimize? Hardware operating system software database SQL Server (setup and query) application programming interface (API) Application -
In general, to make a slow select... where faster, you should first check whether an index can be added. References between different tables are usually completed through indexes. You can use the explain statement to determine which indexes the
Today, because the server is automatically shut down, the error "fail1Table" appears when I open the website again. \ xxx "is marked as crashed and shoshould be retried red. After analysis, I found two ways to solve this problem on the Internet, for
1. How to create a management user for the mysqld database?
After the database is installed, we should create a management account for the mysql database. To set the root user as the administrator, we should run the following command;
[Root @
The MySQL DATA table is broken. The following exceptions are mentioned when applications connect to the database:
1 java. SQL. sqlexception: Can't open file: 'kq _ atttemp. myi'. (errno: 145)
2 at com. MySQL. JDBC. mysqlio. checkerrorpacket
SQL Study Notes (19) ----------- about MySQL database optimization and mysql database Optimization
A mature database architecture is not designed with high availability, high scaling, and other features at the beginning. It is gradually improved
**************************************** ******************
The first part is to build a multi-mysql service on a server.
**************************************** ******************
I. xuyan
There is a mysqld_multi command in Mysql that can be used
Next let's answer some questions:
◆ Does your database have a foreign key?◆ Do you need transaction support?◆ Do you need full-text indexing?◆ What query mode do you often use?◆ How big is your data?
Thinking about the above questions can help you
PHP Technology Group 170855791MySQL5.5 later uses the InnoDB storage engine by default, where InnoDB and BDB provide transaction-safe tables, and other storage engines are non-transactional security tables.To modify the default engine, you can
Introduction of Mysqlcheck
The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables.
Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD
MyISAM Storage Engine
MyISAM is the default storage engine. It's based on older ISAM code, but there are a lot of useful extensions. Some features of the MyISAM storage engine:
· All data values store the low byte first. This separates the data
Each MyISAM index file (. MYI) has a counter at the head that can be used to check whether a table is properly closed. If you get the following warning from check table or MYISAMCHK, this counter is already out of sync:
clients are using or haven't
mysql| optimization
7.2.2 Estimating Query performance
In most cases, you can estimate the performance of a query by counting the number of disk searches. For small tables, it is usually only necessary to search the disk once to find the
Transferred from: http://lizhenliang.blog.51cto.com/7876557/1657465 A mature database architecture is not designed to be high availability, high scalability and other features, it is with the increase in user volume, the infrastructure is gradually
1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not
The difference and choice between MyISAM and InnoDB, detailed summary, performance comparisonJune 25, 2015 21:58:42 read: 1827 more personal Category: MySQL1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an
The site suddenly appears with the following error:MySQL Error: Duplicate entry ' 1 ' for key ' views 'MySQL Errno: 1062Message: Duplicate entry ' 1 ' for key ' views 'I useMyisamchk Cdb_posts.myi-rFixed the table, but the contents of the table
To find the storage engine for a database:Show enginesShow variables like '%storage_engine% 'Change the engine of the database to change the configuration file/etc/my.cnfModify Default-storage-engine=innodb (the storage engine that needs to be
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.