Martijn Tonies wrote:
The notion of a variant record exists in many programming languages.
Typically you have a selector to indicate which variant it is. There is
nothing at all wrong with using the same sort of construct in a database
table.
http://en.wikipedia.org/wiki/Variant_record
I'm running replication between two MySQL servers. This has been working
fine for a while; howver, as of yesterday replication keeps failing because
of a lock wait timeout exceeded on one of my tables.
I thought I could use the mysqlbinlog utility to figure out what queries
were being executed
www.directoryuniversal.com
Yes, that is the actual daily cost of having your website listed on our
directory. With over 3 million visitors a year coming thru our directory, you
can't afford not to spend the 15 cents a day. Let the professionals at
Universal Real Estate Directory show you how
I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
the mysql command shell,
I got an error 1064 (42000): *You have an error in your SQL syntax*;
Here is my code:
mysql CREATE TABLE memberDetails
- *(*
-memberId INT NOT NULL AUTO_INCREMENT,
-
mysql CREATE TABLE memberDetails
- *(*
-memberId INT NOT NULL AUTO_INCREMENT,
-PRIMARY KEY(memberId),
-first_name varchar(100),
-last_name varchar(100),
-Email varchar(60),
-phoneNum varchar(25)
- *);*
Works without the
I see that you've already decided on 64-bit anyway, but here's a more
explicit reason to do so: in 32-bit (PAE-mode), no single process can
allocate more than 4GB of memory- that's all the address space there
is. The *system* can see it all, but each process can only work with a
single 4GB chunk
I don't have any links, but in general we don't do very much as far as
tuning is concerned.
Here's a few things I can think of off the top of my head that we
sometimes do if we're worried about performance:
blockdev --setra 2048 /dev/sda (substitute an appropriate readahead
amount and device
On Sat, Nov 15, 2008 at 3:54 AM, metastable [EMAIL PROTECTED]
wrote:
I may just have had an insight over my morning coffee.
How about turning things around and adding a FK -to the customers table-
on each of the customer type tables (companies, people, charities, etc) ?
The customers table
Yeah, so a UNION would work, would this solution be faster than using
a subquery (my instinct says yes) but thought I would ask. They both
execute fast on my system so it's hard to say under load.
Thanks,
Waynn
On 11/12/08, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Nov 12), Waynn