MySQL

Show Processlist and show full processlistThe output of the Processlist command shows which threads are running, not only the current number of connections, but also the current connection status to help identify problematic query statements.If it

1. BackgroundSqladvisor is an analytical SQL provided by the company's technical engineering Department's DBA team (Beijing) to develop and maintain a tool for index optimization recommendations. Based on the original ecological lexical analysis of

Second, design skillsprogramming habits vary from person to person, here only to provide some experience, can be consulted. 1. Use include to modularize your program codeThe include function basically says, "It's like reading another file (HTML or

Key monitoring-mysql-nginx-php One, Zabbix monitoring MySQL is configured on the client: [[email protected] ~]# vim /usr/local/zabbix/ etc/chk_mysql.sh#!/bin/bash# ----------------------------------------------------------------------------

/*uploading data in bulk*/if(isset($_post[' Submit ']) &&$_post[' Submit ']== ' upload file '){ //Importing class files require_once(".. /classes/phpexcel.php "); require_once(".. /classes/phpexcel/iofactory.php "); //determine if the file is

I. MySQL master-slave synchronizationMySQL supports one-way, asynchronous replication, one server acting as the primary server during replication, and one or more other servers chargingWhen from the server. The primary server writes the update to

1. BackgroundMysql/innodb's locking analysis has been a difficult topic. In the course of my work, my colleagues have often consulted on this issue. At the same time, the micro-blog also often receive the MySQL lock-related private messages, let me

1. Introduction to the databaseWhat is a database? (https://www.cnblogs.com/alex3714/articles/5950372.html)A database is a warehouse that organizes, stores, and manages data according to its structure.Each database has one or more different APIs for

There is a project deployed to the server, the log is always prompted to find the table.Originally Linux under MySQL default to table name is case-sensitive.Workaround:One, the specification code, the table name all uppercaseSecond, modify the MySQL

First, the basic statement of the Operation databasecmd into MySQL: mysql-uroot-pCreating database: Create library name;Create data Table : with SQLite;View database : Show DATABASES;View Data Sheet : show TABLES;Enter database : use library

Write a tool class first, there is a way to implement MySQL database connection, and close the database connection, close the resultset result set, close the PreparedStatement method. The code is as follows:

Import the *.csv file to MySQL using the load DATA INFILE,Outline of the wording:Load data in FileSpecific syntax use can be referred to: Http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#load-dataIf only English characters are present in a

First, MySQL https://downloads.mysql.com/archives/installer/Say it in the front.Why have I tried and used many MySQL versions of the same type of product, and have to write this blog? Based on Mysql-installer-web-community-5.7.18.1.msiis because of

One, table-level lock1. Read lock,lock table t_student Read, add read lock, so that other Sessiona and sessionb can not modify the data, just read the data.Show processlist; View process, modify the state is waiting for the table level lock, has

Using Php+mysql+ajax+jquery to realize the three-level linkage function of the provincial urban areaRequirement: Write a three-level linkage between provinces and cities (or months and days) to achieve the drop-down selection of the region or

History of the simplest MySQL Data Backup and restoration tutorial (medium) (), mysql Data Backup Data backup and Restoration: Basic concepts: BackupSave the existing data or records in another copy; RestoreTo restore the data to the backup

The simplest MySQL Data Backup and restoration tutorial (I) (35) in history, mysql Data Backup The first article on data backup and restoration is as follows: Basic concepts: Backup, save the existing data or records in another copy; Restores the

Implementation Analysis of MySQL statement locking, mysql statement implementation Abstract: Analysis of Two SQL statement locks in MySQL Check the lock applied to the SQL statement under explain. SLQ1：select * from t1 where id = 10;SQL2：delete from

A Chinese garbled solution occurs when you operate mysql Databases in CMD. Baidu .. It is said that the chcp command is used to change the cmd character encoding to 65001 (utf8 character encoding). After that, Chinese characters cannot be entered,

MySQL Learning (4) -- foreign key, mysql learning foreign key 1. For example, there are two tables: "Classification Table" and "commodity table". To indicate the category of a commodity, we usually add a column to the commodity table, used to store