MySQL Database Dimensioning

2008-03-15 Thread Aggarwal Vivek-Q4997C
Hi Iam very new user of MySQL. Can anyone help me in guiding me that how can I dimension and design the MySQL Database Server. If some one can provide the guidelines and the critical parameters that are required to dimension the MySQL Server. Iam looking for scaling the database for at least 5

db design

2008-03-15 Thread Brett Harvey
which method is better to do. I have 5 tables. They represent sections/parts of a companies standards. There are 13 main categories, each of those categories has subsections (some with 3, some with 10 or more), those subsections have subsections, etc. Which table design is better to do. T

Re: how to use index with order by here

2008-03-15 Thread Rob Wultsch
On Sat, Mar 15, 2008 at 2:42 PM, Nacho Garcia <[EMAIL PROTECTED]> wrote: > Hi, im having troubles with one query, hope someone can help. > > on this table: > > messages: > id_fromint(10) > id_toint(10) > textvarchar(1000) > time > > with index on id_form and id_to > > i want to

how to use index with order by here

2008-03-15 Thread Nacho Garcia
Hi, im having troubles with one query, hope someone can help. on this table: messages: id_fromint(10) id_toint(10) textvarchar(1000) time with index on id_form and id_to i want to get messages sent from one user to another and vice versa order by time. let say we want to search mess

Re: #1005 - Can't create table '.\unb2test\#sql-770_2.frm' (errno: 150)

2008-03-15 Thread Yves Goergen
On 14.03.2008 00:55 CE(S)T, Rob Wultsch wrote: I am guessing it is an issue with "SearchRevision" being an INTEGER, and "RevisionNumber" being a SMALLINT. Thank you, that was the problem. My design was incorrect anyway to use different types here... Now that's fixed, too. :) http://www.goo