Re: mysqld question

2003-06-24 Thread Henrik Leghissa
At 12:44 2003-06-24, Janice Wright wrote: Well, in the Managing MySQL course run by MySQL AB; they taught us that upgrading hardware is the *last* thing you do to get the database to run faster, not the first. Before you buy new hardware you should: Thanks for the info! (appreciate it) Though I

RE: mysqld question

2003-06-24 Thread Henrik Leghissa
At 16:52 2003-06-24, Christopher Knight wrote: Not a silly question... we all had to start somewhere... you can do it during the create table ( primary key ) http://www.mysql.com/doc/en/CREATE_TABLE.html Thanks for the explanation, I'm no sql-guru at all, so all info is welcome! :-) I'm running

Re: mysqld question

2003-06-24 Thread Henrik Leghissa
At 16:21 2003-06-24, gerald_clark wrote: Linux shows threads. BSD shows processes. The difference is in the way ps runs, not mysqld. *doh* I guess the sun got to me, sorry mate! :-) But do you have any good ways to get the database to run any faster? I am running it on a really beat up piece of j

mysqld question

2003-06-24 Thread Henrik Leghissa
On my server running linux several daemons opens when I run "msqld -u mysql" or "safe_mysqld". A listing of the process shows this: mysql24475 0.5 2.1 83292 2012 ?S15:46 0:03 mysqld -u mysql mysql24476 0.0 2.1 83292 2012 ?S15:46 0:00 mysqld -u mysql mysq

Re: But now new problems :-(

2003-03-10 Thread Henrik Leghissa
At 10:13 2003-03-08, Zak Greant wrote: Why not use the binaries from mysql.com? We recommend them over making your own binaries. I guess this is what I have to do then... I just *imagined* that mysql would run better on my linuxbox if I compiled it on it... Well, cheers! / H, off to setup up

But now new problems :-(

2003-03-07 Thread Henrik Leghissa
I managed to get passed the ./configure-phase, but now I encountered more trouble; To compile mysql I write "make"... and get these error-messages after a while; gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\" -DDATADIR=\"/usr/local/mysql/var\" -DSHAREDIR=\"/usr/local/mysql/share/mysql\" -D

Issue Solved (Re: MySQL compiling problem - (a classic))

2003-03-07 Thread Henrik Leghissa
At 03:51 2003-03-08, Henrik Leghissa wrote: I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with; ./configure --prefix=/usr/local/mysql I get this error message after a while of machine-chewing; checking for tgetent in -lncurses... no checking for tgetent in -lcurses.

Re: MySQL compiling problem - (a classic)

2003-03-07 Thread Henrik Leghissa
At 03:35 2003-03-08, Henrik Leghissa wrote: I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with; ./configure --prefix=/usr/local/mysql I get this error message after a while of machine-chewing; checking for tgetent in -lncurses... no checking for tgetent in -lcurses.

MySQL compiling problem - (a classic)

2003-03-07 Thread Henrik Leghissa
Hello, This is my first post to [EMAIL PROTECTED] I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with; ./configure --prefix=/usr/local/mysql I get this error message after a while of machine-chewing; checking for tgetent in -lncurses... no checking for tgetent in -lcurses...