You know what just occurred to me...when you were testing them, was there a smell to them? I recall that there's a faint scent of, well, I was thinking gunpowder, but perhaps it's related. I don't recall it in either of the other two stations I frequent.
PS: What's interesting is that besides being one big ad for Oracle and Sun products not one person has shown how a national ID card would have prevented the acts of September 11th. Heck, it isn't like teh airlines weren't already asking for ID before people boarded the plane or are Ellison and McNeally suggesting racial profiling where all foreigners fly on seperate flights from God Fearing Americans?
As I recall from some news show (maybe DateLine?), about half of these people had violated the terms of their visit to the US. The show mentioned that IF they had been issued national ID cards (and required to show them to board the plane), they would have been caught by INS before boarding the plane.
Whether these cards can be forged or not is another matter.
When I have that problem, MySQL just hangs, using a lot of memory. At a guess, I'm thinking that MySQL sucks up all available RAM and swap, then hangs.
If you start reproducing the problem again, you might want to watch the output of vmstat (I use 'vmstat 5'), up until the machine hangs. That'll tell you if its a memory hog problem or not.
I can consistently crash my machine by trying to index a 5 million row table.
If you're using a threaded MySQL server, try creating the file/etc/my.cnf and insert the lines:
[mysqld]
set-variable = thread_stack=128k
And restart MySQL.
If MySQL keeps crashing, try doubling it. I'm up to thread_stack=1M on my development servers, and thread_stack=2M on my production servers. Igenerally need to double the thread stack size every time we add a 1 million rows to the table.
Since my problem is related to thread stack, its a coding issue, not a "My Database is better that yours" issue.
Here's a development/etc/my.cnf for a Sun Solaris 2.7 machine with 2 Gigs of RAM. Several tables are above 6 million rows. Large updates to keyed fields cause MySQL to hang.
I was thinking that a Rack of PS2s would make an excellent batch pool, if only we could put 512 Meg of RAM in them. Has anybody hacked their PS2 for more RAM?
Here's how to configure & build a stock RedHat kernel. This won't work when you upgrade to a new kernel, but at least you can look at all the options as they are configured.
Look in/usr/src/linux/configs
You'll see several files, names something like kernel-2.2.15-i386-BOOT.config kernel-2.2.15-i586.config kernel-2.2.15-i386-smp.config kernel-2.2.15-i686-smp.config kernel-2.2.15-i386.config kernel-2.2.15-i686.config kernel-2.2.15-i586-smp.config
Decide which one you want. I'm using kernel-2.2.15-i386.config on my laptop and kernel-2.2.15-i686-smp.config on my desktop.
You that you have a file, in/usr/src/linux, run # make xconfig or # make menuconfig Depending on X or Text mode. Look for an option like "Load Alternative Config File". Type/Paste in the name of the file you picked. Save & Exit.
# make dep; make clean; make; make modules; make bzlilo; make modules_install
Slashdot Mirror
Welcome to DC.
As I recall from some news show (maybe DateLine?), about half of these people had violated the terms of their visit to the US. The show mentioned that IF they had been issued national ID cards (and required to show them to board the plane), they would have been caught by INS before boarding the plane.
Whether these cards can be forged or not is another matter.
I haven't tried the site out personally. It looks to be aimed more at US corporations than individuals. YMMV.
With a quick browse, I couldn't find any mention of cost, but I'm sure there is one.
If you start reproducing the problem again, you might want to watch the output of vmstat (I use 'vmstat 5'), up until the machine hangs. That'll tell you if its a memory hog problem or not.
If you're using a threaded MySQL server, try creating the file /etc/my.cnf and insert the lines:
[mysqld]
set-variable = thread_stack=128k
And restart MySQL.
If MySQL keeps crashing, try doubling it. I'm up to thread_stack=1M on my development servers, and thread_stack=2M on my production servers. Igenerally need to double the thread stack size every time we add a 1 million rows to the table.
Since my problem is related to thread stack, its a coding issue, not a "My Database is better that yours" issue.
Here's a development /etc/my.cnf for a Sun Solaris 2.7 machine with 2 Gigs of RAM. Several tables are above 6 million rows. Large updates to keyed fields cause MySQL to hang.
I was thinking that a Rack of PS2s would make an excellent batch pool, if only we could put 512 Meg of RAM in them. Has anybody hacked their PS2 for more RAM?
Here's how to configure & build a stock RedHat kernel. This won't work when you upgrade to a new kernel, but at least you can look at all the options as they are configured.
/usr/src/linux/configs
/usr/src/linux, run
Look in
You'll see several files, names something like
kernel-2.2.15-i386-BOOT.config kernel-2.2.15-i586.config
kernel-2.2.15-i386-smp.config kernel-2.2.15-i686-smp.config
kernel-2.2.15-i386.config kernel-2.2.15-i686.config
kernel-2.2.15-i586-smp.config
Decide which one you want. I'm using
kernel-2.2.15-i386.config on my laptop and
kernel-2.2.15-i686-smp.config on my desktop.
You that you have a file, in
# make xconfig
or
# make menuconfig
Depending on X or Text mode. Look for an option like "Load Alternative Config File". Type/Paste in the name of the file you picked. Save & Exit.
# make dep; make clean; make; make modules; make bzlilo; make modules_install
They should've mentioned something about noticing the same effect in secretaries that learned Shorthand. Not mentioning Shorthand tipped me off.