ITPub博客

首页 > Linux操作系统 > Linux操作系统 > mysql 数据库部署(google like?)

mysql 数据库部署(google like?)

原创 Linux操作系统 作者:babyyellow 时间:2011-08-15 12:28:13 0 删除 编辑

The MySQL settings are still being tweaked, but for Google's benefit this is what I've done so far:

  1. /tmp was formatted as mkfs.xfs -l size=64m /dev/sdb1, and mounted with rw,auto,nouser,async,dev,exec,noatime,nodiratime,logbufs=8 as the mount options.
  1. The RAID-10 was formatted with mkfs.xfs -l size=128m -d agcount=90 /dev/sdc1 and the same mount options as above.
  1. I've changed /proc/sys/vm/swappiness (also found in vm.swappiness in sysctl.conf) to 15 from its default of 60. This value is subject to adjustment as needed.
  1. I've set all the disks to use the deadline I/O scheduler. A convenient way to turn that on on a running system is echo "deadline" > /sys/block/(dev)/queue/scheduler. Add elevator=deadline to your kernel's boot parameters to do it on startup.
  1. renice -20 your mysql server process.
  1. Finally, remember kids: if at all possible, adjust all your MySQL settings to avoid swap if at all possible. Hitting the swap unnecessarily will send your load through the roof and generally make things slower.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/133735/viewspace-704856/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 一个sql的优化
请登录后发表评论 登录
全部评论
oracle MySQL Postgresql 专职数据库dba。 系统架构师。 mysql 官方认知dba 。 15年专职dba 经验。

注册时间:2010-12-02

  • 博文量
    289
  • 访问量
    1561408