rgb_rgb的博客

原文：http://luolee.me/?p=477

问题：ERROR 2013 (HY000): Lost connection to MySQL server during query160613  9:11:45 [ERROR] mysqld got signal 11 ;This could be because you hit a bug. It is also possible that this binary

[root@fddc ~]# ldd /u01/app/product/11.2.0/dbhome_1/lib/libsqora.so.11.1        linux-vdso.so.1 =>  (0x00007ffffa3ff000)        libdl.so.2 => /lib64/libdl.so.2 (0x00007feea843a000)        libm.s

问题：-- Check size of long-- Check size of long - done-- Check size of int-- Check size of int - done-- Check if the system is big endian-- Searching 16 bit integer-- Using unsigned short

操作系统：# lsb_release -aLSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchDistributor ID: RedH

使用mysqlbinlog工具恢复MySQL数据库的方法

expire_logs_day：mysql>   PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 30 DAY);（清理30天前的二进制日志文件，如果主库在使用30天前的日志文件 会报错的）修改my.cnf文件【mysqld】expire_logs_day=20;

[root@test ~]# /root/tcyang/tbs.sh ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/tbs.log' (Errcode: 24 "Too many open files")[root@test ~]# ulimit -acore file size        

[root@pc197 mariadb-5.5.37]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGIN

参考：https://mariadb.com/kb/en/mariadb/documentation/storage-engines/connect/connect-table-types/connect-table-types-odbc-table-type-accessing-tables-from-other-dbms/

[root@test support-files]# /usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/var/mysql/data --user=mysqlInstalling MariaDB/MySQL system tabl

通过HeidiSQL连接MYSQL数据库报错： SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this MySQL server说明所连接的用户帐号没有远程连接的权限，只能在本机(localhost)登录。需更改 mysql 数据库里的 user表里的 host项把localhost改称%首先

问题：ERROR 1197 (HY000) at line 2: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again表占用空间626MB[root@vm-m4-new