123
 123

| ǽ FlickrFirefox Access Flickr

2008-04-29 Tue

17:01 EXP在9R2上导出时报错ORA-3113和ORA-24324(二) (585 Bytes) » yangtingkun
今天同事在导出的时候碰到了错误,EXP的过程中出现了ORA-3113和ORA-24324错误。EXP在9R2上导出时报错ORA-3113和ORA-24324:http://yangtingkun.itpub.net/post/468/460647继续分析错误情况。本来认为这个错误已经绕过去了,没想到的是,导入过程中又出现了错误:$ imp system file=jg080424.dmp buffer=20480000 fromuser=shgov touser=jsgov_old ignore=y grants=n Import: Release 9.2.0.4.0 - Production on 星期四 4月 24 16:25:57 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Password: Connected to: O...
17:01 EXP在9R2上导出时报错ORA-3113和ORA-24324(二) (585 Bytes) » yangtingkun
今天同事在导出的时候碰到了错误,EXP的过程中出现了ORA-3113和ORA-24324错误。EXP在9R2上导出时报错ORA-3113和ORA-24324:http://yangtingkun.itpub.net/post/468/460647继续分析错误情况。本来认为这个错误已经绕过去了,没想到的是,导入过程中又出现了错误:$ imp system file=jg080424.dmp buffer=20480000 fromuser=shgov touser=jsgov_old ignore=y grants=n Import: Release 9.2.0.4.0 - Production on 星期四 4月 24 16:25:57 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Password: Connected to: O...
15:41 Thoughts on SSDs in Production (3485 Bytes) » Fenng's shared items in Google Reader

We’ve had our SSDs in production for more than 72 hours now. We’ve had them in a slave role for nearly a week but they’ve now replaced existing hardware including the master.

The drives are FAST. In our production roles they’re reading at about 45MB/s and writing to disk at about 15MB/s and using only about 22% of disk utilization.

Not too bad.

We also have about 70GB free on these drives so that leaves plenty of room to grow.

There was small problem that I didn’t anticipate.

When we were running our entire disks out of memory we would only use one or two indexes per column. We had a set of reporting tasks which ran some queries once every 5 minutes.

The columns these queries were using didn’t have any indexes so InnoDB CPU would spike for a moment and continue.

Modern machines have memory bandwidth of about 15GB/s so these queries were mostly CPU bound but completed in a few seconds.

When we switched over to SSDs all of a sudden these queries needed to perform full table scans and were reading at about 100MB/s for two minutes at a time.

Fortunately, an ALTER TABLE later and a few more indexes fixed the problem.

We dropped the indexes when we were running out of memory because the queries could be resolved so quickly. Now that they were on disk again we had to revert to the olde school way of doing things.

14:52 Interview: Anaconda and Fedora 9 (9017 Bytes) » Red Hat Magazine

In this installment of our co-published Fedora Interviews, Jeremy Katz, David Cantrell, and Chris Lumens talk about the improvements to Anaconda in Fedora 9.

What motivated you work on Anaconda for Fedora 9?

Jeremy Katz: Well, it’s part of most of our jobs :-) We’re full-time employees with Red Hat and have the installer as one of areas that we tend to work on.

David Cantrell: Anaconda is the first program that people will use when they use Fedora for the first time. We are the first impression of the OS, and we are always trying to improve that experience and make Anaconda do what people are wanting.

Chris Lumens: It’s my job to work on Anaconda, so that was all the motivation I needed. Actually it was pretty nice to work on F9 Anaconda, as it was a chance to step away from the bug-fixing grind and work on some new stuff.

Could you explain more about new features in Anaconda? What’ll be the first impression for users?

Jeremy Katz: There’s a fair bit of new stuff this time around. The most obvious thing will probably be that some of the steps have been moved around with partitioning being later. There’s also support for partition resizing, encrypted partitions, and a whole lot more.

David Cantrell: Improved yum repository handling during installation.

Chris Lumens: As Jeremy said, the first impression will probably be that the steps have moved around. Partitioning now happens before package selection, which should surprise a fair number of people. I’m working on a brief presentation about what we’ve done in F9 and our reasoning behind it, but most of it’s aimed at developers and regular users won’t ever encounter those changes.

What’s important about the change from boot.iso to netinst.iso?

