MySQL

As a MySQL DBA, you must have the following qualities:First, physical fitnessThe DBA must receive and process various alarms, whether at noon or at three o'clock in the morning, into deep sleep. Received the alarm need to immediately enter the

1,use Mysqlslap for stress testingMysqlslap--defaults-file=/etc/my.cnf--concurrency=200--iterations=1--number-int-cols=1--auto-generate-sql-- Auto-generate-sql-load-type=write--engine=myisam,innodb--number-of-queries=200-s/home/mysql/mysql.sock--

Preface After the installation of MySQL, there must be some tuning of MySQL's various parameter options. Although the MySQL system is highly scalable, it can run efficiently in a very sufficient hardware resource environment, and can operate well in

Original train: Consistent nonlocking Reads MySQL's consistent read mechanism is implemented as follows: The InnoDB engine provides a snapshot of the time T1 for a transactional TX (T1 is the The point in time at which the query statement was first

DELETE from ' logs ' WHERE wangzhi= ' www.juhutang.com ' and id<>101072;The above code means to delete all the fields in the table logs Wangzhi contains data with www.juhutang.com content. However, this data with ID 101072 in the same table is not

How to open a MySQL remote account-1) first log in to MySQL with the root accountIn the Windows Host, click Start menu, Run, enter "cmd", enter the console, then CD into the MySQL bin directory, and then enter the following command.> mysql-uroot-p123

Because the database was accidentally installed to the C drive, feel not very good so want to go to other disks, so refer to the general steps on the Internet to unload the database, but after the end of the discovery or not to go up, after a period

First of all, I'm talking about my situation, I didn't forget my root password, but I chose 1 when I changed my password when I was using phpMyAdmin.This method to encrypt and change the password, and then log on again when the login is not on, so

Environment:Master ip:192.168.10.10Salve ip:192.168.10.201) Install MySQL on both machines.2) Modify Master my.cnf to add the following linesServer-id = 1Log-bin =/opt/mysql/log/mysql-bin.logDataDir =/opt/mysql/dataInnodb_flush_log_at_trx_commit =

Today, with MySQL's sub-table problem, you can use scripting to iterate through the creation of a new table, or you can build it using SQL. The following is an example of establishing a player_0 to player_9 statement.Delimiter//CREATE procedure

MySQL Quick insert and batch update Insert: MySQL provides a way to insert multiple data at once: [SQL] INSERT into Tbl_name (a,b,c) VALUES (All-in-all), (4,5,6), (7,8,9), (10,11,12) ...; In the program, you can add a list of values by looping, and

MySQL remote access, that is, through IP access to the MySQL service, MySQL requirements for security is very strict and requires authorization.1. Local AccessSQL code GRANT All privileges on * * to [e- Mail protected] identified by '

For MySQL has been the second time to see, the main purpose is to summarize the MySQL system on one side, before learning MySQL is to write notes in the book, later do not want to always take the book, so take a moment to summarize the notes in the

1. First download the Windows edition mysql5.6 free install ZIP package to http://dev.mysql.com/. Then extract the zip package to D:\mysql-5.6.20-winx64.2. Copy the My-default.ini under MySQL and create the My.ini in the same directory. My.ini is

Sometimes, when using MySQL, you may find that even though a table deletes a lot of data, the data and index files of this table are surprisingly small. This is because when MySQL deletes data (especially text and blobs), it leaves a lot of data

Location of sub-query:Select in, from, and where. There is no practical meaning in group by and order by. Sub-queries fall into the following categories:1, scalar quantum query: Returns the single value of scalars, the simplest form.2, column query:

Detailed compilation Installation lamp environmentInstall OS and software versionsOs:cent OS 6.5Apache:httpd-2.4.10.tar.gzphp:php-5.4.31.tar.bz2Mysql:mysql-5.6.19.tar.gzXcache:xcache-3.1.0.tar.gzFirst, pre-installation preparationModify Host

1, with Begin,rollback,commit to achieveBegin a transactionROLLBACK TRANSACTION RollbackCommit TRANSACTION Acknowledgement2, directly with set to change the MySQL automatic submission modeMySQL is automatically submitted by default, that is, you

[Mysql] Common commands-user operations (create, authorize, modify, delete) Each user in Mysql corresponds to different user addresses and permissions. There are three ways to create a Mysql user: 1. create user 2. grant 3. Operate the mysql. user

Custom function programming in mysql Syntax: New: Create function function_name (parameter list) returns Return Value Type Function body Function name, which must be a valid identifier and should not conflict with an existing keyword. A function