have been used to the MySQL installation file (. exe), download a. zip version of MySQL today, the installation process encountered some problems, as follows:1. Download the install-free zip file on the MySQL website
Directory
MySQL Master-slave replication
Copy Filter
Replication and Monitoring
Read and write separation of master-slave replication
Backup and Recovery
Table partitioning
First, MySQL master-slave
MySQL master-slave replication principle1. First master records data updates to a binary Binlog file2.slave requests the Binlog log file to the master via the I/O thread to specify the content after the location3.master receives slave IO request, it
Epmmm Performance Monitor for MySQL and mariadb on Zabbix 2.x and Zabbix 3.xLinkHttps://github.com/earl86/epmmmThe wrapper for Zabbix python script.It runs the script every seconds. and parses the cache file on each following run.Test the script
MySQL Performance optimization purposeHow to design the database rationally?What database design can provide the cornerstone for post-DBA optimization?The difference between database design and program design?Early optimization of database design1.
Importance of Backup:
In the production environment, our database may encounter a variety of accidents resulting in data loss, probably divided into the following several.
Hardware failure
Software failure
Natural disasters
First look at the fields of the world table:
name
Continent
Area
population
GDP
Capital
TLD
Flag
SELECT * from the world;2. Displays the name of the country/region with a population of
MySQL has many Database Import methods. However, these are only half of the data transferred from the database, and the other half are the data exported from the database. Because, in many cases, we need to export data for necessary backup. The cost
I encountered this problem today,
Rs. getstring (4) is of the datetime type and is the default value.
Error:Cannot convert value '2017-00-00 00:00:00 'from Column 9 to timestamp.
Then I searched for the solution on the Internet as follows:
MySQL 4 database, if you want to migrate to MySQL 4.1, there will be Chinese Encoding Problems, relatedArticleIntroduction tooA little more, a lot of Google, the key is that MySQL 4.1 began to support multi-encoding. Today, I tried migration and
Original address: http://www.phpwind.net/simple/index.php? T255122.html & t = 1
MySQL errors and solutions (continuously improving)
Note: If a database error occurs, modify the corresponding code and restart MySQL. If you encounter a MySQL problem,
MySQL modifies the encoding and character set to enter the database installation directory: C:/program files/MySQL Server 5.0. find the INI file at www.2cto.com client section # -------------------------------------------------------------------- #
Software Download: Click here to download
Installation instructions: the mysql version is V5.0.
-------------------------------------------------
The installation process is as follows:
Step 1
First, you can see that this is the installation
Enable the slow query record function. Next, let's analyze the content of the slow query:
Select count (distinct. name) from cp_paycard as a left join cp_reservation as B on. uid = B. UID where. type = 2 and B. cpparkid = '000000' and B.
My system is ubuntu8.04. The newly installed MySQL always has an error prompt when it enters the MySQL tool:
# Mysql-uroot-PEnter password:Error 1045 (28000): Access denied for user 'root' @ 'localhost'(Using password: No)
Use the methods described
When using MySQL, you need to use the ODBC data source to connect to MySQL. Therefore, you often need to use a driver without installation. Please refer to the script on the official website,
I modified a practical script and shared it with you:
The error in calculating the sum function of MySQL 4.0.18 for NT is found.Mysql> Create Table CH3 (ID char (32), V decimal (18, 2 ));Query OK, 0 rows affected (0.12 Sec)
Mysql> insert into CH3 select * From vc2;Query OK, 8192 rows affected (1.24 Sec)
Q: How to install lamp (Linux + Apache + MySQL + PHP)A: [url] http://www.freelamp.com/1003235699/index_html#/url]
Q: How to install MySQL using rpmA: First download the appropriate RPM package, such as downloading the file MySQL-5.0.15-0.i386.rpmUse
Hello everyone, the MAKEFILE file below is hand-written and has been used very well and there is no problem.Name = gameserLink = g ++Cc = gccCcflags + =-GCcflags + =-wallCcflags + =-I/usr/include/MySQLCcflags + =-ddebug# Ccflags + =-mLinkopts +
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