Jeremy Katz: The main benefit is that it lets us move more of the “hard” stuff into the second stage of the installer, as we can guarantee it’s available more often. This opens the door for better support of retrying downloads, editing repositories, proxies, mirror lists and more. It also helps with the (mistaken) impression that we don’t have an easy way to start off a network installation.

Chris Lumens: Jeremy’s exactly right here. From the developer point of view, it also got rid of a ton of code, simplifying the maintainence and development burden. This should translate into fewer bugs in the future.

Why did the work to support resizing NTFS partitions happen?

Jeremy Katz: It’s been a long-standing feature request. We’ve been waiting on support to land in some of the libraries we use for a long time, but we finally decided to bite the bullet and just do the implementation in Anaconda-land. We hope it will make the transition for someone who is new to Fedora easier and not require them to run Partition Magic or some other third-party utility to set up for installation. I posted a pretty good movie showing the resize UI in action.

David Cantrell: NTFS won’t be enough; someone will ask for HFS+ resizing from within Anaconda. :)

Chris Lumens: I like to look at this as a sort of impulse sale. If you get the live CD into a potential new user’s hands, and they can boot it up, play around with it, and like what they see, they may have the desire to install it right that second and get to using Fedora. Before having NTFS partition resizing support, they would have to reboot, redo their partitioning, and then install Fedora. That’s a pretty high hurdle, and I think we lose a lot of people there. Now they can just resize right from within the live CD and be running Fedora a lot faster.

What does allowing the user to set the second stage source actually mean?

Jeremy Katz: Realistically, this isn’t something we expect an end-user to care about, but it helps enabling other things, such as preupgrade and some of the netinst.iso benefits mentioned above.

Chris Lumens: For the user, it really only means better support for recovering from errors. So if your HTTP repository disappears before installing packages or a package download is corrupt, we can handle these cases better. Most users won’t ever really know that they’re specifying the stage2 location, nor will they care.

What are the benefits of udev and HAL hardware probing and detection instead of kudzu?

Jeremy Katz: We’re now using the same stack as the rest of the OS. This has its ups and its downs, as kudzu was tailored to Anaconda’s needs. But it should let us have more consistent information about what a device is named, etc throughout the user experience.

Chris Lumens: Right. The biggest benefit for users is that we (Anaconda developers) will be spending less time chasing down bugs in device detection code and more time chasing down bugs in Anaconda itself. Using the same stuff as the rest of the system frees up a lot of our time to work on more interesting problems.

What does native EFI support buy us?

David Cantrell: Booting on Intel Macs without needing the MBR shim.

How’s the work going on getting this ready to be easily available for Fedora 9?

Jeremy Katz: We’re making a lot of progress. There’s still a lot of testing and bug fixing to go so that we can have as solid of a release as we can. Any testing that can be provided through the betas, the snapshots and the preview release goes a long way.

David Cantrell: Trying to get users other than ourselves to test out the nightly trees or betas is really difficult. We’ve got some things in place now to make that easier, but still actually getting people to test the installation is difficult.

Chris Lumens: The hard stuff is done, but I’m sure there are plenty of bugs still around. There are always bugs hiding in the corner cases, especially with the amount of stuff we have changed for F9. More testing and testing earlier on will be a big help in making sure no serious problems make it into the release.

And to finish, you could tell us a little bit about yourselves? What got you interested in free software originally? What do you like to do with your spare time when you’re not working with computers?

Jeremy Katz: I’ve been involved in free software and distro development for many years now… originally it was to learn and it’s grown a bit from there. As far as spare time, I have that? ;-) I’m actually a pretty avid cyclist and am also currently attending a graduate program at MIT while continuing to work at Red Hat on all things Fedora.

David Cantrell: Free software development was interesting to me, and it was similar to the platforms I was using at school (mostly SunOS). I’ve been doing some form of FOSS work for a long time.

Chris Lumens: I’ve been working with Linux for quite a while now, originally just to play around with and make the computer do something more interesting. I think the original reason was to play Doom via TCP/IP. Something like that. Eventually it turned into a broader interest in computers and programming, then into a way to make a living. It’s a pretty good way to spend your work day.

In my spare time I am an active hiker (White Mountains, mostly) and homebrewer. Sometimes I read really dense books.

