MySQL

First, download the MySQL compression pack on Oracle's websiteDownload this tar package and upload it to the server via FTP, unzip it to the corresponding path by Xshell, check if the system has MARIADB installed, because it is the branch of MySQL,

1.1. detect if MySQL is already installedRpm-qa | grep MySQLIf it is already installed, uninstall it, such as:RPM-E--nodeps mysql-libs-5.1.71-1.el6.x86_641.2. installing MySQL1, Mkdir/usr/local/src/mysql2, Cd/usr/local/src/mysql3, TAR-XVF Mysql-5.6.2

I. OverviewThe Mysqlshow Client Lookup tool, which can quickly find out which databases exist, the tables in the database, the columns or indexes in the table, are similar to the MySQL client tools, but some features are not available in MySQL

Isolation properties of InnoDB InnoDB's transaction supports 4 isolation mechanisms, namely READ UNCOMMITTED, read COMMITTED, Repeatable read, and SERIALIZABLE. The default is repeatable READ. The following is a detailed analysis of the 4 types of

(i) about the storage engineCreating an appropriate index is one of the most important techniques in SQL performance tuning. Before learning to create an index, learn about MySQL's architectural details, including how it is organized on the hard

Http://www.hellodb.net/2011/07/mysql-linux-hardware-tuning.html Recently, we have sorted out some experience on optimizing percona, Linux, flashcache, and hardware devices: Hardware 1. Enable bbwc Raid cards all have battery backed write cache,

1. Notes on backupIn MySQL 5, if you want to back up data, you must first set the log as follows in my. ini.[Mysqld] # The TCP/IP Port the MySQL server will listen onPort = 3306Log-bin = "E:/mysql5/log/bin. log"Log-error = "E:/mysql5/log/error.

Sometimes we use the PHP framework and the ready-made ORM to save the trouble of writing SQL, but we want to see which sqls have been generated. Or we have downloaded WordPress or druapl, I want to see how my SQL is written. If I can monitor every

Partitioned table created Create Table 'employees '('Id' int (11) not null,'Fname' varchar (30) default null,'Lname' varchar (30) default null,'Hired' date not null default '2017-01-01 ','Separated 'date not null default '2017-12-31 ','Job _ Code'

(1) Writing You can use Notepad, ultraeidt, phped, and so on ...... Simple text editing software is available. (2) Running You need web server IIS or Apache, and then install a PHP on the line, http://www.php.net/to download. Installation:

-- MySQL stored procedure/* Set @ result = 0; Create procedure login (-- defines parameters, including in, out, And inout types in user varchar (10 ), in pass varchar (10), out result INT) Begin declare passd varchar (10); -- declare declares

You can back up Mysql Data in either of the following ways:1) copy files. This is of course the simplest. Copy the folder of the corresponding database and then copy the file ibdata1.2) mysqldump Of course, the 2nd methods are better. For example,

There is a need for a recent project to use views and stored procedures in ror Development Because we want to use the view, and the rails migration file has the create_table method, we have to find whether to create a view in the migration file

Today, a colleague asked me to help me read a report. This report was generated by an open-source system and the background database uses MySQL. the problem is that the data in one report is incorrect. At that time, the other report was correct.

Using MySQL logs, You can redo some database operations: D: \ mysql server 5.5 \ bin> mysqlbinlog "D: \ mysql server 5.5 \ data \ mysql-bin.000001"> D: \ test. SQL Mysql-bin.000001 is a log file that is output to common SQL formats /*!40019 SET

From: http://www.javaeye.com/topic/569864 The MySQL database is automatically disconnected after being idle for more than 8 hours, leading to the inability to connect to the website. Developed an SSH-based websitePublish to serverGood dayThe next

Value range of various fields in MySQL Time: 20:59:14 Source: techtarget.com.cn Author: techtarget.com.cn   Tinyint -128-127 Tinyint unsigned 0-255 Smallint -32768-32767 Smallint unsigned 0-65535 Mediumint -8388608-8388607 Mediumint unsigned 0-167772

Load data [low_priority] [local] infile 'file_name.txt '[Replace | ignore] into Table tbl_name[Fields[Terminated by '\ T'][Optionally] enclosed by ''][Escaped by '\'][Lines terminated by '\ n'][Ignore number lines][(Col_name,...)] Load daThe TA

First, start and stop the MySQL Service Net stop MySQL Net start MySQL Second, log on to MySQL Syntax: mysql-u user name-P User Password Enter the mysql-uroot-p command, press enter and prompt you to enter the password, enter 12345, and then press

Last Saturday, I attended a Baidu technology Salon held by infoq. The topic is about MySQL. There were a lot of people present on that day. Some of them were unexpected, maybe because they were free of charge :) There are two speakers, the first