PHP

Mysql backup script bitsCN.com The mysql backup script is very general. don't laugh when you see it .. #! /Usr/bin/perl-w Use warnings; Use strict; Use DBI; My $ backup_dir = "/root/perl/backup "; My $ backup_log = "$ backup_dir/backup_log "; My $

Datetime and timestamp bitsCN.com in mysql DATETIME: a combination of date and time. The supported range is '2017-01-01 00:00:00 'to '2017-12-31 23:59:59 '. MySQL displays DATETIME values in 'yyyy-MM-DD HH: MM: SS' format, but allows values to be

Further exploration of mysql backup and recovery bitsCN.com 1. my current backup solution is:A (master) -----> B (slave) for real-time synchronization, complete backup at every Sunday on B (slave), do from Monday to SaturdayIncremental Backup,

Key points of Mysql optimization when there is a large amount of data: bitsCN.com 1. optimize the query, avoid full table scanning as much as possible, and first consider creating an index on the columns involved in where and order. 2. try to avoid

Record mysql tuning bitsCN.com SymptomMysql CPU usage: 188% (multi-core)Solution1. slow queryVi/etc/my. cnf add the following content under mysqld: Log-slow-queries = slow. logLong_query_time = 5It means to record the SQL to slow. log for more than

Experience: the specific steps for modifying the default MySQL password bitsCN.com After MySQL is installed on windows, the system generates a license table and an account by default, you do not need to execute the mysql_install_db script on the

MYSQL variable bitsCN.com By NintyI only remember the basic knowledge, and the details are too troublesome and I cannot use them. Variables are divided into user variables and system variables. User variable: User variables are related to database

Count the number of working days between the current date and the end of the month. Count the number of working days between the current date and the end of the month. if you have a requirement on the operation side today, you need to find out the

Mysql knowledge point summary bitsCN.com I. Database Management: 1. view the database mysql> show databases; 2. create a database mysql> create database name; 3. use mysql> use database name; 4. delete database mysql> drop database name; 2. Data

Toomanyconnections solution for mysql1040 error bitsCN.com 1. it may be a problem with mysql's max connections settings.2. it may be multiple insert operations. the update operation does not close the session. you need to configure transaction

In order to establish a database with lower redundancy and reasonable structure, certain rules must be followed when designing the database. In relational databases, such a rule is called a paradigm. The paradigm is a summary that meets a certain

C # Do not delete bitsCN.com automatically when operating temporary tables in mysql Use c # to call the mysql stored procedure and use a temporary table in the stored procedure. each time the first call is correct, an error is returned when the

Mysql problem: usingexpire_logs_dayswithoutlog_bincrashestheserver... bitsCN.com Mysql problem: using expire_logs_days without log_bin crashes the server... problem: execute the mysql startup operation, that is,/etc/init. d/mysql start The

MySQL database cluster configuration Mysql Cluster BitsCN.com Turn: http://server.ccw.com.cn/yyjq/htm2010/20100624_870385.shtmlFavorites and backup.This article describes how to correctly configure the MySQL database cluster and its concept. if you

GitHubAvailabilityIssue summary GitHub BitsCN.com This week, the GitHub website experienced two major inaccessible incidents and several hours of service degradation. The GitHub O & M team specially published a Blog to summarize the entire event

CentOS 5.5 BitsCN.com There are a lot of Installation notes on the network, but they are not detailed, or the compilation environment is slightly different, the process will be different, so I summed up the existing experience and the experience of

Paging: retrieves paging data using SQL directly bitsCN.com On a list page, the programmer used the "Wuqi. Webdiyer" paging plug-in, which is slow and has an error. After reading the code, I thought there was too much redundancy, so I decided to

Do you really know how to log on to MySQL? BitsCN.com Yesterday, my colleague encountered a problem and created a user in MySQL. the host was set to %, so the user could not log on locally. After creating a user with the same name as localhost, you

Three batch-added performance analysis methods: bitsCN.com I recently studied hibernate in depth. During batch operations, I found that the performance of hibernate batch operations is very low. so I want to find a method with high performance.

How to set the maximum number of mysql connections: bitsCN.com After the MYSQL database is installed, the default maximum number of connections is 100. Generally, the number of connections to forums or websites with a higher traffic is far from