Using Network Block Device on Linux to build HUGE/cheap memory-base MySQL boxes.

2006-02-19 Thread Kevin Burton
I was talking to a friend tonight about how they use NBD to run a single system image in memory. NBD (Network Block Device) allows one Linux box to export a block device and for you to mount it on another filesystem. For the memory component they just use a ram disk. More info here: ht

Permissions for /var/run/mysqld

2006-02-19 Thread Norman Walsh
A couple of days ago, I decided to be brave (or crazy :-) and upgrade my Ubuntu "Breezy" install to "Dapper". It was really remarkably uneventful, I've just got a couple of rough edges to sort out. One is that dspam (3.4.9 built by me some months ago) can no longer connect to mysql when I reboot t

MySQL and OpenOffice - JDBC

2006-02-19 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't really think this is the right place to ask this question, so please forgive this post. I've tried asking the question over on the OpenOffice list, but can't get an answer. I'll try to give all the information to ease things. One of the guru's

Re: MySQL and OpenOffice - JDBC

2006-02-19 Thread George Law
Michael, can you connect using the command line client? sounds to me like it may be the "old_password" problem. http://dev.mysql.com/doc/refman/5.0/en/old-client.html -- George - Original Message - From: "Michael Satterwhite" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Sunday, Feb

Table grows much faster than others.

2006-02-19 Thread Song Ken Vern-E11804
Hi, I have one table which grows at a much faster rate than the rest. It has 80 times more entries than the second largest table, which has 10k rows. What are the steps I can take to slow down the growth? Can I partition the table? Will the size of the table affect the perfomance of queries? I

Re: Table grows much faster than others.

2006-02-19 Thread Dan Nelson
In the last episode (Feb 20), Song Ken Vern-E11804 said: > I have one table which grows at a much faster rate than the rest. It > has 80 times more entries than the second largest table, which has > 10k rows. > > What are the steps I can take to slow down the growth? The only thing you can do is