Can you? I seem to remember not being able to do that. It could just be the version I was using though. I meant that it is a huge thing for me because I use it very often.
Just to put this into perspective, a little dual Xeon box here does more than 5 million *INSERTs* every day and a large number of SELECTs (we update each of our currently 2.4 million product prices at between 1 and 20 times per day - the exact number of INSERTs per day is currently unknown to me).
Just to put that into perspective, I know at least one of our MySQL databases has done over 100 million queries in one day while loading genomic mapping data into our system. That equated to about 7-10 million inserts, the rest selects. That was also running on a dual Xeon (~2.4Ghz, a Dell PowerEdge 2600). It was averaging about 1400 queries a second, topping out at over 3000 at times.
Um no. It's not enough to just lock out access and take a snapshot; you need to lock out users, tell the DB to flush to disk and THEN snapshot.
Not that hard, here is the procedure:
Execute the following mysql command:
FLUSH TABLES WITH READ LOCK;
Then (while maintaining the DB connection) take your snapshot. When the snapshot is done, drop the DB connection and the read lock will be released (or issue an UNLOCK TABLES command).
Those who have no choice and use open source projects that use it (e.g. www.ensembl.org) and/or those who deal with mostly read-only databases. Its not as bad as you make it out to be, and is good for some projects.
It is generally faster than Postgres,
It handles large datatypes more easily than Postgres (although Postgres, while odd, has some more flexibility)
Postgres has an odd 8k limit per row (probably fixed by now though)
Supports selects across databases.
It has good replication support (with 4.x and later)
Comes with some good admin tools in the normal distro.
Decent full text indexing out of the box
It is really about choosing the right tool for the job, each has their advantages and disadvantages.
IR is so totally hackable. You'd just make the "Universal Remote" record the IR strobe sequences for each button and then play them back. And that technique works even if they make a different remote for each individual television.
That assumes that two way communication is not enabled with the remote, like the rolling codes that car alarms use. Two way communication would actually be handy, think about PVRs sending state information to the remote so it can reconfigure its buttons or be an auxiliary display.
'm majorly antispam, but it seems to me that getting junk email and listening to junk from a blaring TV is about the same thing. You own neither TV nor the senders mail server, but you still take action to protect your personal space/inbox.
Not a good analogy: you own your computer that you use to view the spam and where you install the anti-spam software. You do not own the TV, the property that the TV is on and you share the TV with others that like the 'spam'
The anti-spam for TV would be blinders and ear plugs. The TV-B-Gone for spam would be a device that let anyone shutdown any SMTP server that was sending them mail they didn't want to receive, regardless of what it is and who else was using the server. Still, a TV-B-Gone would be fun, if not quite ethical.
Not only is she able to operate it, she took complete control of it.;-)
Tell me about it, my girlfriend is slowly taking over my TiVO. At first she thought it was way to expensive and couldn't understand why I bought it. Now she complains that I record too many of my shows; she hasn't seen me watch 'Mythbusters' in a while so I should remove its Season Pass so her 'The Appretice' has more room. Women.
When did I say he did? Always refreshing to see an AC attack. I was talking about 'mistakes' and apologizing about them. Learn to actually be able to comprehend what you read and be able to think before you post.
One shouldn't have to take sides on an issue of fact, and the fact was that the documents were frauds. But the Democrats never let facts get in the way calling people conspiratorial nutbags.
s/Democrat/politician/g and then you have an unbiased version of the statement. Otherwise all you are doing is attacking one side explicitly and implying the other side is clean.
Yes, I know there are other sides but in this case, when someone is attacking a Democrat or Republican it strongly implies a support for the other side.
I'm still waiting for an apology from all those people who called me a conspiratorial nutbag for doubting the authenticity of those memos in the beginning. Of course I'll never get one, because it's against the Democrat code of honor to admit a mistake. "It's not our fault! Karl Rove did it!"
Pot calling the kettle black. How many times has Bush dodged the mistake question?
I'm still waiting for the studies about power lines and cancer to look for soil contaminants.
I read not too long ago about a UK study that found that an increase in some cancers came from living near power lines might be from the powerlines giving air pollution a charge and the charge causing the particles to stick in the lungs better. Ah, found the BBC story. Still under study but does make some sense.
I'm sure they wouldn't use hydrogen, but that still begs the question of how these will affect the worlds helium supply. Probably not that much, but from what I have read it comes from limited places (mostly Texas) and once has a tendency to escape into space once it is out of the ground. I have to imagine having lots of these large helium balloons will not help matters.
There's actually at least 5 degrees of freedom.
According to the article, the kid can move a cursor and cause clicks by dwelling on the cursor. That means UP, DOWN, LEFT, RIGHT, and CLICK.
As someone else pointed out, the up/down combination is only one degree of freedom, so in this case we have two degrees of freedom with almost a half of a third ("dwelling on the cursor"?).
The six degrees of spacial freedom (I'll skip the Kevin Bacon jokes) break down into the three translational degrees of freedom (up/down, left/right and forward/backward) and the three rotational degrees of freedom (pitch, yaw and roll, each one rotating around one of the three axes).
Bass Ale seems to sell quite well despite it being brewed with hard water.
I doubt they use unfiltered tap water. I would be it is at least reverse osmosis filtered and probably has other additives to make it taste better. Scarily enough the plant where Bass is brewed is now owned by Coors Brewers Ltd.
And don't forget that they are litigious bastards as well. Actually, if you look up litigious bastards it brings up SCO, but an interesting side effect is that if you look up bastards, SCO also shows up. Can you believe that? Bastards? Who'd have though?
Hey, I'm a bastard and I don't like being lumped with the likes of SCO.
If you think that the "masses" are "vegetative", it's not clear why you want democracy at all! And how can you trust the political class to regulate what the "masses" can hear? Won't they just try to manipulate for their own interests?
Touché, but I would rather the masses be somewhat informed with some non-arbitrary and non-biased (eg, if one side has 10 minutes, then so does the other side) system to control it. A pipe dream I know, but something to strive for and I believe better than nothing.
"Campaign finance" is a proxy for regulating speech. It's what the political class is using to stifle criticism. There are jail terms associated with broadcasting a political message that regulators do not approve of, now. The framers must be turning over in their graves.
This is the very speech that the 1st amendment was designed to protect. Not nude dancing, not obscenity, not flag burning, but political speech is what they were trying to protect. How can the 1st amendment be so expansive as to include those other things, but not the intended object of protection?
I'm not saying that I completely disagree with you and our current campaign finance laws are very broken, but we have some fundamental problems with totally unregulated free speech. When the constitution was framed, most news was word of mouth, candidates actually debated *each other* and there was no TV spreading any message that anyone with money wants to the vegetative masses.
With out some form of regulation we would end up with the people with the deepest pockets being the people that completely control what the general population knows (which we suffer from now, but no where near as bad as it could be). Yes, the well informed will see through it and find other venues to get their news, but last I checked the informed are a minority and popularity still counts.
you really should have references UCSC's annotated genome browser and tools and the genome browser. Incredible array of annotations, and completely in the public domain.
The UCSC browser is not completely in the public domain: a license is required for commercial downloads/installations. The Ensembl project is completely free to all as they use an apache-like-license.
Slashdot Mirror
Just to put that into perspective, I know at least one of our MySQL databases has done over 100 million queries in one day while loading genomic mapping data into our system. That equated to about 7-10 million inserts, the rest selects. That was also running on a dual Xeon (~2.4Ghz, a Dell PowerEdge 2600). It was averaging about 1400 queries a second, topping out at over 3000 at times.
Not that hard, here is the procedure: Execute the following mysql command:
Then (while maintaining the DB connection) take your snapshot. When the snapshot is done, drop the DB connection and the read lock will be released (or issue an UNLOCK TABLES command).It is generally faster than Postgres,
It handles large datatypes more easily than Postgres (although Postgres, while odd, has some more flexibility)
Postgres has an odd 8k limit per row (probably fixed by now though)
Supports selects across databases.
It has good replication support (with 4.x and later)
Comes with some good admin tools in the normal distro.
Decent full text indexing out of the box
It is really about choosing the right tool for the job, each has their advantages and disadvantages.
That assumes that two way communication is not enabled with the remote, like the rolling codes that car alarms use. Two way communication would actually be handy, think about PVRs sending state information to the remote so it can reconfigure its buttons or be an auxiliary display.
Not a good analogy: you own your computer that you use to view the spam and where you install the anti-spam software. You do not own the TV, the property that the TV is on and you share the TV with others that like the 'spam'
The anti-spam for TV would be blinders and ear plugs. The TV-B-Gone for spam would be a device that let anyone shutdown any SMTP server that was sending them mail they didn't want to receive, regardless of what it is and who else was using the server. Still, a TV-B-Gone would be fun, if not quite ethical.
Tell me about it, my girlfriend is slowly taking over my TiVO. At first she thought it was way to expensive and couldn't understand why I bought it. Now she complains that I record too many of my shows; she hasn't seen me watch 'Mythbusters' in a while so I should remove its Season Pass so her 'The Appretice' has more room. Women.
WHAT? ... no, I'm not at the airport ... WHAT?, I CAN'T HEAR YOU, SPEAK UP ... oh, sorry, that is just my new cell phone's turbine
First time? Isn't this at least their second time?
When did I say he did? Always refreshing to see an AC attack. I was talking about 'mistakes' and apologizing about them. Learn to actually be able to comprehend what you read and be able to think before you post.
s/Democrat/politician/g and then you have an unbiased version of the statement. Otherwise all you are doing is attacking one side explicitly and implying the other side is clean.
Yes, I know there are other sides but in this case, when someone is attacking a Democrat or Republican it strongly implies a support for the other side.
Pot calling the kettle black. How many times has Bush dodged the mistake question?
I read not too long ago about a UK study that found that an increase in some cancers came from living near power lines might be from the powerlines giving air pollution a charge and the charge causing the particles to stick in the lungs better. Ah, found the BBC story. Still under study but does make some sense.
This reminds me of JP Aerospace's plans and ideas for high altitude platforms to launch airships into orbit. Looks pretty nifty.
I'm sure they wouldn't use hydrogen, but that still begs the question of how these will affect the worlds helium supply. Probably not that much, but from what I have read it comes from limited places (mostly Texas) and once has a tendency to escape into space once it is out of the ground. I have to imagine having lots of these large helium balloons will not help matters.
As someone else pointed out, the up/down combination is only one degree of freedom, so in this case we have two degrees of freedom with almost a half of a third ("dwelling on the cursor"?).
The six degrees of spacial freedom (I'll skip the Kevin Bacon jokes) break down into the three translational degrees of freedom (up/down, left/right and forward/backward) and the three rotational degrees of freedom (pitch, yaw and roll, each one rotating around one of the three axes).
I doubt they use unfiltered tap water. I would be it is at least reverse osmosis filtered and probably has other additives to make it taste better. Scarily enough the plant where Bass is brewed is now owned by Coors Brewers Ltd.
Hey, I'm a bastard and I don't like being lumped with the likes of SCO.
Touché, but I would rather the masses be somewhat informed with some non-arbitrary and non-biased (eg, if one side has 10 minutes, then so does the other side) system to control it. A pipe dream I know, but something to strive for and I believe better than nothing.
This is the very speech that the 1st amendment was designed to protect. Not nude dancing, not obscenity, not flag burning, but political speech is what they were trying to protect. How can the 1st amendment be so expansive as to include those other things, but not the intended object of protection?
I'm not saying that I completely disagree with you and our current campaign finance laws are very broken, but we have some fundamental problems with totally unregulated free speech. When the constitution was framed, most news was word of mouth, candidates actually debated *each other* and there was no TV spreading any message that anyone with money wants to the vegetative masses.
With out some form of regulation we would end up with the people with the deepest pockets being the people that completely control what the general population knows (which we suffer from now, but no where near as bad as it could be). Yes, the well informed will see through it and find other venues to get their news, but last I checked the informed are a minority and popularity still counts.
Not the bikes that I like....
I thought he listened to John Ashcroft singing?
The UCSC browser is not completely in the public domain: a license is required for commercial downloads/installations. The Ensembl project is completely free to all as they use an apache-like-license.
I knew those Anonymous Cowards were to blame!
It happened to me a while ago, I believe I managed use killall. Lucky for me most of my work is from the shell so I had a local terminal open.