Safely delete binlog logs in MySQL, recover data using Binlog

When the database is in use, the default binlog is kept in one file (about 1.1G), resulting in a very large file, so you may need to delete some binlog log files when necessary: To delete a log file: Mode one: [Root@master-mysql data]# grep-e

Four foreign free PHP mysql super large capacity web space

100gb.co Free 100g/1000g/php/mysql/ftp/domain Space 100GB Free Shared Hosting:-100GB Disc Space-1000GB Bandwidth-Unlimited MySQL Databases-Unlimited FTP Accounts-Awesome Technical Support-Free Community Forums Application Address: http://www.100gb.

MySQL slow query log slow log queries analysis

One, slow query log configuration Turn on the slow query log to configure the sample: /etc/mysql/my.cnf[Mysqld]Log-slow-queries Add the above configuration entry in the MY.CNF configuration file and restart the MySQL service, when the MySQL slow

MySQL date query SQL statement summary (query one day, Query week, query one months of data)

My Date The first date format we get is this: 2009-2-12 or 2009-3-3 or 2009-10-12, we can do this by combining SQL statements: (three examples) The code is as follows Copy Code @1select * from user where birthday> ' 2009

PHP import Excel into the MySQL database, using Excelparser

Class Excelparser{Private $_data=array (0, "");Private $_excel_handle;Private $_excel=array ();/*** Constructor* @param $filename file Temporary file name*/Public function __construct ($filename){/*** Introduction of Excelparser Class* Common

MySQL performance optimization-optimize parameter configuration during installation to improve service performance

Optimizing parameter configuration During installation improves service performance Install MySQL under Linux the default configuration installed MySQL is not necessarily working in the best performance state, you need to optimize it. Generally

Mysql:no Curses/termcap Library found solution

The following error occurred while compiling MySQL: The code is as follows Copy Code Checking for tgetent in-ltermcap ... noChecking for termcap functions Library ... configure:error:No curses/termcap Library found

MySQL SQL alias usage and alias (alias) syntax

SELECT column_name (s) from table_name as Alias_name SELECT column_name as Alias_name from table_name Suppose we have two tables: "Persons" and "Product_orders" respectively. We assign them the alias "P" and "Po" respectively. Now, we want to

MySQL installation illustrated MySQL graphics installation tutorial (detailed description) _mysql

The MySQL5.0 version of the installation diagram tutorial is for beginners, and the current mysql5.0.96 is the latest stable version.MySQL Download address http://www.jb51.net/softs/2193.htmlThe following is the MySQL installation diagram, with the

The method of resetting the password after the Mysql password is forgotten under the Mac operating system _mysql

After installing MySQL, the system gives a default password and then says if you forget the default password ... I copied the default password and took one step, which was the beginning of my long journey. His password is too complicated, of course,

A detailed introduction of _php based on MySQL partitioning performance example

One, Zoning Concepts   partitions allow multiple portions of a single table to be allocated across the file system according to the specified rules. Different parts of the table are stored as separate tables in different places. MySQL has been

Replace Mysql character substitution function SQL statement sharing (regular judgment) _mysql

rar

Copy Code code as follows: Update dede_addonsoft SET dxylink=replace (Dxylink, '. zip ', '. rar ') where aid > 45553; Copy Code code as follows: Update ' table_name ' SET field = replace (field, '. rar ', '. 7z ');

CentOS to reset the Mysql root password tutorial _mysql

I installed million MySQL on the CentOS6.4, unable to enter through the root, because the installation, and did not set the root password, there seems to be an initial random password, but do not remember, too troublesome, directly reset the root

Four levels of isolation for MySQL

Class one or four isolation level The SQL standard defines 4 classes of isolation, including specific rules that define which changes are visible inside and outside the transaction and which are not. The low-level isolation level generally supports

MySQL manual has been quietly removed from the GPL license

What just caught our attention is that the MySQL manual has modified the license, which is a change from MySQL 5.5.30 to 5.5.31, which affects all pages in the man folder in the source pack. The move is a clear indication of the very unfriendly

MYSQLD security-related startup options in MySQL

The following mysqld options affect security: ·--allow-suspicious-udfs This option controls whether a user-defined function with only the XXX character can be loaded in the main function. By default, this option is turned off, and only UDF with at

How to choose the MySQL version to install

First, make a decision whether you want to use the latest development version or the final stable version. In the MySQL development process, there are several release series at the same time, each release at different stages of maturity: · MySQL 5.2

Compiling MySQL code in Windows environment

The purpose of this article is simply to tell friends how to compile MySQL code, and perhaps some people think that the code compiled from the Windows platform MySQL is somewhat complicated, but it is not. If you have any questions about the

Installing the MySQL Transaction database (InnoDB)

MySQL database is divided into two types, one is the traditional data table format, one is to support the transaction of the data table-type (INNODB,BDB, which is mainly based on InnoDB), I introduce the MySQL transaction processing database

Start/Stop/restart MySQL database under Ubuntu Server

System environment: ubuntu server 12.10x64 (mysql comes with the system)When we need to modify the MySQL configuration file my. cnf (my. ini in windows) for some settings, we need to restart MySQL after the modification.The path of my. cnf file

Total Pages: 3233 1 .... 170 171 172 173 174 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.