DB
luckhouge
这个作者很懒,什么都没留下…
展开
-
安装postgreSQL
1. 安装PostgreSQL9.1vi /etc/yum.repos.d/CentOS-Base-16repo在[base] and [updates] sections 加上exclude=postgresql*2获取并安装软件包cd /root/tmp/wget http://yum.postgresql.org/9.1/redhat/rhel-5-i386/pgdg...原创 2014-02-21 09:22:39 · 99 阅读 · 0 评论 -
mysql 安装
1.下载地址[url]http://downloads.mysql.com/archives/community/[/url]2.64位linuxLinux - Generic (glibc 2.5) (x86, 64-bit), RPM Bundle3.解压后rpm -ivh MySQL-client-5.6.24-1.linux_glibc2.5.x86_64....原创 2015-07-07 15:29:17 · 71 阅读 · 0 评论 -
mysql启动失败
查看mysqld.log[code="java"]/opt/redmine-2.6.0-1/mysql/bin/mysqld.bin: Error writing file '/opt/redmine-2.6.0-1/mysql/data/mysqld.pid' (Errcode: 28)Can't start server: can't create PID file: No spa...原创 2015-07-10 15:12:21 · 112 阅读 · 0 评论 -
mysql could not be resolved: Temporary failure in name resolution
新安装的mysql,程序初始建立连接要花费10秒,查询mysql error日志,发现。。。 could not be resolved: Temporary failure in name resolution经网上分享,如下操作在mysql的配置文件my.cnf中[mysqld]节点添加下面两行skip-host-cacheskip-name-resol...原创 2015-07-31 14:51:07 · 685 阅读 · 0 评论 -
MySQL数据库架构
[size=large]1、MySQL主从复制[/size]优点:读写分离,并很好的提升了读的性能缺点:1. 写入无法扩展、无法缓存2. 复制延时3. 锁表率上升4. 表变大,缓存率下降[size=large]2、MySQL垂直分区(分库)[/size]优点:数据独立,互不影响缺点:1.关联查询2.不能解决单张表数据量暴涨的问题[size=l...原创 2018-02-02 16:33:15 · 185 阅读 · 0 评论