Tag：dba
-
Learn to use kingbasees database (PostgreSQL version) on Linux
Learn to use kingbasees database (PostgreSQL version) on Linux Article catalogue Learn to use kingbasees database (PostgreSQL version) on Linux preface environment I. Introduction to kingbasees database 1 role Database administrator (system) Security administrator (SSO) Audit administrator (SAO) Common commands 1. Start database service Start the database using the Kingbase command Using sys_ ctl systemctl […]
-
MySQL queries logs slowly, leaving “slow” nowhere to hide
Author: it bond Member of China DBA Alliance (acdu), currently engaged in DBA and program programming (Web \ Java \ Python) work, mainly serving production and manufacturing Oracle 11g OCP / OCM Mysql, oceanbase (obca) certification Distributed tbase \ tdsql database, domestic Dameng database and red hat authentication He has worked in DBA for 8 […]
-
How to check the duplicate of SQL once, remove the duplicate and keep a small record
📢📢📢📣📣📣Hello! Hello, I’m [it bond], known as jeames007 in Jianghu, with 10 years of DBA working experienceA highly motivated [big data blogger]!Member of China DBA Alliance (acdu), currently engaged in DBA and program programmingGood at mainstream data Oracle, mysql, PG operation and maintenance development, backup and recovery, installation and migration, performance optimization, fault emergency treatment, […]
-
Database transaction and isolation level MySQL
Transaction overview A transaction is an execution unit composed of one or a group of SQL statementsOr all of them are executed successfully，Or all execution fails。 Used to ensure data integrity. For example, in account transfer, Zhang San transfers 500 to Li Si, and the corresponding SQL statement should be update Zhang San’s balance – […]
-
Wow, MySQL download, silent installation, cross version upgrade and uninstall, keep familiar~
📢📢📢📣📣📣Hello! Hello, I’m [it bond], known as jeames007 in Jianghu, with 10 years of DBA working experienceA highly motivated [big data blogger]!Member of China DBA Alliance (acdu), currently engaged in DBA and program programmingGood at mainstream data Oracle, mysql, PG operation and maintenance development, backup and recovery, installation and migration, performance optimization, fault emergency treatment, […]
-
SQL optimization dry goods Summary – MySQL (2020 latest version)
Do you want to accurately find the MySQL articles you want to read? Here →MySQL column directory | click here preface The interview of batjtmd and other large factories is becoming more and more difficult, but no matter from large factories or small companies, one of the key points that has not changed is the […]
-
Unity connection to MySQL database – latest details
Article catalogue Write in front Mysql MySQL Installer for Windows Connector/NET MySQL for Visual Studio Visual Studio unity MySql.Data.dll Test script test result Write in front The version compatibility problem has taken many detours, which makes people very angry. Software updates, but the supporting facilities and support often do not keep up with, or even […]
-
[congratulations on the Spring Festival and the power of the tiger] SQL “blessing” is here
Introduction to the blogger: It bond, known as jeames007 in Jianghu, has 10 years of DBA working experience Member of China DBA Alliance (acdu), currently engaged in DBA and program programming Article catalogue preface 1. New year SQL “blessing” 1.1 build test database 1.2 establishment t_ Fu data table insert data 1.3 select query 2. […]
-
In MySQL development, is the choice of storage engine really important?
preface Who said that MySQL query ten million levels of data is very cross? I’m going to have a good chat with you tonight and spend New Year’s Eve together! This article is also the last one years ago. I hope it can bring you some harvest. I was surprised to find so many documents […]
-
The two cores of MySQL implementation plan explain
Introduction to the blogger: It bond, known as jeames007 in Jianghu, has 10 years of DBA working experience Member of China DBA Alliance (acdu), currently engaged in DBA and program programming (Web \ Java \ Python) work, mainly serving production and manufacturing Oracle 11g OCP / OCM Mysql, oceanbase (obca) certification Distributed tbase \ tdsql […]
-
Master MySQL stored procedures quickly, roommate
Introduction to the blogger: It bond, known as jeames007 in Jianghu, has 10 years of DBA working experience Member of China DBA Alliance (acdu), currently engaged in DBA and program programming (Web \ Java \ Python) work, mainly serving production and manufacturing Oracle 11g OCP / OCM Mysql, oceanbase (obca) certification Distributed tbase \ tdsql […]
-
After working for so many years, I still don’t know how to conduct performance pressure test on MySQL? That’s too low
Hello, I’m glacier~~ Today, I’ll bring you a technical article on MySQL, which is also my performance test of MySQL using UUID as primary key and int number as primary key. Before, some friends always asked me: why do you use UUID as the primary key of MySQL? MySQL performance is relatively low. Previously, I […]