[root@wallet01 ~]# rpm -ivh epel-release-6-8.noarch.rpm [root@wallet01 ~]# yum install -y bison bison-devel check check-devel boost boost-devel \ cmake readline readline-devel scons socat perl-DBD-MySQL[root@wallet01 ~]# rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm [root@wallet01 ~]# rpm -ivh percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm[root@wallet01 ~]# [root@amb01 ~]# tar zxvf mariadb-10.3.10.tar.g...
一、sql 的基本操作 （2018年11月29日，笔记） （1）数据库相关操作 创建数据库、查看数据库、删除数据库#1. 创建数据库 create database mytest default charset utf8; #2. 查看数据库 show databases; #3. 删除数据库 drop database mytest; （2）用户相关操作 创建用户，授权，回收权限，修改用户密码#1. 创建用户 create user test@% identified by password; select user, host from mysql.user; #2. 授权 grant replication ...
源库 [root@amb01 ~]# su - mysql [mysql@amb01 ~]$ mysql -utpcc -ptpcc mysql> use tpcc1000 Database changedmysql> select count(*) from history; +----------+ | count(*) | +----------+ | 3761403 | +----------+ 1 row in set (1.16 sec)mysql> show create table history; +--------- +----------------------------------------------------------------------------------------------------------------------------...
[root@amb01 ~]# wget https://raw.github.com/alibaba/otter/master/manager/deployer/src/main/resources/sql/otter-manager-schema.sql --no-check-certificate[root@amb01 ~]# mysql -uroot -pabcd.1234 mysql> source otter-manager-schema.sqlmysql> grant all privileges on *.* to otter@% identified by otter with grant option; query ok, 0 rows affected (0.04 sec)mysql> flush privileges; query ok, 0 rows affect...
[root@amb01 ~]# yum install -y perl-ExtUtils-MakeMaker perl-DBD-MySQL perl-DBI \ perl-Module-Build perl-Test-Simple perl-Time-HiRes perl-ExtUtils-CBuilder[root@amb01 ~]# yum install -y subversion [root@amb01 ~]# svn co http://code.taobao.org/svn/orzdba/trunk[root@amb01 ~]# cd trunk [root@amb01 trunk]# tar zxvf orzdba_rt_depend_perl_module.tar.gz [root@amb01 trunk]# cd Perl_Module[root@amb01 Perl_M...
[root@amb01 ~]# wget http://www.day32.com/MySQL/tuning-primer.sh [root@amb01 ~]# chmod +x tuning-primer.sh [root@amb01 ~]# vi .my.cnf [client] user=root password=abcd.1234 socket=/tmp/mysql.sock[root@amb01 ~]# ./tuning-primer.sh -- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery -MySQL Version 5.6.41-log x86_64Uptime = 8 days 20 hrs 40 min 9 sec Avg. qps = 28 T...
[root@amb01 ~]# wget http://mysqltuner.pl/ -O mysqltuner.pl --no-check-certificate [root@amb01 ~]# chmod a+x mysqltuner.pl [root@amb01 ~]# ./mysqltuner.pl --help Name: MySQLTuner 1.7.13 - MySQL High Performance Tuning Script Important Usage Guidelines: To run the script with the default options, run the script without arguments Allow MySQL server to run for at least 24-48 hours before...
https://github.com/innotop/innotop [root@gscf01 ~]# yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-TermReadKey [root@gscf01 ~]# unzip innotop-master [root@gscf01 ~]# cd innotop-master [root@gscf01 innotop-master]# perl Makefile.PL [root@gscf01 innotop-master]#make [root@gscf01 innotop-master]#make install[root@gscf01 ~]# innotop --version innotop Ver 1.11.4[root@gscf01 ~]# innotop --...
innodb_buffer_pool_size（默认值：128M 建议值：服务器物理内存的70%-80%）innodb_log_file_size（建议值：>=256M）innodb_flush_log_at_trx_commit（默认值：1） 0：事务提交时不写入重做日志文件，master thread每一秒将log buffer中的redo log写入重做日志文件，执行重做日志文件的fsync操作。 1：事务提交时写入重做日志文件，执行重做日志文件的fsync操作。 2：事务提交时写入重做日志文件，但仅写入文件系统的缓存中，由文...
导出库 [root@amb01 ~]# mysqldump -uroot -pabcd.1234 -A >fullbackup.sql [root@amb01 ~]# mysqldump -uroot -pabcd.1234 -B tpcc1000 >tpcc1000.sql -A, --all-databases：导出全部的数据库。-B, --databases：导出指定的数据库。导出表 [root@amb01 ~]# mysqldump -uroot -pabcd.1234 tpcc1000 customer >customer.sql --导出表结构与表数据，单一sql文件[root@amb01 ~]# mysqldump -uroot -pabcd.1234 -d tpcc1000 customer...
mysql> show variables like %secure%; +------------------+---------------------+ | Variable_name | Value | +------------------+---------------------+ | secure_auth | ON | | secure_file_priv | /home/mysql/backup/ | +------------------+---------------------+ 2 rows in set (0.00 sec)mysql> select * from customer into outfile /home/mysql/backup/customer.txt fields...
创建用户 mysql> create user tpcc@% identified by tpcc; Query OK, 0 rows affected (0.02 sec)修改用户密码 mysql> set password for tpcc@%=password(abcd.1234); Query OK, 0 rows affected (0.03 sec)查询用户权限 mysql> show grants for tpcc@%; +-----------------------------------------------------------------------------------------------------+ | Grants for tpcc@% ...
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateInstance.html