MySQL

Recently, because of the need to study the MySQL random extraction implementation method. For example, to randomly extract a record from the TableName table, the general wording would be: SELECT * from TableName ORDER by RAND () LIMIT 1. But then

Here we will describe the MySQL memory usage on the thread exclusive, thread exclusive memory is mainly used for each client connection thread to store the exclusive data of various operations, such as thread stack information, packet sorting

How to use Sitescope11 Monitoring MySQL database, and in LoadRunner view in chart form MySQL Monitoring Results 1. Download Sitescope11 2. Installing SITESCOPE11 Can be installed all the way by default, the license file selection can be empty first,

Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a table lock). Xtrabackup supports all

8.10 Mysql Master-Slave synchronization8.10.1 Master-Slave principleThe principle of MySQL master-slave synchronization:1. Turn on the Bin-log log on master to record some records of changes deleted on master.2, the master and slave each open IO

Preparation before the experiment:1. EnvironmentPort 3306 The instance is a production environment, to retrieve the root password of 3306Use when testing 3307 tests2. Open 3306,3307 mysqld Service[Email protected] ~]#

There was an error when restarting mariadb under CentOS 7, Warning: Unit file of mysql.service changed on disk, ‘systemctl daemon-reload‘ recommended. as prompted,Workaround:systemctl daemon-reload正常重启MariaDBsystemctl restart mysqlCan. Other

1.1 Get the current date + time (date + times) function: Now ()In addition to the now () function to get the current datetime, MySQL has the following function:Current_timestamp () Current_timestampLocalTime () localtimeLocaltimestamp ()

Learn to Tarena gold medal lecturer Heshan, Golden Dawn technology company technical Director Chalimoux Course notes synthesis.1. What are stored procedures and functionsPut SQL statements in a collection, and then call stored procedures and

We all know that MySQL database partitioning (Partition) can improve the performance of MySQL database, so what is the MySQL database partition? And what are the benefits of its practical application? The following article is a description of the

Overview for databases such as MySQL and Infobright, the tables in the INFORMATION_SCHEMA database are read-only and cannot be updated, deleted, inserted, or triggered because they are actually just a view, not a base table, and have no associated

MySQL InnoDB in the transaction log Ib_logfileThe transaction log or the redo log, in MySQL by default in the Ib_logfile0,ib_logfile1 name exists, you can manually modify the parameters, adjustOpen a few sets of logs to serve the current MySQL

MySQL as the golden Partner of PHP and the most widely used database on the Internet, inevitably deal with it every day, many friends in the familiar with the use of Swoole, also a lot of pits, ready to combat, and finally on-line, is a pleasant

Since the Zabbix comes with a MySQL monitoring template that monitors things less, you should use Percona Zabbix mysql-plugin to monitor MySQL as required by your company's DBA.Percona Zabbix Mysql-plugin is a tool released by Percona that uses

If we are new to start learning and use the Linux vps/server to build the site and project environment, if due to time and effort Limited, we can choose one-click Package or Web panel easy to get started. If we want to optimize the system later, and

Normal start, will be reported "an error occurred during the initialization of the runtime system. Please make sure the Java Runtime Environment (JRE) 5.0 Update 8 or newer instralled. Error. And the local is definitely installed Java. I found a lot

I. Introduction I have been using Linux for a long time. I have never studied Linux since I have no hard tasks or systems. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in windows and thought it

MySQL workbench can be used to manage MySQL or mongoerd. This article mainly describes how to install MySQL. Using Deb security and solving the dependency of the quick security method: Using dpkg security to Deb environment, and using aptitude to

Brief Description Character Set and verification rulesCharacter Set is a set of symbols and encoding. A collation is a set of rules used to compare characters in a character set.MySql provides strong support in collation, and mongoel does not find

A stored procedure is a program stored in a database (just like a subroutine in a regular language). To be precise, MySql supports two types of "routine (routine: one is the stored procedure, and the other is the function that can return values in