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 Janice Wright
Sometime recently Henrik Leghissa said: > 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 t

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 Christopher Knight
/Tips.html -Original Message- From: Henrik Leghissa [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 9:42 AM To: Christopher Knight Subject: RE: mysqld question At 16:39 2003-06-24, Christopher Knight wrote: >it really depends on > how big your database is > what else is ru

RE: mysqld question

2003-06-24 Thread Christopher Knight
blink :-) Id start w/ making sure you have indexes. They help abunch. -Original Message- From: Henrik Leghissa [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 9:26 AM To: [EMAIL PROTECTED] Subject: Re: mysqld question At 16:21 2003-06-24, gerald_clark wrote: >Linux shows

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

Re: mysqld question

2003-06-24 Thread gerald_clark
Linux shows threads. BSD shows processes. The difference is in the way ps runs, not mysqld. Henrik Leghissa wrote: 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 ?S

re: mysqld question

2003-02-10 Thread Egor Egorov
On Saturday 08 February 2003 18:44, Jude DaShiell wrote: > Does that --skip-networking switch prevent mysql from looking for a > socket? No, if you use --skip-networking, you can connect only via Unix socket. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This em