MySQL

One or two binary compilation install MySQLCENTOS6, 7 are basically the same, but a few steps are also marked out, the steps are as follows: ① Download the installation package and import it into CentOS for decompression. 650) this.width=650; "src=

To stop the MARIADB service:systemctl stop mariadbsudo mysqld_safe --skip-grant-tables --skip-networking & Login directly with root, no password required:mysql -u root To reset your password:mysql> use mysql; mysql> update user set password=

The system version I am using is: sles12-sp2Using Python to connect to MySQL database requires installing the Mysql-python module;1. First install PIP:Download get-pipe.py from the official Python website and execute this script to install (or

I. Overview1, Version supportShow profiles is added after 5.0.37, to use this feature, make sure the version is after 5.0.37.To view the database version:Select version ();2. View turn on off and default settings observation count like ' profiling% '

Since importing Excel data with Dbeaver Import is unsuccessful, the following methods are used:1 Excel Save as CSV file--Open with Notepad--Save as TXT file, set encoding UTF8;2 MySQL new table Data_analyst3 Load Data local infile '

Data table for InnoDB engineThe frm file for the datasheet exists in the Data folder, but these tables are not visible in phpMyAdmin and are then restored by importing the SQL file1, directly import the original data table SQL file, the original frm

Database is the core of all application systems, so to ensure the stable, efficient and safe operation of the database is the most important work of all enterprises. Once a database system fails to provide services, it may cause the entire system to

One of the most incredible MySQL deadlock analysis Deadlock problem Background Do MySQL code in-depth analysis also some years, plus their own 10 years or so of database core research and development experience, since the mysql/innodb

Original: xtrabackup backup restore MySQL DatabaseMysqldump Backup In view of some of its own characteristics (lock table, essentially back up the insert script or text, does not support differential backup), is not suitable for high-real-time

ObjectiveIn the previous explanation of the database, in fact, a lot of things are very detailed, in the previous learning process I have not noticed. May be encountered in later work, so it is recorded.Next, I'll share the MySQL DDL used to

1. Build the installation directoryMkdir-p/ansible/roles/mysql/{defaults,files,handlers,meta,tasks,templates,vars} Defaults default search Path Tasks Store playbooks Path Files store file and script, copy module file search path

When we design the database table structure, we need to pay attention to the performance of the data operation when we operate the database, especially the SQL statements when we look at the table. Here, we're not going to talk too much about

Method One: (highest efficiency)SELECT * FROM Test as awhere Typeindex = (select Max (B.typeindex)From Test as Bwhere a.type = B.type);Method Two: (Second efficiency)SelectA.* from Test A,(select Type,max (typeindex) Typeindex from test Group by

Before one of the children's shoes hair:5 version of the mail, in the case of large user volume, if done distributed, if on the back end MySQL on the execution:mysql> show global status like ' thread% ';threads_cached 0Threads_connected

Today, after a database migration to a project, there was an error with field ' xxx ' doesn ' t having a default value, and this error was never seen before the migration. Later, after the inquiry manual and other information, found that the error

1. What is a transactionA transaction is a combination of one or more database operation statements with acid,4 characteristics.Atomicity: Either all succeeds or all is undoneIsolation: Transactions are independent from one another and are not

MySQL, the default is auto-commit, that is , autocommit = 1; But in this case, there are problems in some situations: for example:If you want to insert 1000 data at a time,MySQL will commit1000, If we turn off the autocommit [autocommit = 0],

MySQL _ date function summary and mysql function Summary If it is reprinted, please indicate the source of the blog: www.cnblogs.com/xinysu/. The copyright belongs to xiaoradish in the blog garden. Thank you for your support! For MySQL date and

MySQL large file import, MySQL File Import I usually use the Navicat for MySQL tool for import, but today I encountered a. SQL file that is too large to exceed 1 GB. When Navicat from MySQL was used for more than one hour, many errors were reported

Database BASICS (II)-Navicat applications, database navicat I. MySQL Data Type 1. numeric type SMALLINT: 2 bytes INT: 4 bytes // age int (10) INTEGER: synonym for INT BIGINT: 8 bytes FLOAT: 4 bytes DOUBLE: 8 bytes // score float (10, 2) 2. String