The advantage of MySQL using Binlog is the flexibility of data recovery
Binlog set incorrectly will make the disk full error, this situation occurs first of all, the database Binlog clean up
Previous deletion based on Binlog name
PURGE {MASTER |
MySQL Incremental backup
A small number of databases can have a full backup every day because it won't take much time, but when the database is large it is unlikely to make a full backup every day, and you can use incremental backups. The principle
1 installation. MySQL is installed in the/usr/local/mysql directory.
The code is as follows
Copy Code
Yum-y Install Perl PERL-DBIwget http://file.111cn.net/upload/2013/12/DBD-mysql-3.0002.tar.gzTar zxvf
MySQL enabled Skip-name-resolve mode when the warning approach, currently if your authorization is for all hosts you will not encounter the problem
When optimizing MySQL configuration, join skip-name-resolve, check boot log when restarting MySQL,
The actual line of the scene is more complex, then involved in the TRUNCATE, delete two operations, confirmed lost data almost 70,000 lines, and so on stop, almost a total of more than 10,000 rows of data written. Here for a simple explanation, just
1 case sensitivity of authorization table range columns+--------------+-----+-----+---------+----+-----------+------------+| Column | Host | User | Password | Db | table_name | column_name || Case Sensitivity | No | Yes | Yes | Yes | Yes | No |+-----
One, correct configuration file, clear cache
1. In the face of this problem, do not rush to reinstall the MySQL database, in fact, the solution is very simple, people need to clean up the Windows cache directory on it.2. Press "Windows key +r" to
So how do you solve the sorted output of the grouped data according to the DESC of the primary key?
There are two ways of answering:
1, the use of subqueries first sorted the table, and then the Word table for group by query, the resulting column
In Linux systems
Linux defaults to the UTF8 encoding, and Windows is GBK encoding, so there will be the above garbled problem.
Solve MySQL import and export data garbled problem
The first thing to do is to determine the encoding format of the
If you are using a database that suddenly appears to be a class problem
Under Linux to execute the following command on it, of course you have to find your MySQL directory
In Linux
The code is as follows
Copy Code
/usr/
Mysql+php Database Operations Class
Class Dbqueryformysql {/*** Maximum number of records returned by the Select method*/Const MAX_ROW_NUM = 1000;
/*** Data query result set object* @var Object $dataSet*/Public $dataSet = NULL;
/*** Data Source
MySQL Replace into instance tutorial
Replace into and insert into the difference, I and he said in the evening my blog look at that time is busy, now from the MySQL manual to find something, the MySQL manual said replace into said or more detailed.
1, install MySQL (Django install slightly):
[Root@itchenyi-1 django-1.3.3]# yum install mysql-server mysql-devel[Root@itchenyi-1 django-1.3.3]# Yum Install Mysql-python
2. Set up MySQL database and User:
[root@itchenyi-1 django-1.3.3]# Service
The website runs on the Ali Cloud, 1G memory, Php7+php-fpm+nginx+mariadb+redis all installs on a server, but the website visit Quantity Day also has 500IP, not many, but also caused a little pressure, just put up a few days database will often hang
The first step is to complete the distributed installation of HBase. The environment for this deployment is Hadoop-1.2.1 + hbase-0.98.X. Because this version of HBase is directly corresponding to the hadoop-1.2.1, it saves the steps to overwrite the
Execute the stored procedure$ Query = $ this-> db-> query ('Call YOU_SP_NAME ');$ Result = $ query-> result ();This is not a big problem, just like executing a common SQL statement.Problems encountered when using stored proceduresAfter the stored
If an error occurs in the article, I hope you will forgive me and point it out.To put it bluntly, for PHP, it supports MYSQL by default, that is, we do not have to manually set ODBC to use MYSQL. What we need to do is to introduce the MYSQL plug-in
4. Maximum sorting of query data (only one statement can be used for writing)Create table hard (qu char (11), co char (11), je numeric (3, 0 ))Insert into hard values ('A', '1', 3)Insert into hard values ('A', '2', 4)Insert into hard values ('A', '4'
InstallationPHP MySQL Linux has gradually become a classic combination of small web servers. Building and debugging MySQL databases in the indows environment is a preferred choice for many website developers. I am a beginner in MySQL in Windows 98.
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