13:45 矛和盾 (2068 Bytes) » Fenng's shared items in Google Reader
可能在很多国内的互联网公司都存在这样的以己之矛攻己之盾的现象, 公司里负责用户体验设计的团队一方面千方百计地设计新奇的舒适的用户体验, 而另外一方面负责销售的团队却不停地提出各种扰民的所谓广告创意, 在用户享用美好体验的同时去干扰这样的体验. 于是就看到两个团队在不停地讨价还价, 一方觉得广告的形式太恶心, 而另外一方却又始终觉得广告不够多. 而公司的管理层却因为收入方面的压力往往会站在销售团队一边. 并且很多时候他们可能并不觉得他们自己做错了什么, 因为他们觉得收入压力理所当然是第一要务, 当然要首先解决收入问题.

这样的情况很让人难受, 因为公司里面的每一个人都会觉得一切都让自己不满意. 设计师会觉得自己的想法在被扭曲, 销售团队会觉得这些设计师不食人间烟火, 管理层会觉得员工没有团队意识?

而所谓的"收入压力"这样的玩意的来源是什么呢?

在我看来恐怕是因为这家公司的这项事业在开始之前没有想清楚自己究竟要的是什么. 如果要的就是更多的钱, 那么这个世界上比互联网更靠谱的赚钱手段也不是没有. 如果要的是美好的用户体验, 那么就应该忘记广告, 让用户直接为了美好体验付钱. 比如日本最大的视频网站 ニコニコ 不就是直接向用户收费的么? 如果担心一下子从用户那里收不到太多钱, 那么就不要把摊子铺那么大, 大到最后钱也没有, 用户体验更是什么都没有了.

在过去的一年里算是见识到了相当多的莫名其妙的事情.[ read more on livid.cn ]
10:31 How not to do it... (1475 Bytes) » The Tom Kyte Blog

Two years ago at Oracle Open World, I delivered a "worst practices" talk - how not to do stuff.  I used the word "probably" a lot, for example "you probably don't need to use bind variables" (there were slides stuck in this slide deck throughout that said 'hey, these are all the opposite of reality - just in case you are reading this - they are not true!').

In the same genre - we have "Top Ways How NOT To Scale Your Data Warehouse".  This comes from the Structured Data blog penned by Greg Rahn - that article as well as the others make for some really good reads.

While I'm pumping that blog - another one to definitely look at is Richard Foote's blog.  He's been undertaking the destruction of many a myth regarding indexing (like 'indexes like large blocks', 'rebuild when height hits N', 'Separate tables from indexes for performance' and the like).  Very easy to read, very enjoyable to read.

If you use multiple computers like I do - you might be interested in http://www.instapaper.com/ - find something you like, but don't have time to read right now - save it for later.  Very nice.

07:30 技术团队新鲜人 (3589 Bytes) » DBA notes

作者:Fenng 发布在 dbanotes.net. FeedBurner 订阅数量,点击则可进行订阅

今天随公司团队活动蹭饭。和以往项目庆祝之类的饭局不同的是,这次是为了实习生团队毕业的庆祝。

看着朝气蓬勃的这群新鲜人,挺有感慨。自己也曾经和他们一样,毕业后满怀憧憬地杀入职场。只是到第一家单位报到的时候可没这些准同事这么幸运了。当时可没听说什么"职场融入",也没有什么"馒头(Mentor)",两眼一抹黑。公司的总经理当着我的面,称呼我的部门经理,"钱总",害得我"钱总"、"钱总"的喊了好长时间。对我来说,一直都认为这是一个比较失败的职场开场白...

放眼看去,现在同事当中, 80 后越来越多。其实大多数 80 后和 70 后没啥差别的,自己当年的困惑他们肯定也有,能和他们多做点沟通、多做点分享还是比较有意思的事情。

遇到好多好学的家伙,每每和他们一聊就是半天。我开玩笑说,和刚毕业的新同事交流其实我挺怕的:最怕问问题我回答不上来;如果能回答的话,担心回答错了;回答错误不要紧,最怕回答错误被对方指出来。

--EOF--

相关文章|Related Articles

评论数量(3)|Add Comments

本文网址:
最近作者还说了什么? Follow Twitter / Fenng

07:12 Yahoo Outsources IM Calls To JaJah (241 Bytes) » Fenng's shared items in Google Reader
"Jajah will connect the calls to and from users of Yahoo Messenger and handle billing and customer care, the startup said Tuesday."
05:58 Wigix Brings Order to World of Online Trading (4681 Bytes) » Fenng's shared items in Google Reader

