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 que

Re: Default values

2001-03-07 Thread Jan Bruvoll
On Tue, 6 Mar 2001, MikeBlezien 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 DEFAU