leafonsword.org
leafonsword.org平生只做一件事，做自己喜欢做的事！
http://www.leafonsword.org/
平生只做一件事，做自己喜欢做的事！
http://www.leafonsword.org/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.8 seconds
16x16
32x32
64x64
128x128
160x160
192x192
guo feng
1ha●●●ian
Sha●●●hai , Shanghai, 211100
CN
View this contact
guo feng
1ha●●●ian
Sha●●●hai , Shanghai, 211100
CN
View this contact
guo feng
1ha●●●ian
Sha●●●hai , Shanghai, 211100
CN
View this contact
BUY YOUR DOMAIN
GoDaddy.com, LLC (R91-LROR)
WHOIS : whois.publicinterestregistry.net
REFERRED :
PAGES IN
THIS WEBSITE
6
SSL
EXTERNAL LINKS
52
SITE IP
166.78.103.6
LOAD TIME
0.77 sec
SCORE
6.2
leafonsword.org | leafonsword.org Reviews
https://leafonsword.org
平生只做一件事，做自己喜欢做的事！
leafonsword.org
Ansible无法连接老旧机器
http://www.leafonsword.org/ansible-connect-to-old-machine
SUSE Enterprise Server 10. 远端机器:SSH Secure Shell 3.2.9.1 and Python2.4. Ansible oldserver -i hosts -m ping. Testserver2 FAILED = FAILED: ('Bad authentication type', [u'publickey', u'keyboard-interactive']) (allowed types=[u'publickey', u'keyboard-interactive']). 这错误之前我用Fabric也遇到过,表现为终端一直提示输入密码,但明明密码正确就是登陆不上,看来是paramiko库对SSH Secure Shell验证出现问题,想到令ansible使用本地native ssh客户端而不是paramiko库来连接远端机器(其实1.3后的ansible检测到本地openssh是较新版本的话会自动调用native ssh的):. Ansible -c ssh oldserver -i hosts -m ping.
使用MyDumper迁移InnoDB到TokuDB
http://www.leafonsword.org/migrate-innodb-to-tokudb-using-mydumper
Mysqldump . sed -e 's/ ) ENGINE=MyISAM/) ENGINE=InnoDB/' dump.sql. 但这样导出的单一文件恢复时太慢，虽然有各种第三方方法能使mysqldump导出多个文件，但复杂了些 而mydumper因为并行特性是一个更理想的迁移工具，但0.6之前因为锁时间太长导致实际不可用，而0.6后大大 降低了锁时间. Mydumper . -o /data/dump. Mkdir /data/dump schema mv /data/dump/*schema* /data/dump schema mv /data/dump /data/dump data cp /data/dump/metadata /data/dump schema. Myloader . -d /data/dump schema. Pt-find . - engine InnoDB - exec "ALTER TABLE %D.%N ENGINE=TokuDB". Myloader . -d /data/dump data. 上,主要记录我的一些原创技术文章;假如你也打算用 Linode.
刀尖红叶的博客 - Page 2
http://www.leafonsword.org/page/2
User Statistic是个能统计MySQL中线程、用户、表、索引等信息的插件,在Percona和MariaDB直接集成了,但官方文档没有多少实用例子,以下是我日常用的一些例子(测试跑在MariaDB 10.0上): 1.找出没被访问过的表 use INFORMATION SCHEMA; select table schema,table name from STATISTICS where (table schema,table name) not in (select table schema,table name from TABLE STATISTICS ) and table schema not in ('information schema','performance schema','mysql'); 生成drop语句: use…. 自从2008年接触Linux,Linux一直是我的主力桌面操作系统- 从Ubuntu到Fedora到Arch到Gentoo再到Deepin，现在又回到起点用上了Ubuntu Kylin;但感觉我的超极本跑着还是有些卡,优化了下,记录之: 删除无用的启动项...
一道Redis面试题
http://www.leafonsword.org/redis
花了一下午了解了下redis,发现这货似乎蛮简单的,而且有哈希和列表数据结构.我一开始想用哈希,每个用户为key,登陆时间为value,统计下. Select count(user) from user log where access between date sub(now, interval 1 hour) and now(). 但感觉这种范围查找会比较慢.后来觉得用列表是个好方法:列表中每个元素代表登陆时间,只要最后的第5次登陆时间和现在时间差不超过1小时就禁止登陆.用Python写的代码如下,感觉蛮简练的,如果网友有更巧妙的方法,欢迎指教. DBA(MySQL&MongoDB;) 热爱开源,喜欢Linux,偶尔码码Python、Golang. DBA(MySQL&MongoDB;) 热爱开源,喜欢Linux,偶尔码码Python、Golang. 上,主要记录我的一些原创技术文章;假如你也打算用 Linode.
使用Arrow生成一段连续的日期时间
http://www.leafonsword.org/using-arrow-generate-datetime-range
Usr/bin/env python3 import datetime dt = datetime.date(2015,1,1) end = datetime.date(2015,12,31) step = datetime.timedelta(days=1) while dt end: print(dt.strftime('%Y-%m-%d') dt = step. Usr/bin/env python3 import arrow start = arrow.get('2015-01-01','YYYY-MM-DD') end = arrow.get('2015-12-31','YYYY-MM-DD') for dt in arrow.Arrow.range('day', start, end): print(dt.format('YYYYMMDD'). 的一个小例子,但能感受到确实比datetime, time, calendar, dateutil等这些日期时间模块都方便，强烈推荐它 更多用法可以到 软件主页. 上,主要记录我的一些原创技术文章;假如你也打算用 Linode.
TOTAL PAGES IN THIS WEBSITE
6
percona – Arster's blog
http://highdb.com/tag/percona
My articles and thoughts. MySQL slave 延迟复制 延迟复制是一个很简单的概念，区别于传统的异步复制(接近实时), 比如用户误操作, 删除了重要的表, 延迟复制特性保证了用户有机会从延迟的 slave 中恢复误删除的表. 该特性的问题在于需要保证用户有足够的时间从 slave 阻止误操作复制的发生. 要理解该特性如何实现, 我们先简单回顾下 MySQL replication 如何实现, 见下图: 当 master 有一个更新操作(create, drop, delete, insert, update 等), 该更新操作应用到本地的磁盘并写到 binary log 里，之后更新操作异步(接近于实时)的从master…. Pt-osc chunking handles multi-column indexes poorly. Top 10 percona toolkit tools(五). 9 pt-table-checksum http:/ www.percona.com/doc/percona-toolkit/2.2/pt-table-che...7 pt-quer...
Arster's blog – Page 2 – my articles and thoughts
http://highdb.com/page/2
My articles and thoughts. Mysql upgrade 升级错误出现 table doesn’t exist 错误整理. 从 MySQL 官方的 5.1.48 版本升级到 Percona 5.1.73 版本, 在使用 mysql upgrade 的时候出现一些错误, 该原因可能为innodb表文件丢失或损坏, 或使用了不正确的方式删除表. 错误信息如下所示: [root@cz ]# cd /opt/Percona-Server-5.1.73-rel14.12-624.Linux.x86 64/ [root@cz Percona-Server-5.1.73-rel14.12-624.Linux.x86 64]# ./bin/mysql upgrade -S /export/mysql/node3307/data/s3307 -p –verbose … Repairing table test.蔢 Error…. Qtunnel 加密数据库主从复制通道 链接见: https:/ github.com/getqujing/qtunnel https:/ github.c...重启 ip...
performance – Arster's blog
http://highdb.com/category/performance
My articles and thoughts. MySQL Router 测试使用 1. 特性 MySQL Router 并没有包括一些特别新的特性, 总体上看中规中矩, 不过 first-available 和插件两个特性挺有意思, 后续会进行讲解, 特性包括: 对连接请求进行路由; 和 Fabric 配套使用, 方便管理; 插件特性, 需要的功能以插件形式提供; 2. 配置 MySQL Router 在启动的时候会读取默认的配置文件, 用户可以通过 -DROUTER CONFIGDIR= 或编辑 cmake/settings.cmake…. 重启 iptables 影响 nf conntrack 参数说明. 1 介绍 详见: https:/ github.com/tobert/pcstat pcstat 是 page cache stats 的缩写, 使用该工具可以帮助我们判断一个文件是否被 Linux cache 缓存, 或获取进程在 cache 中的缓存信息. 这在调优数据库或诊断其他 IO 密集型应用的场景下会有所帮助. 该工具的输出有多种格式, 选项包括: Usa...Env环境: Di...
performance – Arster's blog
http://highdb.com/tag/performance
My articles and thoughts. 1 介绍 详见: https:/ github.com/tobert/pcstat pcstat 是 page cache stats 的缩写, 使用该工具可以帮助我们判断一个文件是否被 Linux cache 缓存, 或获取进程在 cache 中的缓存信息. 这在调优数据库或诊断其他 IO 密集型应用的场景下会有所帮助. 该工具的输出有多种格式, 选项包括: Usage of ./pcstat: -bname=false: convert paths to basename…. Perl one line command – 常用正则. Perl one line command – 输出和删除行. Perl one line command – 转义和替换. Perl one line command – 字符串与数组. Common utilities for sysadmin/dba. Mysql upgrade 升级错误出现 table doesn’t exist 错误整理. On Perl one line command – ...
percona – Arster's blog
http://highdb.com/category/percona
My articles and thoughts. Mysql upgrade 升级错误出现 table doesn’t exist 错误整理. 从 MySQL 官方的 5.1.48 版本升级到 Percona 5.1.73 版本, 在使用 mysql upgrade 的时候出现一些错误, 该原因可能为innodb表文件丢失或损坏, 或使用了不正确的方式删除表. 错误信息如下所示: [root@cz ]# cd /opt/Percona-Server-5.1.73-rel14.12-624.Linux.x86 64/ [root@cz Percona-Server-5.1.73-rel14.12-624.Linux.x86 64]# ./bin/mysql upgrade -S /export/mysql/node3307/data/s3307 -p –verbose … Repairing table test.蔢 Error…. Pt-osc chunking handles multi-column indexes poorly. Top 10 percona toolkit tools(五).
MySQL – Arster's blog
http://highdb.com/tag/mysql
My articles and thoughts. 背景介绍 本文基于一个 discuz 论坛表的需求描述 — 将论坛中所有表为 mediumint(8) 的字段升级为 int(10)， 以存储更大的用户 id 信息; 通过批量升级字段的方式也适用于其它相关的需求. 顺便吐槽下 discuz 这么多年以来对基础表的优化接近于无, 在用户较多或访问较频繁的场景下, 基础表的结构依然缺乏比较完善的设计. 步骤 考虑到论坛运行一段时间后, 一些表会比较大, 如果业务需要持续运行的话, 不太适合直接 alter table 的方式更新表, 下文会介绍使用 percona 的工具完成修改, 所以在整个流程中分为以下步骤操作:…. Qtunnel 加密数据库主从复制通道 链接见: https:/ github.com/getqujing/qtunnel https:/ github.com/chenzhe07/qtunnel 背景 在异地机房的环境下, MySQL 数据同步复制基于 tcp 的明文传输, slave 接收到的 sql 语句可以很容易的被监听到, 对于敏感数据, 这种简单的异地复制是很...最近碰到一...
system – Arster's blog
http://highdb.com/category/system
My articles and thoughts. Common utilities for sysadmin/dba. Sys-toolkit Some useful scripts to sysadmins/dbas. read more from: https:/ github.com/chenzhe07/sys-toolkit toolkit lists: sys-genpass sys-nton sys-pubip sys-ascii sys-ipton sys-lock-run sys-repeat sys-checkport sys-echo-stderr sys-php-chroot sys-tcp-port-proxy sys-shell-type sys-memory-maps sys-mem-redis-summary sys-mysql-summary sys-mysql-adj sys-mysql-kill-blocked-thread sys-mysql-kill-long-query…. 重启 iptables 影响 nf conntrack 参数说明. 重启 iptabl...
» 2014中华架构师大会蓄势待发
http://www.zhdba.com/mysqlops/2014/08/08/2014中华架构师大会蓄势待发
Middot; Leave a comment. 本届会议官方报名网站 http:/ meeting.zhdba.com. 电话 136 5197 9898. 主持人 洪倍 职位名称 AdMaster联合创始人兼CTO. 公司名称 360 职位名称 资深研发工程师. 公司名称 阿里云 职位名称 TFS研发负责人. 演讲简介 TFS Taobao File System 是淘宝的分布式文件系统，主要用于海量文件存储，在阿里内部广泛应用。 公司名称 国药集团 职位名称 常务副总经理. 公司名称 金山网络 职位名称 移动游戏技术经理. 演讲简介 推送技术就是常见的 Web 服务器 推 技术, 用于向网页实时地推送数据。 最常见的 Comet 技术应用在网页聊天, 当然还可以应用于很多的方面, 如微博更新, 热点新闻推送, 股票即时行情等等, 甚至是网页游戏! 公司名称 惠普中国 职位名称 系统架构师. 公司名称 雪球财经 职位名称 CTO. 公司名称 中国联通 职位名称 大数据部总监. 公司名称 热璞科技 职位名称 技术总监. 公司名称 阿里巴巴 职位名称 高级技术专家.
TOTAL LINKS TO THIS WEBSITE
52
leaf magazine
Leaf is a creative writing magazine for new poetry and prose. see issue one online now! Thursday, 10 December 2009. Leaf issue two, '. Please email us at leaf.publication@gmail.com if you would like to purchase a hard copy of the magazine. . Thanks to everyone who attended the launch. . Thursday, 3 December 2009. Come to the launch of leaf issue two. Thursday, 5 November 2009. 171; CALL FOR SUBMISSIONS. We are looking for submissions for the next issue of leaf. Email: leaf.publication@gmail.com.
LEAF - Home
Fields marked with an asterisk (*) are required. Liberty Education Action Fund. We teach the principles behind the sound bites. We have a bias for. The dangers of internet voting. Internet voting is unsafe and rife with potential for fraud. Declaring Independence from governmental tyranny. Some today don’t even know what the 4. The Making of the Declaration of Independence. This Independence Day think about our founding principles. High taxes didn’t lead to Independence tyranny did. Liberty is our passion.
Whole Leaf Tobacco | Buy Tobacco Leaf, Fronto Leaf, Cigar Wrappers, Bulk Tobacco, and More!
WHOLESALE CUSTOMERS / AFFILIATES. VIEW YOUR SHOPPING CART. Tobacco Leaves By The Pound. Rolling Papers and Tubes. Fronto / Grabba Leaf Guide. Fronto / Grabba Tobacco Leaves By The Pound. Fronto / Grabba Tobacco Accessories. Fronto / Grabba Tobacco Seeds. Fronto / Grabba Tobacco Leaf Packs. Fronto / Grabba Tobacco Leaf Scraps. Fronto / Grabba Rolling Papers and Tubes. RYO / MYO Tobacco Leaf Cigarettes. Cigarette Tobacco Leaves By The Pound. Organic Cigarette Tobacco Leaves. Cigarette Tobacco Leaf Kits.
Leaf On My Head – a personal reminder
Leaf On My Head. Checklist for Creating a Good Game. May 5, 2011. March 11, 2012. Leaf On My Head. Despite I make following lists mainly to remind myself, I hope it would be helpful to someone as well : ). Each genre has its own vital features, don’t try to manipulate them if you don’t have very good reason to do so. According to my experience, missing only one vital feature can lead to failure of the game (cry). To make sure that wide range of people can enjoy the game, they should be able to select dif...
leafonsword.org
The Sponsored Listings displayed above are served automatically by a third party. Neither the service provider nor the domain owner maintain any relationship with the advertisers. In case of trademark issues please contact the domain owner directly (contact information can be found in whois).
Leaf on the Loose |
One Pot – Soups and Casseroles. Quick Breads, Breads and Crusts. Cakes, Cupcakes and Pies. A misty morning does not signify a cloudy day. Pellentesque adipiscing odio eu neque gravida vehicula. Ut ultricies diam vel est convallis non auctor dui scelerisque. Quisque at erat sem. Mauris suscipit porta commodo. Pellentesque mattis interdum nibh sit amet sodales. Curabitur euismod sem in dui cursus et faucibus leo dignissim. Integer non porttitor leo. Integer luctus adipiscing dui nec tempor&...August 5, 2008.
Green Grass On Tunnel
Green Grass On Tunnel. Minggu, 16 Oktober 2011. Akibat Enggan Menunaikan Puasa Ramadhan Mengenal Ajaran Islam Lebih Dekat Rumaysho.Com. Akibat Enggan Menunaikan Puasa Ramadhan Mengenal Ajaran Islam Lebih Dekat Rumaysho.Com. Kamis, 21 April 2011. Selasa, 18 Januari 2011. Tanya : apa beda ukuran ban motor 90/80, 90/90, 80/90 dst. ada jg yg pake standar 2.75 ato 3.00 dst? Tapi kalo dibandingkan antara 80/90 dgn 2.75, perasaan yg 2.75 lebih besar? Jawab : soal ukuran 2,50 dan 70/90 Bikin bingung ya? Jadi, ba...
leafonthesea | Circumnavigating the Globe. No big Deal.
Circumnavigating the Globe. No big Deal. Down She Goes… NO NOT THE SHIP! May 25, 2012. So I took my blog down… it was time, and I say that mostly because if you were lucky enough to read it on the internet, good for you. I’m going to add bits and pieces of my personal journal and some email correspondences and then (hopefully) make it a book. Look for it soon! All the Way Around! Search for an Adventure. Down She Goes… NO NOT THE SHIP! 8220;Sea” my adventures by date!
leafonthewind.net
Ce nom de domaine n'est pas disponible. Il a été enregistré via gandi.net. More information about the owner. Enregistrer votre nom de domaine. Chez Gandi, vous avez le choix sur plus d'une centaine d'extensions et vous bénéficiez de tous les services inclus (mail, redirection, ssl.). Rechercher un nom de domaine. Votre site dans le cloud? Découvrez Simple Hosting, notre cloud en mode PaaS à partir de 4 HT par mois (-50% la première année pour les clients domaine). It is currently being parked by the owner.
Leaf on the Wind - Home
Leaf on the Wind. Welcome to my site for intuitive divination readings! My name is Jean Carlos and I have known I was an intuitive empath for most of my life. I have also been "playing around" with various forms of oracle and tarot decks for over 25 years. I have used my empathy to help others I've run across at conventions and shows I have been vending at with my fantasy artist husband, Rob Carlos. With great success. Now let me use it to help you. Web page 2011 by Jean Carlos,. Create a free website.
