INSERT INTO sites(host) VALUES('openark.org') 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) openark.org 网站价值¥223,367(不含域名),MYIP.CN网站综合数据统计 - 域名,Alexa,PR,反向链接,关键字
  测网速 网站优化诊断 广告招商QQ3066631932 CodeForge最好的源码站!   手机测速 测速APP

  
                       

网站页面信息

标题:
描述:
关键字:
sponsored links:
连接:
图片:
网站历史:
sponsored links:

网站流量与估价

网站流量:
网站估价:  (注:不包含域名价值,不代表公司价值)

网站排名

Alexa全球排名:
Google Page Rank:
真假PR鉴别:   (提示:若此处显示网站与查询网站不同,则疑为劫持PR)
Sogou Rank:
百度快照日期:

搜索引擎收录

搜索引擎收录情况反向链接
 谷歌Google:
 百度Baidu:
 微软Bing:
 搜搜Soso:
 雅虎Yahoo:
 有道Youdao:
 搜狗Sogou:

服务器信息

Web服务器:
IP地址:    
IP所在地:

域名注册信息

注册人:
Email:
ICANN注册机构:
创建时间:
修改时间:
过期时间:
状态:
Name Server:
Whois Server:

Alexa 排名走势数据

流量统计: 当日 一周平均 三个月平均
排名:
PV:
日独立IP:

网站在各国/地区的排名

国家/地区访问比例

下属子站点被访问比例

Alexa 排名走势图

Alexa Reach走势图

域名 Whois 记录

网站缩略图

sponsored links:

网站访问速度测试

国内Ping速度测试      国内TraceRoute路由测试
美国Ping速度测试      美国TraceRoute路由测试

网站关键字指数 (越高越热门)

域名 openark 其他后缀注册情况   查看更多

后缀 注册时间 到期时间 是否注册
.com
.net
.org
.cn
.com.cn
.asia
.mobi

同类相似网站

查看更多

模拟搜索引擎蜘蛛抓取

