MySQL

1.windows IIS +ftp Installation Start----Control Panel----Add or Remove Programs as shown The following interface appears click "Add/Remove Windows Component (a)" as shown The following interface appears Select Application Server Click "

Creating a new MySQL database requires only three steps: 1, set up a database,2, create user name and password;3, add users and permissions to the database. First login cpanel background, locate the database area, and then click on the MySQL

MySQL SQL character join function 1, Concat () function     1.1 MySQL's Concat function can connect one or more strings, such as    & nbsp;    mysql> Select concat (' 10 ');         +--------------+         | Concat (' 10 ') |         +--------

The order is over $600 during the calculation activity and has not been placed for more than 30 days before the activity datefirst get this demand, first need to clear the activity date interval 10.29-10.31, its secondary to the time of the day of

NET core access, manage MySQL through Ef coreThis address: http://www.cnblogs.com/likeli/p/5910524.htmlEnvironmentdotnet Core Version:1.0.0-preview2-003131This article is divided into a window environment and a MAC Os x environment. Related

1. Install MySQLCurrently MySQL has two forms of files, one in MSI format and one in ZIP format. The direct click setup.exe in MSI Format is just fine, follow the steps. But many people under the ZIP format decompression found no setup.exe, I

[[email protected] ~]# grep "binlog-do-db"/etc/my.cnf binlog-do-db = test[[email protected] ~]# grep "Binlog-do-db"/etc/ My.cnfbinlog-do-db=testbinlog-do-db=test2db:mysql> use test2;database changedmysql> show tables; Empty Set (0.00 sec) mysql>

[Email protected] test]# strace-f-f-e trace=fdatasync,fsync-p 4043Process8703Attached with atThreads-Interrupt toquit[pid 7089]Fsync9)= 0[PID 4063]Fsync9)= 0[PID 4063]Fsync9)= 0[PID 4061]Fsync4)= 0[PID 4050]Fsync4)= 0[PID 4050]Fsync -)= 0[PID

Generating serial numbers with stored procedures is a common use, as an example of generating a serial number for an order number. (The new Day of the serial number starting from 1, such as: Today's order number is CD2013010900014, the next order

MySQL is the most popular open source SQL database management system, developed, published, and supported by Mysqlab Corporation. Mysqlab is a commercial company founded by several MySQL developers. It is a second-generation open source company that

MySQL prevent duplicate Insert Record method summaryThere are many ways to prevent MySQL from repeatedly inserting records, usually Ignore,replace,on DUPLICATE KEY UPDATE, which we can also judge in PHP.Scenario One: Using the Ignore keywordIf the

When using MySQL to create data tables, it is unavoidable to involve the concept of character set and collation, which is not well understood before.The two days are not very busy, and I tidied up a bit.Let's take a look at character set and

The GROUP BY statement uses the B+tree index scan to be divided into two cases: loose scan, compact scan.Loose Index Scan (loosely scanned) is just a small portion of the key value that needs to be taken out of the index scan to complete a scan of

MySQL Bulk SQL Insert performance optimizationsPosted by Kiki TitaniumOn December 7, 2012 For some systems with large data volume, the problem of database is not only inefficient, but also the data storage time is long. Especially like a reporting

For data security, sometimes the database needs to delay backup, here are two ways to delay backup.First, the use of tools.Implementing the Environment:192.168.189.143 (MySQL Main library)192.168.189.144 (MySQL standby, 3 minutes delay)Steps:1:

Believe that a lot of people who have been using MySQL for a long time, the concept of these two field properties is not very clear, the general will have the following questions: My field type is not NULL, why can I insert a null value

Use pt-query-digest to find the SQL statement that is not suitable, pt-query-digestsql  Overview of pt-query-digest1. Indexes can be executed more quickly, but there must be unreasonable indexes. If you want to find those indexes that are not very

IntroductionOptimizing SQL is a common task of DBA. How to optimize a statement efficiently and quickly is a common problem for every DBA. In my daily optimization work, I found that many operations are essential in the optimization process. However,

Mysql Fpmmm is an upgraded version of MPM. It is more convenient to use fpmmm than mpm, but the corresponding optimization parameters must be enabled.1. Configure the pidCopy the startup scriptCp support-files/mysql. server/etc/init.

In a production environment, logstash often processes logs in multiple formats. Different log formats have different parsing methods. The following is an example of how logstash processes multi-line logs and analyzes MySQL slow query logs. This is a