- 博客(11)
- 资源 (8)
- 收藏
- 关注
原创 mysql 5.6 用户密码过期问题
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@c6b9.bsys.d
2016-03-24 18:01:39 6764
原创 关于innodb_data_file_path设置
innodb_data_file_path用来指定innodb tablespace文件,如果我们不在My.cnf文件中指定innodb_data_home_dir和innodb_data_file_path那么默认会在datadir目录下创建ibdata1 作为innodb tablespace。5.6.6之后 两个参数的默认值如下:show variables like 'innodb_d
2016-03-24 16:56:57 17319
原创 oracle sqlloader安装及使用
sqlloader是客户端工具,用来快速的向oracle进行数据导入。sqlloader安装方法如下:1) 安装了oracle数据库软件后可以使用 sqlldr2)安装了oracle数据库客户端以后可以使用sqlldr3)在已经安装oracle数据库或者oracle客户端的服务器上拷贝sqlload相关文件到需要使用sqlloader服务器上,并配置环境变量即可在拷
2016-03-22 17:00:35 16662
原创 unauthenticated user连接问题
1.版本1)操作系统 cat /etc/issueRed Hat Enterprise Linux Server release 5.5 (Tikanga)Kernel \r on an \m cat /proc/versionLinux version 2.6.32-504.el6.x86_64 (mockbuild@c6b9.bsys.dev.cento
2016-03-17 21:03:35 1459
翻译 Enabling InnoDB Monitors
Enabling InnoDB MonitorsWhen you enable InnoDB monitors for periodic output, InnoDB writes their output to the mysqld server standard error output (stderr). In this case, no output i
2016-03-17 11:10:00 1262
原创 ERROR 1030 (HY000): Got error 28 from storage engine
1.版本1)操作系统 cat /etc/issueRed Hat Enterprise Linux Server release 5.5 (Tikanga)Kernel \r on an \m cat /proc/versionLinux version 2.6.32-504.el6.x86_64 (mockbuild@c6b9.bsys.dev.cento
2016-03-10 16:19:41 2597
原创 linux 增加swap方法
方法一1.查看系统当前的分区情况: free -m total used free shared buffers cachedMem: 15947 5881 10066 26 358 3058-/+ buffers/cache:
2016-03-08 17:53:34 520
原创 以excel格式导出mysql表
方法一使用某些mysql客户端工具,如SQLlog等方法二使用 select into outfile 方法(可以导出成txt或者xls格式)select * into outfile '/tmp/test.xls' from test;方法三echo "select id,name from test;"| /usr/local/mysql/bin/mys
2016-03-08 16:40:21 594
原创 Last_Error: Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the
1.版本1)操作系统 cat /etc/issueRed Hat Enterprise Linux Server release 5.5 (Tikanga)Kernel \r on an \m cat /proc/versionLinux version 2.6.32-504.el6.x86_64 (mockbuild@c6b9.bsys.dev.cento
2016-03-08 14:55:10 4883
翻译 Calculate Mysql Memory Usage – Quick Stored Procedure
In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory usage estimation for th
2016-03-07 10:21:18 572
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关注的人