First, the preparation before installation
1, download the installation package, can be downloaded to the official MySQL website www.mysql.com, as shown in Figure 1-1:
Figure 1-1
The downloaded installation files are shown in Figure 1-2:
1. Download the RPM installation package, because the installation of MySQL, the software will need a dependency, so it is recommended to download all the installation packages, and then install the RPM package in turn.2. After installation under
Encountered such errors as: "Last_io_error:got fatal error 1236 from master when reading the data from binary log: ' Could ' is not find ' e name in binary log index file ' ", etc. or due to the clearing of data caused the master and slave library
This paper illustrates an optimization method of MySQL correlated subquery. Share to everyone for your reference, specific as follows:
Many times, the performance of subqueries implemented on MySQL is poor, which sounds a bit sad. In particular, in
Description
A MySQL database server on the line suddenly power off, causing system failure to start, reinstall the system, locate the MySQL database folder before.
Problem:
By copying files to the previous MySQL database recovery, found in the
There is a good period of time did not learn new things, after a October feeling things or the sooner do the better, nonsense not to say, to say that with MyBatis connection MySQL database, the previous write JDBC test, my database table or original.
After the default login to MySQL, you can view the system variables and their values through the show variables statement.
Mysql> Show variables like '%character% ';
Description: The following are the settings under CentOS-6.2 (different
Copy Code code as follows:
One
DECLARE @s varchar (20)
DECLARE @i varchar (20)
Set @i= '
Set @s= ' new member must purchase 350 Yuan product '
While PATINDEX ('%[0-9]% ', @s) >0
Begin
Set @i=@i+substring (@s,patindex ('%[0-9]%
Now use the two servers have been installed MySQL, are all rpm packaging, can be used normally.
In order to avoid unnecessary trouble, master server MySQL version as much as possible to maintain consistency;
Environment: 192.168.0.1 (Master)
192.168.
When using the mysqldump command backup,--all-databases can back up all the databases. You can also exclude established tables by using ignore-table. However, Mysqldump has no parameters to exclude the database.
When there are fewer databases to
ERROR 2019 (HY000): Can ' t initialize character set gb2312engaged in a very half-day, MySQL has been reloading two times, the number of tragedies ...Before the system code was set, it was all UTF-8.
vi/etc/sysconfig/i18n
This program can be used to browse the data in MySQL, you can do a little modification can make a good MySQL browser.
*/
/*
? cmd=db
? cmd=table&db={}
? cmd=record&db={}&table={}
*/
$host = ' localhost ';
$user = ' Test ';
$password = ';
if
This article illustrates the solution to the problem of MySQL lock table. Share to everyone for your reference, specific as follows:
A lot of times! Just accidentally lock the watch! Here is the ultimate way to solve the lock table!
Case A
This article describes the MySQL based on DOS command line login operation method. Share to everyone for your reference, specific as follows:
The common MySQL command-line login statements are as follows:
Copy Code code as follows:
Mysql-h
First, download, here Use the green uncompressed version
Http://mirror.services.wisc.edu/mysql/Downloads/MySQL-5.1/mysql-noinstall-5.1.32-win32.zip
Second, the configuration of MySQL parameters
1, unzip the green version of the software to
MySQL's storage engine may be the most characteristic of all relational database products, not only to use multiple storage engines at the same time, but also the very loose coupling between each storage engine and MySQL using the plug-in approach.
In this paper, we analyze the solution to the failure of the MySQL database connection resource to be released in CI framework. Share to everyone for your reference, specific as follows:
Use the CI framework to provide class query data:
$this->
1. First confirm that your log is enabled
Mysql>show variables like ' log_bin ';
If enabled, that is, the log file is in the MySQL installation directory in the data directory
2. How to know the current log
Mysql> Show master
MySQL Query and use of the in, any, SOME, and all operatorsMySQL QueryAn in-line query is the result set returned by a subquery that is a column of N rows, usually from a field query returned to a table.An example of a column subquery is as follows:
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