MySQL

TransactionA transaction consists of one or more SQL statements, and if all statements execute successfully then the modification will take effect, such as a SQL statement will sell +1, the next +1, and if the second fails, then sales will undo the +

MySQL mysqlslap pressure test2016-09-12 17:49 by Pursuer.chen, 771 reading, 0 reviews, Favorites, compilation IntroducedThe Mysqlslap is a performance-measuring tool that comes with MySQL, and the mysqlslap is designed to be used as a test tool for

Data type (column type) numeric type Numeric data are numeric The system divides the numeric type into integers and decimal types Integer type Because SQL needs to consider how to save disk space, because the system will

Java using MYSQL-JDBC connection MySQL appears as follows warning: Establishing SSL connection without server ' s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL

Mysql Series Articles Home===============Tips: Before reading this article, it is best to read this article (MySQL lock mechanism-line lock) articles ~In the previous article, we saw that the InnoDB default row lock makes it possible to operate on

1. Summary of date and time types in Java and MySQL: 1234567891011121314151617 mysql（版本：5.1.50）的时间日期类型如下：datetime 8bytes xxxx-xx-xx xx:xx:xx 1000-01-0100:00:00到9999-12-3123:59:59timestamp 4bytes xxxx-xx-xx xx:xx:xx 1970-01-0100:00:01

how MySQL optimizesrationalization of the design of the table (3NF compliant)add an appropriate index (index) [Four kinds: normal index, primary key index, unique index unique, full-text index]SQL statement optimizationSub-table technology

First, prefaceYes, that's right, I've had water for a while, deep reflections on sending a few. During the previous period, the work item was asked to provide a capability to roll back data based on the operations batch, due to problems that could

When we gain control of a server, we tend to look for sensitive files such as password files, database configuration files, and so on. If the database is a MySQL server, then we can use the search command to search for user. myd files, Linux can use

MySQL optimization in three directions ① optimize MySQL Server Core (this optimization is usually done by operations personnel). ② tuning MySQL configuration parameters (my.cnf) This optimization requires a stress test to adjust the parameters. ③ to

A brief analysis of "MySQL" and "Proxysql" mysql_users table 1. Table definition and the DDL definition of the field description table:CREATE TABLE mysql_users (username varchar not NULL, #用户名 password varchar, #密码 active INT CHECK (AC tive in (0,1))

Python3 connecting MySQLThis article describes the basic use of the third-party library--pymysql that Python3 connects to MySQL.Pymysql IntroductionPymysql is a library used in the python3.x version to connect to the MySQL server, and MySQLdb is

MySQL user management create user and authorize Specify the logon IPCreate an authorized new user with the root user login:Mysql> Grant all in . to ' user1 ' @ ' 127.0.0.1 ' identified by ' 123456 ';All operations (additions, deletions and

MySQL synchronization and delay synchronizationMySQL SyncOperation on a MySQL master server1 Turn on the Log_bin feature on the server# VIM/ETC/MY.CNFAdd two linesLog_bin=mysql-binServer_id=12 restarting MySQL# service Mysqldrestart3 log in to MySQL

The following table lists the most important built-in date functions in MySQL: function Description Now () Returns the current date and time Curdate () Returns the current date

Seventh article: Python3 connection MySQL Connection database considerationsBe aware of the following before you proceed with this article: You have a MySQL database and have started. You have a user name and password that you can

Unit tests support test Automation , shared installers, and shutdown Code testing , PolymerizationYesCollection，TestAndReportFrameworkFromTest independence unit test module provide can very easy to Support these quality a test

This configuration scheme from CSDN predecessor blog, but can not find the source, Embrace!!!1. mysql Synchronization mechanism overviewMySQL supports one-way, asynchronous replication, one server acting as the primary server during replication, one

Mysql InnoDB Exclusive LockUsage: Select ... for update;For example: SELECT * from goods where id = 1 for update;Exclusive lock Application Prerequisites: No thread uses an exclusive or shared lock on any row data in the result set, or the request

MySQL common error codes and code descriptions1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed1008: Database does not exist, delete database failed1009: Unable to delete database file