pt-online-schema-change instructions, restrictions and comparisons

If you are reading this article, I believe you already know your needs. Before version 5.5 of mysql, modifying the table structure, such as adding indexes and modifying columns, required locking tables, which could not be written during the period, which was a disaster for large tables. From 5.5, especially 5.6, the situation has improved. On ...

Posted by jmcneese on Sat, 13 Jul 2019 21:57:10 +0200

Mysql 5.7.17 source code compilation and installation under Ubuntu 16.04

Mysql 5.7.17 source code compilation and installation under Ubuntu 16.04 System Environment ubuntu 16.04 64 bits Official documentation states: http://dev.mysql.com/doc/refman/5.7/en/source-installation.html I. System Installation Conditions 1.cmake MySQL uses cmake cross-platform tools to pre-compile source code to set the compila ...

Posted by nev25 on Sat, 13 Jul 2019 02:28:04 +0200

Python 3 Quick Start-Python 3 Database Operation

Python 3 Quick Start (11) - Python 3 Database Operation mysql-connector driver 1. Introduction to mysql-connector mysql-connector is the official drive provided by MySQL.Using pipenv for package management, the installation commands are as follows:pipenv install mysql-connector 2. Common interfaces of mysql-connector mysql.connector.connect(*a ...

Posted by mailtome on Fri, 12 Jul 2019 22:18:49 +0200

The Heart Course of Installing MySQL on CentOS 7

Today, there is a sudden whim to transfer the blog to your own cloud server. Well, it's a good idea, just able to practice. In order to do this, we must first have a database, linux with mysql. Ouch, that's good. Two words don't mention the installation method of yum [root@VM_235_40_centos ~]# yum install mysql Loaded plugins: fastestmirro ...

Posted by Joopy on Fri, 12 Jul 2019 22:09:26 +0200

3. Introduction to Database and Basic Use of listview

1 Database Creation under Android When do we use databases for data storage? When large amounts of data with the same structure need to be stored. MySQL SQL Server 2000 SQLite embedded lightweight SqliteOpenHelper Create a database step: 1. To create a class integration SqliteOpenHelper, you need to add a constructor to implement two method ...

Posted by eightonesix on Thu, 11 Jul 2019 19:51:04 +0200

Operations Note 40 Linux System Monitor Cacti (Cacti Build, Automated Grab Cacti Statistical Picture Script)

Overview: Monitoring system is very important in a system. It will display a lot of important information, such as memory information, cpu information and hard disk information. When the system has problems, we can locate and repair the errors in time. The monitoring system introduced today is a lightweight monitoring system, Cacti, with the c ...

Posted by Ads on Thu, 11 Jul 2019 19:33:06 +0200

mysql stored procedures and functions

Abstract: Stored procedures and functions are sets of SQL statements defined in the database, and then directly call these stored procedures and functions to execute the defined SQL statements. Stored procedures and functions can avoid developers repeating the same SQL statements. Moreover, stored procedures and functions are stored and execute ...

Posted by stephanie on Thu, 11 Jul 2019 01:28:00 +0200

TeamTalk Server-side Analysis of Server-side and Client-side Processes

Original: www.bluefoxah.org/teamtalk/server_flow.html Preface In the previous article, we simply analyzed the configuration of each server. In this article, we simply analyzed the whole operation process of TeamTalk server. Server-side process There is no strict sequential process for the start-up of the server, because each end ...

Posted by puja on Thu, 11 Jul 2019 00:32:13 +0200

Summary of MYSQL Source Code Installation in MYSQL Learning Paper 001-LINUX Environment

Summary of MYSQL Source Code Installation in MYSQL Learning Paper 001-LINUX Environment In the past, MSSQL, ORACLE and SYBASE databases were mainly used, and recently MYSQL was used by the company. Start learning by referring to the official document REFMAN-5.6-EN.A4.PDF. This paper is a summary of the recent installation process. To insta ...

Posted by jeethau on Wed, 10 Jul 2019 23:52:05 +0200

MYSQL Tuning 1 - Discover Slow Queries

Discover slow queries How to quickly locate and execute slow sentences from a large project is a problem to be solved in this chapter. 1. Definition of slow query What kind of query is slow query, is there a quantitative standard? Slow Query Definition Slow query refers to sql statements whose execution time exceeds that of slow query. Ways ...

Posted by Ricklord on Wed, 10 Jul 2019 23:44:09 +0200