- 博客(18)
- 资源 (8)
- 收藏
- 关注
原创 expire_logs_days
mysql中的expire_logs_days参数大家应该都熟悉,主要用来控制binlog日志文件保留时间,超过保留时间的binlog日志会被自动删除。比如我们指定expire_logs_days=7,表示表示最近7天的binlog日志,7天以前的binlog日志会被自动删除。下面是官方文档中对expire_logs_days的描述: expire_logs_days
2016-05-27 14:53:11 24757 1
翻译 When Does MySQL Rotate the Binary Log (Doc ID 1937268.1)
When Does MySQL Rotate the Binary Log (Doc ID 1937268.1)To BottomIn this DocumentGoal Solution References
2016-05-26 10:29:24 1106
原创 linux 后台执行scp
linux 下后台执行scp 因为要传输一个大文件到另一台服务器上,因为传输速度不是很高,传输需要十几个小时,为了保证传输过程不会因为其他原因导致中断,准备把scp放到后台运行。说到后台执行 我们都知道 nohup command &,但是scp命令需要输入密码,所以无法直接使用nohup 。方法1: 我们可以先配置两台服务器之间的互信,然后在执行1)配置互信ss
2016-05-18 11:41:49 7894
原创 linux 互信不生效
1. 操作系统版本1)操作系统 cat /etc/issuecat /etc/issueCentOS release 6.6 (Final)Kernel \r on an \m cat /proc/versioncat /proc/versionLinux version 2.6.32-504.el6.x86_64 (mockbuild@c6b
2016-05-17 18:49:22 5933
原创 InnoDB: Error: unable to create temporary file; errno: 13
^G/usr/sbin/mysqld: Can't create/write to file '/home/tmp_test/ibJOkvIT' (Errcode: 13)160511 16:46:58 InnoDB: Error: unable to create temporary file; errno: 13160511 16:46:58 [ERROR] Plugin 'InnoDB' init function returned error.160511 16:46:58 [ERROR]
2016-05-11 17:07:14 9971
原创 The table '#sql-fb5_190a57' is full Operation failed
The table '#sql-fb5_190a57' is full Operation failed
2016-05-11 15:32:19 2069
原创 ERROR 1074 (42000): Column length too big for column ‘Flist‘ (max = 21845); use BLOB or TEXT instead
ERROR 1074 (42000): Column length too big for column 'Flist' (max = 21845); use BLOB or TEXT insteadERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check
2016-05-10 15:13:10 12954
转载 捉虫动态· pid file丢失问题分析
现象mysql5.5,通过命令show variables like '%pid_file%'; 可以查到pid文件位置,例如/home/mysql/xx.pid。但发现在此目录下找不到此pid文件。背景知识mysql pid文件记录的是当前mysqld进程的pid。通过mysqld_safe启动mysqld时,mysqld_safe会检查PID文件,未指定PID文件时,pid文件
2016-05-07 09:42:49 1159
翻译 Recover Table Structure From InnoDB Dictionary
Recover Table Structure From InnoDB DictionaryWhen a table gets dropped MySQL removes respective .frm file. This post explain how to recover table structure if the table was dropped.You ne
2016-05-03 15:26:48 601
翻译 Take image from corrupted hard drive
Take image from corrupted hard driveThere are at least two cases when it makes sense to take an image from acorrupted hard drive as soon as possible: disk hardware errors and corrupted filesy
2016-05-03 15:26:06 640
翻译 Recover Corrupt MySQL Database
UPDATE:We announced online data recovery from corrupt databases.Check it out onhttps://recovery.twindb.com/The unDROP for InnoDBtool can be used to recover corrupt MySQL database. In this
2016-05-03 15:25:11 2238
翻译 Recover after DROP TABLE, innodb_file_per_table is ON
Recover after DROP TABLE, innodb_file_per_table is ONIntroductionIn the previous post we described the situation when TwinDB recovery toolkit can be used to recover accidentaly dropped
2016-05-03 15:24:01 844
翻译 Recover after DROP TABLE, innodb_file_per_table is OFF
Recover after DROP TABLE, innodb_file_per_table is OFFIntroductionHuman mistakes are inevitable. Wrong “DROP DATABASE” or “DROP TABLE” may destroy critical data on the MySQL server. Back
2016-05-03 15:23:16 648
翻译 Recover InnoDB dictionary
Why do we need to recover InnoDB dictionaryc_parser is a tool from TwinDB recovery toolkit that can read InnoDB page and fetch records out of it. Although it can scan any stream of bytes recovery
2016-05-03 15:22:18 960
翻译 UnDROP tool for InnoDB
UnDROP tool for InnoDBTwinDB data recovery toolkit is a set of tools that work with InnoDB tablespaces at low level.Incredible Performance of stream_parserstream_parser is a tool that find
2016-05-03 15:13:55 1662
翻译 InnoDB dictionary
Why Does InnoDB Need DictionaryInnoDB dictionary is a set of internal tables InnoDB uses to maintain various information about user tables. It serves as API between a human and the database. While
2016-05-03 15:11:27 622
翻译 TwinDB data recovery toolkit
TwinDB data recovery toolkitSupported Failures TwinDB Data Recovery Toolkit is a set of tools that operate with MySQL files at low level and allow to recover InnoDB databases after differe
2016-05-03 14:59:36 1896
Query Optimization with MySQL 5.7 and MariaDB 10 Even newer tricks
2017-11-30
SecureCRTandSecureFXv7.3.3x86x64build779正式版-附带注册机.zip
2016-01-14
Ora-00600 [Qerltcuseriterget_1], [1], [1], [] and Ora-1502 (Doc ID 1432485.1)
2014-07-17
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人