Title:Blog by Shlomi Noach | code.openark.org
Description:Blog by Shlomi Noach
Keywords:Blog by Shlomi Noach
Body:
Blog by Shlomi Noach | code.openark.org
Log in
Subscribe RSS Feed
code.openark.org
Blog by Shlomi Noach
Home
Meetings
Shlomi Noach
יעוץ
Search
About me
Name: Shlomi Noach
Location: Israel
I am a DBA, consultant and an authorized MySQL instructor. A developer (mainly C/C++, Java, Web) and code architect.
I provide MySQL consulting services in Israel and world wide, and am available for hire.
Recent Posts
Oracle week 2010 in Israel: not a single MySQL session
openark-kit, Facebook Online Schema Change, and thoughts on open source licenses
Tool of the day: autossh
Three wishes for a new year
mycheckpoint (rev. 190): HTTP server; interactive charts
Similar Posts
Personal observation: more migrations from MyISAM to InnoDB
`;`.`*`.`.` is a valid column name
What I look forward to hear on #8220;State of the Dolphin #8221;, 2010
Even more on MySQL password security
MySQL User Group Meetings in Israel
Archives
September 2010
August 2010
July 2010
June 2010
May 2010
April 2010
March 2010
February 2010
January 2010
December 2009
November 2009
October 2009
September 2009
August 2009
July 2009
June 2009
May 2009
April 2009
March 2009
February 2009
January 2009
December 2008
November 2008
October 2008
June 2008
Blogroll
MySQL Monitoring
openark forge
Planet MySQL
יעוץ MySQL
Categories
Development (RSS) (4)
MySQL (RSS) (131)
OpenOffice (RSS) (1)
Meta
RSS 2.0 Feed
Atom Feed
Comments RSS Feed
Log in
Valid XHTML
Tag Cloud
Analysis
Backup
Books
Configuration
Data Types
Development
Event Scheduler
Execution plan
Graphs
Humor
Indexing
INFORMATION_SCHEMA
InnoDB
Installation
Java
Linux
logs
Math
memcached
Monitoring
mycheckpoint
MyISAM
mysqlconf
mysqldump
Normalization
NoSQL
openark kit
Open Source
Opinions
Performance
Planet
python
Query Cache
Replication
Schema
scripts
Security
Sphinx
SQL
sql_mode
Stored routines
Syntax
Triggers
User Group
Web
Oracle week 2010 in Israel: not a single MySQL session
September 19, 2010
Development, Middleware, [Oracle] Database, BI, ERP, CRM, SCM, EPM, SOA amp; BPM, Java, Security #8212; all these and more are on the schedule. No MySQL track, not a single MySQL session.
Lack of speakers? Hardly. Lack of public interest? I can #8217;t imagine.
Then what is it? I have no information, and don #8217;t want to throw around suggestions.
Reading the convention #8217;s objectives, I see nothing to suggest why MySQL would not be in. Heck, there #8217;s even two new special seminars: #8220;Family Economy #8221; and #8220;Career planning #8220;.
Sorry, not providing a link this time (besides, it #8217;s all Hebrew). If you #8217;re eager to look it up, google for #8220;Oracle week Israel #8221;.
It #8217;s a shame, and makes it harder to answer the #8220;so what do you think Oracle will do to MySQL? #8221; question I get to be asked ever so often.
tags: Opinions, Oracle posted in MySQL by shlomi | 3 Comments
openark-kit, Facebook Online Schema Change, and thoughts on open source licenses
September 16, 2010
MySQL@Facebook team have recently published an Online Schema Change code for non blocking ALTER TABLE operations. Thumbs Up!
The code is derived from oak-online-alter-table, part of openark-kit, a toolkit I #8217;m authoring. Looking at the documentation I can see many ideas were incorporated as well. And of course many things are different, a lot of work has been put to it by MySQL@Facebook.
openark-kit is currently released under the new BSD license, and, as far as I can tell (I #8217;m not a lawyer), Facebook #8217;s work has followed the license to the letter. It is a strange thing to see your code incorporated into another project. While I knew work has begun on the tool by Facebook, I wasn #8217;t in on it except for a few preliminary email exchanges.
And this is the beauty
You release code under open source license, and anyone can pick it up and continue working on it. One doesn #8217;t have to ask or even let you know. Eventually one may release back to the community improved code, more tested (not many comments on oak-online-alter-table in the past 18 months).
It is a beauty, that you can freely use one #8217;s patches, and he can then use yours.
And here is my concern
When I created both openark-kit and mycheckpoint, I licensed them under the BSD license. A very permissive license. Let anyone do what they want with it, I thought. However Facebook #8217;s announcement suddenly hit me: what license would other people use for their derived work?
The OSC has been release under permissive license back to the community (again, I am not a lawyer). But, someone else could have made it less friendly. Perhaps not release the code at all: just sell it, closed-source, embedded in their product. And I found out that I do not want anyone to do whatever they want with my code.
I want all derived work to remain open!
Which is why in next releases of code I #8217;m authoring the license will change to less permissive and more open license, such as GPL or LGPL. (Of course, all code released so far remains under the BSD license).
tags: mycheckpoint, Open Source, openark kit, Opinions posted in MySQL by shlomi | 7 Comments
Tool of the day: autossh
September 13, 2010
Maybe I #8217;m like an old replication server, lagging way behind, but a couple of weeks ago I found autossh, which is a wrapper around ssh, that keeps reconnecting the session if it breaks.
With public key encryption, I am now able to work out pretty reliable SSH tunneling among servers, which doesn #8217;t break. It seems to be working well during these couple of weeks. And it #8217;s in my favorite distro #8217;s repository
I suppose use cases are as many as those for SSH or SSH tunneling, and I #8217;m putting it to an interesting use. But I suppose the most obvious use in the MySQL world would be to encrypt client connections over unsafe network, or make the network more reliable, for that matter. Yes, there #8217;s SSL connections, but opening your 3306 port on your firewall? Too risky for my taste.
tags: Security posted in MySQL by shlomi | 6 Comments
Three wishes for a new year
September 9, 2010
It #8217;s a new year by Jewish calendar (and, incidently, today is the first day of the next 365 days). And what do I wish for in the following year?
World peace
Good health to all
Support for ORDER BY amp; LIMIT in MySQL multi-table UPDATE and DELETE statements, This is sometimes a real show stopper!
Have a good year / next 12 months everyone!
tags: SQL posted in MySQL by shlomi | 5 Comments
mycheckpoint (rev. 190): HTTP server; interactive charts
September 7, 2010
Revision 190 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision:
HTTP server: mycheckpoint can now act as a web server. Point your browser and start browsing through HTML reports. See mock up demo.
Interactive charts: HTML line charts are now interactive, presenting with accurate data as you move over them. See sample.
Enhanced auto-deploy: now auto-recognizing failed upgrades.
Reduced footprint: much code taken out of the views, leading to faster loading times.
Better configuration file use: now supporting all command line options in config file.
Remote host monitoring accessibility: now supporting complete configurable accessibility details.
Bug fixes: thanks to the bug reporters!
mycheckpoint is free, simple, easy to use (now easier with HTTP server) and useful. I encourage you to try it out: even compared with other existing and emerging monitoring tools, I believe you will find it a breeze; it #8217;s low impact and lightness appealing; it #8217;s alerts mechanism assuring; its geeky SQL-based nature with ability to drill down to fine details #8212; geeky-kind-of-attractive.
lt;/encouragement gt;
HTTP server
You can now run mycheckpoint in http mode:
bash$ strongmycheckpoint httpstrong
mycheckpoint will listen on port 12306, and will present you with easy browsing through the reports of your mycheckpoint databases. Continue Reading raquo;
tags: Monitoring, mycheckpoint, Open Source, python, scripts, Web posted in MySQL by shlomi | 1 Comment
Sphinx #038; MySQL: facts and misconceptions
September 2, 2010
Sphinx search is a full text search engine, commonly used with MySQL.
There are some misconceptions about Sphinx and its usage. Following is a list of some of Sphinx #8217; properties, hoping to answer some common questions.
Sphinx is not part of MySQL/Oracle.
It is a standalone server; an external application to MySQL.
Actually, it is not MySQL specific. It can work with other RDBMS: PostgreSQL, MS SQL Server.
And, although described as #8220;free open-source SQL full-text search engine #8221;, it is not SQL-specific: Sphinx can read documents from XML.
It is often described as #8220;full text search for InnoDB #8221;. This description is misleading. Sphinx indexes text; be it from any storage engine or external source. It solves, in a way, the issue of #8220;FULLTEXT is only supported by MyISAM #8221;. Essentially, it provided full-text indexing for InnoDB tables, but in a very different way than the way MyISAM #8217;s FULLTEXT index works.
Sphinx works by reading documents, usually from databases. Considering the case of MySQL, Sphinx issues a SQL query which retrieves relevant data (mostly the text you want to index, but other properties allowed). Continue Reading raquo;
tags: Open Source, Sphinx posted in MySQL by shlomi | 8 Comments
mylvmbackup HOWTO: minimal privileges #038; filesystem copy
August 17, 2010
This HOWTO discusses two (unrelated) issues with mylvmbackup:
The minimal privileges required to take MySQL backups with mylvmbackup.
Making (non compressed) file system copy of one #8217;s data files.
Minimal privileges
Some just give mylvmbackup the root account, which is far too permissive. We now consider what the minimal requirements of mylvmbackup are.
The queries mylvmbackup issues are:
FLUSH TABLES
FLUSH TABLES WITH READ LOCK
SHOW MASTER STATUS
SHOW SLAVE STATUS
UNLOCK TABLES
Both SHOW MASTER STATUS amp; SHOW SLAVE STATUS require either the SUPER or REPLICATION CLIENT privilege. Since SUPER is more powerful, we choose REPLICATION CLIENT.
The FLUSH TABLES * and UNLOCK TABLES require the RELOAD privilege.
However, we are not done yet. mylvmbackup connects to the mysql database, which means we must also have some privilege there, too. We choose the SELECT privilege.
Continue Reading raquo;
tags: Backup, Linux, Open Source, scripts, Security posted in MySQL by shlomi | 2 Comments
MMM for MySQL single reader role
August 12, 2010
The standard documentation and tutorials on MMM for MySQL, for master-master replication setup, suggest one Virtual IP for the writer role, and two Virtual IPs for the reader role. It can be desired to only have a single virtual IP for the reader role, as explained below.
The two IPs for the reader role
A simplified excerpt from the mmm_common.conf sample configuration file, as can be found on the project #8217;s site and which is most quoted: Continue Reading raquo;
tags: Configuration, High availability, Open Source, Replication posted in MySQL by shlomi | 3 Comments
Table refactoring #038; application version upgrades, Part II
August 12, 2010
Continuing Table refactoring amp; application version upgrades, Part I, we now discuss code amp; database upgrades which require DROP operations. As before, we break apart the upgrade process into sequential steps, each involving either the application or the database, but not both.
As I #8217;ll show, DROP operations are significantly simpler than creation operations. Interestingly, it #8217;s the same as in life.
DROP COLUMN
A column turns to be redundant, unused. Before it is dropped from the database, we must ensure no one is using it anymore. The steps are:
App: V1 - gt; V2. Remove all references to column; make sure no queries use said column.
DB: V1 - gt; V2 (possibly failover from M1 to M2), change is DROP COLUMN.
DROP INDEX
A possibly simpler case here. Why would you drop an index? Is it because you found out you never use it anymore? Then all you have to do is just drop it.
Or perhaps you don #8217;t need the functionality the index supports anymore? Then first drop the functionality:
(optional) App: V1 - gt; V2. Discard using functionality which relies on index.
DB: V1 - gt; V2 (possibly failover from M1 to M2), change is DROP INDEX. Check out InnoDB Plugin here. Continue Reading raquo;
tags: Development, Indexing, Replication posted in Development, MySQL by shlomi | No Comments
Another Python MySQL template
August 11, 2010
Following up on Matt Reid #8217;s simple python, mysql connection and iteration, I would like to share one of my own, which is the base for mycheckpoint amp; openark kit scripts.
It is oriented to provide with clean access to the data: the user is not expected to handle cursors and connections. Result sets are returned as python lists and dictionaries. It is also config file aware and comes with built in command line options.
I hope it comes to use: my.py
tags: Open Source, python, scripts posted in MySQL by shlomi | No Comments
laquo; Previous
Powered by Wordpress and MySQL. Theme by openark.org

数据更新时间

正在更新   

常用工具

桌面软件: MyIP网站信息状态条  WebShot网页快照  SiteMapMaker网站地图生成 
网站信息: Alexa排名查询  PageRank查询/真假PR鉴别/PR劫持检测  外链检查  搜索引擎收录  搜索引擎反向链接  域名注册查询 
网页编辑: 颜色代码选择器  Html特殊符号 
网站调试: 蜘蛛抓取模拟  网站Header信息  网页源代码查看 
代码转换: 火星文查询  繁体/简体转换  Html/js代码转换  Html/UBB代码转换 
友情连接: CodeForge免费源码 CodeForge.com PCFans IT资讯 Ngnix Lighttpd GPhone中国    更多... (PR<5自动转内页)
网站地图: 1 2 3 4 5 6 7 8 9 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 250 300 350 400 450 500
免责声明 | 联系我们 | 交换友情链接 | 广告位招商QQ: 1967659002
© 2009 MyIP.cn Dev by MYIP Elapsed:51.678ms 黑ICP备09072263号