Racker Hacker » MySQL: Errcode: 24 when using LOCK TABLES

Racker Hacker » MySQL: Errcode: 24 when using LOCK TABLES

There’s two ways to fix the problem. First, if you find that you only hit the limit during mysqldumps and never during normal database operation, just add --single-transaction to your mysqldump command line options. This will cause mysql to keep only one table open at a time.

However, if this happens while backups aren’t running, you may want to increase the open_files_limit in your MySQL configuration file. By default, the variable is set to 1,024 open files.

For further reading:
5.2.3. System Variables
7.13. mysqldump – A Database Backup Program

UMW Blogs support videos for WPMu 2.6

Jim Groom

Jim Groom, who administers the UMW group of WordPressMU blogs has placed a whole slew of videos online, which help users with WPMU, as well as migrate from WPMU-1.3.3 to WPMU-2.6.

Click on image to view site

The inimitable Andy Rush (a.k.a. EduRush) and I have been working diligently to create a whole slew of screencasts documenting the new interface for WPMu 2.6. We’ve finished a whole bunch of them over the last week or so and published them on the now official UMW Blogs Screencasts site, so below is a list of the screencasts we have created. All of the screencasts are Creative Commons and while they’re currently published as SWF files, we will be uploading them all to Blip shortly. Keep in mind that these screencasts are specific to the UMW Blogs installation, but they still may prove useful for anyone who wants to point people to a quick overview of the administrative backend, the changes between versions WPMu 1.3.3 and 2.6, and a very tab-specific discussion of the how to manage a WordPress blog.

Official Google Blog: We knew the web was big…

Official Google Blog: We knew the web was big…We’ve known it for a long time: the web is big. The first Google index in 1998 already had 26 million pages, and by 2000 the Google index reached the one billion mark. Over the last eight years, we’ve seen a lot of big numbers about how much content is really out there. Recently, even our search engineers stopped in awe about just how big the web is these days — when our systems that process links on the web to find new content hit a milestone: 1 trillion (as in 1,000,000,000,000) unique URLs on the web at once!How do we find all those pages? We start at a set of well-connected initial pages and follow each of their links to new pages. Then we follow the links on those new pages to even more pages and so on, until we have a huge list of links. In fact, we found even more than 1 trillion individual links, but not all of them lead to unique web pages. Many pages have multiple URLs with exactly the same content or URLs that are auto-generated copies of each other. Even after removing those exact duplicates, we saw a trillion unique URLs, and the number of individual web pages out there is growing by several billion pages per day.

Houston Community Newspapers Online – Green fuel, made at home

Green fule, made at home

From the article:

The “Rivera Method” takes such agricultural refuse as cracked soy beans, rice and cotton seed hulls, grain sorghum, milo and jatropha and turns them into bio-crude oil. This crude – or Vetroleum, as Rivera calls it – can then be further refined into everything from gasoline to jet fuel and just about every petrochemical in between.

With this process, just one bushel (60 pounds) of organic waste can yield about six gallons of bio-crude, Rivera said.

…

“Our biggest problem is that we are too good to be true,” Rivera said. “We can literally replace every gallon of gasoline, diesel and jet fuel in the United States using just 12 percent of the waste byproducts in the country.”

And if that wasn’t enough, the sole byproduct from the crude-making process is fertilizer: 737-grade, all organic fertilizer.

“The fertilizer is worth about 15 cents per pound, but the fuel byproduct is worth much more,” said General Manager Gerald Brent.

Sustainable Power currently houses five of these Vetroleum-producing reactors within its Baytown facility, the largest of which is capable of continuous output in just under nine minutes of operation. In addition to the central reactor, the company has also built four much smaller reactors that can be delivered to potential investors in order to both assuage doubts and test the viability of local farm wastes.

The eventual goal, Brent said, is the construction of 400 reactors at the Baytown facility – each capable of producing 6,000 gallons of bio-crude a day – and a (Vetroleum-powered) 500 megawatt energy plant capable of servicing 400,000 homes.

Brent expects the facility to be ready within the next 12 to 18 months. “We have to build this from the ground up. This is just our proof-of-concept,” he said.

Read more – Green fuel, made at home »