- 博客(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 ([email protected]
2016-03-24 18:01:39 6714
原创 关于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 17198
原创 oracle sqlloader安装及使用
sqlloader是客户端工具,用来快速的向oracle进行数据导入。sqlloader安装方法如下:1) 安装了oracle数据库软件后可以使用 sqlldr2)安装了oracle数据库客户端以后可以使用sqlldr3)在已经安装oracle数据库或者oracle客户端的服务器上拷贝sqlload相关文件到需要使用sqlloader服务器上,并配置环境变量即可在拷
2016-03-22 17:00:35 16401
原创 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 ([email protected]
2016-03-17 21:03:35 1415
翻译 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 1248
原创 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 ([email protected]
2016-03-10 16:19:41 2575
原创 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 503
原创 以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 576
原创 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 ([email protected]
2016-03-08 14:55:10 4782
翻译 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 557
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关注的人