RE: MYSQL Problem

2001-04-16 Thread Jan Bruvoll
Hi there, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries

Re: Default values

2001-03-07 Thread Jan Bruvoll
On Tue, 6 Mar 2001, MikemickaloBlezien wrote: Try giving a number instead of a string as a default for an int. Not sure I follow, it is a number?? refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, Your '100' is a string. Try something like this: refer_id int(10) UNSIGNED NOT NULL DEFAULT