MySQL

# # # Master ClusterLog-bin=mysql-binServer-id=1Binlog-do-db=ukjsExpire-logs-days=7GRANT REPLICATION SLAVE on * * to ' SLAVE ' @ ' 192.xx.0.xx ' identified by ' root$%^ ';Start master;Show Master Status\g;# # Slave Clusterserver-id=2#master-port=3306

InnoDB is used to buffer its data and index the size of the memory buffer, mainly innodb_buffer_poor_size to set, the higher the parameter setting, the less disk I/O is required to access the table, if it is a dedicated database server, Then you can

1. Create a stored procedure in the database firstDROP PROCEDURE IF EXISTS sqloperation;create PROCEDURE sqloperation () BEGIN insert into UserInfo (Userid,username,userpas   Sword) VALUES (' 6 ', ' cyt ', ' cyt123 ');   Update userinfo set

Little rookie contact Linux too late, install a MySQL (free installation of mysql-5.6.22-linux-glibc2.5-x86_64 version, the simplest installation method) for two of nights ...Linux installed everywhere on the MySQL installation, but my own

"Repair MyISAM table error after MySQL power off restart" fix_myisam_table.sh#!/bin/bash# # 2014/10/13fix_bin= '/usr/bin/myisamchk ' d_db_data= '/data/mysql_data/3306 ' dt= ' date + '%y%m%d ' ' CD ${d_db _data}echo ' >>=========================== '

has been using Oracle, long time no use of MySQL, today built a MySQL web development environment. Unexpectedly throws this exception: Remember that when you create the data, the character set is Utf-8: CREATE DATABASE service DEFAULT CHARACTER SET

1: Use the show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;2:2. Create a database Mysqldatamysql> CREATE DATABASE Mysqldata;3: Select the database you createdmysql> use Mysqldata; (press ENTER to appear

1. One way is to set the collation of a table or row so that it is binary or case sensitive. In MySQL, the naming method for column collate's conventions is as follows:*_bin: Indicates a binary case sensitive collation, which means*_cs:case

In the actual project, we need to import the data that already exists in the database into the SOLR Index library, and SOLR gives us a very easy way to DIH, as we take MySQL data for example.1. Enter your core (e.g. Collection1) and create a new

To view the size of each table in the database:Select table_name, concat (Truncate (data_length/1024/1024,2), ' MB ') as Data_size,Concat (Truncate (index_length/1024/1024,2), ' MB ') as Index_sizeFrom information_schema.tables where Table_schema = '

Recently, multiple instances of MySQL were needed due to job requirements. Since this requirement was not taken into account at the beginning of the planning, MySQL was not deployed in the relevant multi-instance setup. Prior to the installation of

explain SQL statements, viewing usage indexesView Execution TimeReference article: http://www.cnblogs.com/ggjucheng/archive/2012/11/15/2772058.html1, open profiling parameter set profiling=1;After you turn on the query Profiler feature, MySQL

MySQL GROUP by day (grouped by date) Select Day (Date field), SUM (field for totals) from table group by dateI. Annual ENQUIRYQuerying data for the yearSELECT *From Blog_articleWHERE year (From_unixtime (blogcreatetime)) = year (Curdate ()) Second,

[Reprint]mysql's Binlog safely removedTheoretically, you should add a configuration entry for the Binlog expiration time in the profile/etc/my.cnf, Expire_logs_days = 10 but without adding this, the disk is eaten a lot as more and more binlog are

http://blog.csdn.net/bbirdsky/article/details/8134528#When you log in to the MySQL database: Error1045 errors (such as), it indicates that you entered the user name or password error is denied access, the simplest solution is to uninstall and reload

Introduction to the use of with in oracle subquery; Introduction to oracle Recently I have studied oracle and want to improve the efficiency and ease of reading of statements I have written. Today's note is about subquery factors.   Factor-based

Keepalived + Lvs + Mysql master-master Replication 1 Introduction Keepalived + lvs + mysql master/Master replication is a common Mysql high-availability solution. lvs provides read load balancing and Keepalived implements automatic failover through

Comparison of differential functions between MySQL and Oracle No. Category ORACLE MYSQL Note 1 Numeric Functions Round (1.23456, 4) Round (1.23456, 4) Same:ORACLE: select round (1.23456, 4) value from

Use the Apache DBCP connection pool to reconstruct DBUtility to make database connection more effective and secure. dbcpdbutility Avoid the following risks when you directly access the database using JDBC: 1. For each data operation request, you

How MySQL uses temporary tables to accelerate queries This article describes how MySQL uses temporary tables to accelerate queries. Share it with you for your reference. The specific analysis is as follows: MySQL temporary tables can be used to