MySQL

Business Party request Weekly send a weekly report out, the past week of the online project details sent out, our monitoring with Zabbix, the past has been manually filled, very time-consuming and very unprofessional, so I spent a few months to

First look at the MySQL version of Phpstudy:Method one uses the version function of MySQL:Version ();Method Two Status commandmysql> status;Method three directly under cmd Input command viewMySQL -vMySQL --helpStart upgrading the database below1.

Background: Mariadb,mycat middleware.Problem: The number of DB connections is too large; development uses the connection pool to connect the Mycat;DB to optimize: Interactive_timeout,wait_timeout are 8-hour default values.Mycat Configuration: 100

Ubuntu16 Install mysql5.7 not prompt for password, after installation, modify the MySQL password default passwordMySQL default password is emptyBut when you use the MYSQL-UROOT-P command to connect to MySQL, an errorERROR 1045 (28000): Access denied

Recently found a very useful MySQL slow query log visualization tools, online can also find a lot of information, here combined with their own actual situation to reorganize.1. Experimental environment 1.1 system environment:操作系统：CentOS 6.5 64位主机地址：1

1.MYSQL-MMM OverviewMMM (Master-master Replication Manager for MySQL) is a set of scripting programs that support dual-master failover and dual-master daily management. MMM is developed using the Perl language, which is mainly used to monitor and

Purpose of the backup　　Data loss scenarios such as disaster recovery, hardware failure, software failure, natural disaster, hacker attacks, misoperation testing, etc.Backup Note points　Can tolerate the maximum amount of data lostHow long does it

A. MySQL stored procedure1. Concept: SQL statement with logic, there is no condition in the previous SQL statement, no loop, the stored procedure with the Process Control statements.2. Features:(1) Execution efficiency is very fast, the stored

Concrete example 22, MySQL alter commandWe need to use the MySQL alter command when we need to modify the data table names or modify the field of the data tables.1. If you need to modify the name of the data table, you can use the RENAME clause in

1, Problem Description:When executing the following script in SQLyog:CREATE DATABASE IF not EXISTS Sys; Use Sys; CREATE USER by ' ROOT1 ' ; GRANT All on sys. * to Root1;However, create a new connection times wrong:Command Line window

Why do I need a MySQL cluster?In the performance bottleneck of a large distributed system, the most vulnerable is the connection. There are two connections, one is the client connection to the backend, and the other is the back-end connection to the

After starting MySQL, a few seconds after the direct errorThen a few error messages are found in the Event ViewerCan ' t start server:bind on TCP/IP port:no such file or directoryDo you already has another MYSQLD server running on

--mysql connection Issue "How to troubleshoot MySQL connection timeout shutdown"------------------------------------------------ReprintRecently do the site has a station to use the Web page grabber function, when a PHP script in the request URL, the

1. Introduction to the EnvironmentOperating system: HP-UX b.11.31 IA64Installation media: mysql-5.1.48-hpux11.31-ia64-64bit.depot.gz2. Installation process(1) Create MySQL user, user group-G mysql-d/home/passwd MySQL(2) Unpacking the installation

Causes of garbled characters MySQL character encoding is introduced in version 4.1 and supports multiple languages. In addition, some features have exceeded those of other database systems. Run the following command under MySQL command line

[User @ localhost] $ ls mysql-5.1.51.tar.gz Mysql-5.1.51.tar.gz [User @ localhost] $ su Password: # Cp mysql-5.1.51.tar.gz/usr/local/src/ [Root @ localhost] # cd/usr/local/src/ [Root @ localhost SRC] # groupadd-r MySQL [Root @ localhost SRC] #

Conversion from MySQL code Note: decimal. c Bytes ------------------------------------------------------------------------------------------------------------ *Convert decimal to its binary fixed-length RepresentationTwo representations of the same

Phpmyadmin logon error crypt_random_string requires at least one encrypted Ric cipher be loaded solution, The following error is prompted during phpmyadmin Logon: Phpmyadmin crypt_random_string requires at least one cipher Ric cipher be loaded Cause

Basic MySQL Data Table operation 2: Table Structure View, modification, and table operation 1. view the data table structure 1) view the basic table structure statement DESCRIBE Syntax:DESCRIBETable Name; Example: mysql> DESCRIBE product;+-----------

MySQL partition Table partition online modify partition field company online use partition, there is a table partition field error, need to be rebuilt, it turns out that there is no way to directly execute an SQL statement like modifying the primary