Shopping on eBay is more like navigating a street marketplace than visiting a department store. Disparate vendors sell their wares without any real coordination. As a result, buyers must visit each and everyone of them to ensure that they’re getting the best deal. And with each visit, they must cope and make sense of new advertising spins and types of service.

Wigix launches in public beta today with the intent to standardize online marketplace listings, and consequently make it easier for consumers to find the products they desire. Its SKU-based system (SKU, as in the fact sheets used to describe inventoried items) forces sellers to group their goods with others who are selling essentially the same product. This allows buyers to get a more complete overview of their options, and it allows for many other opportunities as well.

For example, with the SKU system, buyers and sellers can search for item listings using more intelligent search. Type “ipod” into Wigix’s search, and it will automatically suggest all the possible iPod models that one can sell and buy through the site. The search results don’t show actual items for sale, but types of items (”Apple iPod photo 160GB” or “Apple iPod mini 4GB”). It’s only once you click on one of these results that you can see who’s selling it.

Each SKU page shows not only the current sellers but general overview information for the product as well. This includes the current market value, the recent changes in that value, reviews, specs, and more. Users who own the product but haven’t officially put it on sale can list themselves as owners just in case someone wants to come along and make them an offer they can’t refuse. This Zillow-make-me-move-like feature should change the way many people view their possessions (not just dead items but stores of exchangeable value).

Wigix can also track how prices for goods change over time, which in addition to the bid/ask aspect of the site, makes it operate very much like a stock exchange.

The service’s biggest hurdle, of course, will be to draw enough vendors and shoppers away from eBay. It’s hoping its pricing structure will produce the right incentives to do that. There is no cost to list items under $25. Between $25-100, the site takes one dollar from the buyer and one from the seller. And for more expensive items, it claims an additional 2% of the sale price.

Wigix also supports its operations by running targeted advertisements on SKU pages, such as ones for items on Amazon. Since Wigix is a place only for identifiable goods (no collectibles here, at least yet), it’s easy to serve up ads for the same products found elsewhere on the net.

Information provided by CrunchBase

Crunch Network: CrunchGear drool over the sexiest new gadgets and hardware.

2008-04-28 Mon

23:47 也谈CPU和GPU之间的关系:融合、取代还是共存? » Fenng's shared items in Google Reader
23:17 Mysql server Sanspoof having problems » Fenng's shared items in Google Reader
22:41 三言二拍:搜狐会不会成为第二个网易 » Fenng's shared items in Google Reader
22:40 Topview与数据仓库 » Oracle & Starcraft
22:40 Topview与数据仓库 » 淘宝数据仓库团队
22:40 Topview与数据仓库 » Fenng's shared items in Google Reader
21:32 2003年以来网页尺寸增长3倍 » Fenng's shared items in Google Reader
20:52 D2 · 会议及看法 » Fenng's shared items in Google Reader
20:50 MySQL Replication vs DRBD Battles » MySQL Performance Blog
20:31 昨晚失眠了 » Brotherxiao's Home
19:48 系统管理工具包: 理解 DNS » Fenng's shared items in Google Reader
17:31 2008的职业转换 Work from home » Orange Tiger 木匠 的 移民生活
17:12 5个步骤让你的Blog文章更加专业 » 生活帮-LifeBang
14:31 IBM Tivoli Directory Server 6.0 的 SSL 配置 » developerWorks : AIX 专区的文章,教程
12:01 The 'write' stuff... » The Tom Kyte Blog
11:49 AskTom Search Engine Plugin Revived » Eddie Awad's Blog
11:34 要劳动的劳动节,真美好! » OracleDBA Blog---请享受无法回避的痛苦!
06:53 一条Mysql上的Sql优化经历 » Alibaba DBA Team
06:51 我的假期 我的关注 » Oracle Life
06:36 选择 » Think in 88
05:07 HASH GROUP的调整 » Alibaba DBA Team
03:27 如何编写兼容各主流邮箱的HTML邮件 » Fenng's shared items in Google Reader
03:01 系统管理工具包: 理解 DNS » developerWorks : AIX 专区的文章,教程
00:17 微软放弃收购雅虎猜想:杨致远代价不菲的胜利 » Fenng's shared items in Google Reader

2008-04-27 Sun

23:05 前端开发 IE 中的常用调试工具 » Fenng's shared items in Google Reader
23:02 无题 » eagle's home
17:43 Improved Cacti monitoring templates for MySQL » Fenng's shared items in Google Reader
17:02 ORA-7445(krdsodrf)错误 » yangtingkun