In MySQL, innobackupex and xtrabackup are used for big data backup and restoration. innobackupex
Backup and restoration of large data volumes is always a challenge. When MYSQL exceeds 10 Gb, it is slow to export data using mysqldump. Xtrabackup is
InstallThis section describes the most common problems during installation. PHP is applicable to almost any OS (except for MacOS before OSX) and almost any WEB server.To install PHP, follow the instructions on the installation file in the release
SQLSERVERDBCC command DBCCDROPCLEANBUFFERS: deletes all caches from the buffer pool. When the buffer pool is being tested, this command can be used to clear all test data from the SQLSERVER data cache datacache (buffer, to ensure the fairness of the
Error ECHO, which is commonly used in development mode. However, many applications forget to disable this option in the formal environment. Error ECHO can expose a large amount of sensitive information to facilitate the next attack. It is
Detailed description of Mysqlmy. ini configuration file
Mysql my. ini configuration file details
Mysql my. ini configuration file details
# BEGIN CONFIG INFO
# DESCR: 4 gb ram, only InnoDB, ACID, a small number of connections, large queue Load
#
MySQL logs are the most common MySQL Log types. If you are interested in MySQL logs, take a look.
1. The error log records the problems that occur when you start, run, or stop mysqld.My. ini configuration information:# Enter a name for the error log
Mysql-related log Summary
As an important means of querying problems, log should be recorded as much as possible for you to query some problems.
MySQL has the following types of logs:Error log:-log-err
Query log:-log
Slow query log:-log-slow-queries
As we all know, mysql has slowquerylog. based on slow query logs, we can know that SQL statements have performance problems. As a good partner of mysql, php also has this function. If you use php-fpm to manage php, you can enable it using the
1.Copy the Nginx installation package to the/opt/nginx directory, modify the permissions, unzip, and compile the installation. Root@iz25n0utdnmz:/opt/nginx# chmod 777 nginx-1.9.3.tar.gzRoot@iz25n0utdnmz:/opt/nginx# ls-lTotal848-rwxrwxrwx1Root root864
This is a creation in
Article, where the information may have evolved or changed.
I've been using SS recently, but Python's concurrency isn't very good, so I switched to Golang's SS.Code download
Compiled direct download
Server configuration (not
The error reporting function of PHP will help you identify and locate errors. These detailed descriptions provided by PHP may also be seen by malicious attackers. Make the public unable to see the error message...
Error Report
No developer will
Linux php5.4 startup script and linuxphp5.4 script. Linux php5.4 startup script, linuxphp5.4 script nonsense not much said, directly on step 1, modify the php-fpm.conf configuration file to modify the usrlocalphpetcphp-fpm.conf (of course, this
: This article mainly introduces php error information configuration. if you are interested in the PHP Tutorial, refer to it. Error Echo, which is commonly used in development mode. However, many applications forget to disable this option in the
: This article describes how to parse the Nginx configuration file. if you are interested in the PHP Tutorial, refer to it. After Nginx is installed, a corresponding installation directory is generated. according to the preceding installation path,
Check whether logs are enabled for bitsCN.com in mysql logs.
Mysql> show variables like 'log _ bin ';
How to know the current log
Mysql> show master status;
Use mysqlbinlog to view binary log files
Shell> mysqlbinlog mail-bin.000001 (to write
: This article describes how to set up the LNMP environment-Nginx. For more information about PHP tutorials, see.
1. Nginx configuration file test
root@kallen:/usr/local/nginx/sbin# nginx -t nginx: the configuration file /etc/nginx/nginx.conf
: This article describes how to compile and install nginx in ubuntu. if you are interested in the PHP Tutorial, refer to it. Update Source: apt-get update
Upgrade Software: apt-get upgrade
Update system: apt-get dist-upgrade
Apt-get install
Introduction to php-fpm configuration
This article introduces the configuration method of php-fpm in the php environment, and describes the configuration options and methods of php-fpm in detail. if you need them, refer to them.This section
X-Cart study notes (1) understand and install X-Cart. Directory X-Cart study notes (1) understanding and installing X-CartX-Cart study notes (2) X-Cart framework 1X-Cart study notes (3) x-Cart framework 2X-Cart study notes (4) common operations
We recommend that you have friends on the server to test the optimization settings for mysql.
We recommend that you have friends on the server to test the optimization settings for mysql.
If MySQL 5.0.x is usedYou can directly save the following
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.