MySQL

For database operations, and TCP/IP three handshake similar to the wonderful, establish a connection, perform operations, disconnect. This, of course, requires the creation of a connected tool.Python connects MySQL with Oursql, Pymysql, Myconnpy,

I have been using seconds_behind_master to measure the master-slave delay, today I see the document, how unreliable! The following is a description of the official documentation:In essence, this field measures the time difference in seconds between

Title: A table:CREATE TABLE ' Tbl_time ' (' id ' int (ten) unsigned not NULL auto_increment,' Time ' char (TEN) not NULL DEFAULT ' ',PRIMARY KEY (' id ')) Engine=innodb;Mysql> select * from Tbl_time;+----+------------+| ID | Time |+----+------------+

Environment: CentOS Release 6.7 (Final)Installation software: nginx+mysql+phpInstallation Tool: Yum1. Install Nginx, because the default Yum base source is not nginx, so this way to add Nginx official source to the local1) Address:

Problem:A system, MySQL database, after the data is large. MySQL CPU utilization is very high, a Test side access to the server when MySQL CPU utilization is 15%, 6 test end of the server when the MySQL CPU occupancy rate is 50%~60%.PS 1: Each Test

The previous article on the introduction of load Balancer LVS has explained the principle of lvs-dr, this article mainly introduces its implementation process in MySQL application:Test environment: 4 virtual machines are CENTOS6 operating systems,

MySQL database software is actually green and can continue to be used after reloading the system.1, reinstall the system to keep the original after the MySQL installation folder, Data folder.2. Make a batch file to start MySQL: "Run.bat" files are

Brief introductionMySQL is one of the most popular free open source programs in history. It is the backbone of the database for thousands of websites and can be used as a testament to the exponential growth of the Internet over the past 10 years.So,

Table 12.14 Conversion Functions (cast function) name Description BINARY Converts a string to a binary string CAST() Convert a value to a specific type

Environment: CentOS6.6Rsyslog+mysql+loganalyzer Environment Build Log serverClient End: 192.168.2.10MySQL Server: 192.168.2.11# Client -side installation of prerequisite packagesYum Install Rsyslog-mysql-ygenerates a 2

1. SQL statements UsedMySQL -u root-p Enter password to connect to MySQL DatabaseSHOW DATABASES; View all databases in MySQLCreate DATABASES for creating a databaseDrop database for deleting databases Use database name

#!/usr/bin/phthonimport osimport timeimport commandsimport shutilimport threadingfrom os.path Import Join, Getsizeimport MySQLdb as mydb# backup directory basedir = "/data2/backup/backup_data/" # ns or WX; Whether to compress after backup (Mydumper

There are 3 ways to fix MySQL database:1. mysql Native SQL command: RepairExecute the Repair TABLE SQL statementSyntax: REPAIR TABLE tablename[,tablename1 ...] [Options]Example: mysql> use database xxx;mysql> Repair Table *;2. Using MySQL's own

Write in frontRecently started busy, the schedule is tight compared to rush, but also tomorrow to go to the driving school, can only a function of a function of the added, perhaps each completion of the function does not count what, and so will be

INSERT into on DUPLICATE KEY UPDATEAndREPLACE into, two commands can handle duplicate key-value problems, what difference does it make in practice?The precondition is that the table must have aunique index or primary key。Unique 1, replace found

#!/bin/sh#一键安装单实例mysql#xiaogao 20190921#创建相关mysql用户Groupadd MySQLUseradd-s/sbin/nologin-g mysql-m MySQLTail-1/etc/passwd#安装mysql依赖库Yum-y Install Ncurses-devel#开启安装mysql, remember to upload the installation package

The smallest administrative unit of the InnoDB is the pageInnoDB Minimum Application unit is the district, a district 1M, contains 64 pages, each page 16K, that is, 64*16k=1m, taking into account the hard disk locality, each read 4 extents, that is,

ODBC data Source configuration: needs to be configured on the server where the site is located, the ODBC driver version number 5.15 is recommended. (explained in Mysql-connector-odbc-3.51.20-win32.exe)An ODBC-based application operates on a database

Mysql Benchmark TestBenchmark testing is a stress test designed for the system.First, the main work of the benchmark test:1. Verify that some assumptions are based on the system and confirm that these assumptions are true (we do the main thing in

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's