wgz7747147820的博客

mysql的error log还有general log等需要进行切割。可以结合logrotate进行log 切割拷贝support_files下的mysql-log-rotate文件到/etc/logrotate.d/目录下，然后将权限修改为644需要对mysql-log-rotate的内容继续修改已适应文件所在位置及切割的要求[root@rws1270149 logrotate.d]# ...

最近再做mycat测试，发现在mycat中插入无法插入到物理库中，从物理库中插入数据，在mycat中是可以查询到的经过多次尝试，修改数据分片规则，将分片字段修改为not null，或者修改为primary key，都无法解决问题后来尝试在物理库中将该表删除，然后再mycat中创建该表，仍然无法解决此问题。最后发现原因在于两个dataHost上一个autocommit设置为0，另外一个data...

[root@rws1270149 bin]# ./innobackupex --user=root --password=AAAbbb_444 /tmp[root@rws1270149 tmp]# tar -czf 2019-06-04_01-57-39.tar.gz ./2019-06-04_01-57-39[root@rws1270149 tmp]# scp 2019-06-04_0...

[root@rws1270173 bin]# ./mysqld start2019-06-05T01:52:28.940460Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see docum...

首先需要安装pymysql 模块[root@rws1270149 /]# pip3 install pymysqlCollecting pymysql Downloading https://files.pythonhosted.org/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/P...

mysql8.0.16使用mysqld start就会报这个错误2019-06-07T14:28:12.377372Z 0 [ERROR] [MY-010147] [Server] Too many arguments (first extra is 'start').2019-06-07T14:28:12.400945Z 0 [ERROR] [MY-010119] [Server] Ab...

cp mysql.server /etc/init.d/mysqldchkconfig add mysqld然后就可以使用service mysql start来启动mysql了

mysql> select host,user from user;+-----------+---------------+| host | user |+-----------+---------------+| localhost | mysql.session || localhost | mysql.sys || localhost ...

Default options are read from the following files in the given order:/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnfThe following groups are read: mysqld server mysqld-5.7我们使用...

[root@rws1270149 bin]# ./innobackupex --user=root --password=AAAbbb_444 /tmp./innobackupex: error while loading shared libraries: libgcrypt.so.20: cannot open shared object file: No such file or dire...

http://www.cnblogs.com/Hebe/p/4448187.html参考一下

使用perl dbi连接mysql并插入一条数据[root@rws1270149 script_wgz]# cat mysql.pl#!/usr/bin/perluse DBI;my $host="127.0.0.1";my $port="3306";my $user="root";my $password="password";my $db_name="db100";my $s...

首先确认innodb_fast_shutdown的参数值为1mysql> show global variables like ‘%innodb_fast_shutdown%’;±---------------------±------+| Variable_name | Value |±---------------------±------+| innodb_fa...

mysql数据库初始化后初次登录需要修改密码初次登录会碰到下面这个错误ql> alter user root identified by ‘password’;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.需要使用下...

mysql> alter event event_1 disable;ERROR 1044 (42000): Access denied for user ‘root’@‘localhost’ to database ‘information_schema’mysql> select database();±-------------------+| database() ...

mysql指定密码的几种方式1.添加在连接用户的下.my.cnf文件中[root@rws1270149 bin]# cat /root/.my.cnf[client]user=rootpassword=密码socket=/scratch/mysql-5.7.25-linux-glibc2.12-x86_64/data/mysql.sock2.使用环境变量export MYSQL_P...

mysql> create table t1(a varchar(200),b varchar(200));Query OK, 0 rows affected (0.01 sec)mysql> delimiter $$mysql> drop procedure if exists p1$$Query OK, 0 rows affected, 1 warning (0.00...

参考一下https://blog.csdn.net/w2064004678/article/details/83012387有时间细细研究一下，对比一下oracle mysql和postgresql

https://www.cnblogs.com/guaidaodark/p/6022994.html参考一下

我的环境：使用了两个机器：rws1270149rws1270173两个机器上都是在3306端口上跑着一个mysql实例在两个mysql实例上都创建u123这个用户并赋予权限mycat的参数文件server.xml 里面配置的user其实是在mysql里面创建的mysql> create user 'u123'@'%' identified by 'u123';Query OK...

$dsn的详细用法my $dsn = "dbi:mysql:database=${db_name};hostname=${db_host};mysql_socket=${db_sock};port=${db_port};mysql_compression=1;mysql_read_default_file=$ENV{HOME}/.my.cnf;mysql_read_default_group=c...

https://blog.csdn.net/herokoking/article/details/60123334参考一下，非常好

mysqld_install_db已经deprecated[mysql@rws1270149 bin]$ ./mysql_install_db --datadir=/scratch/mysql5.7/data --basedir=/scratch/mysql5.72019-06-17 23:01:32 [WARNING] mysql_install_db is deprecated. Ple...