Re: confirm subscribe to mysql@lists.mysql.com

2005-11-11 Thread Dylan
On Friday 11 Nov 2005 23:05, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/437523a6f4bb2030/mysql=dylan.me.uk > > This confirmation serves two purposes

Re: Solaris 10 performance improvements??

2005-02-26 Thread Dylan Neild
blems. Dylan On 16-Nov-04, at 2:14 PM, Jon Hancock wrote: Hello list, It has been my understanding from reading this list for a few years that Solaris doesn't match Linux on MySQL performance. I don't recall the exact reasons (different threading code?). Anyway, I'm exploring the lat

Re: MySQL and x86-64

2004-12-15 Thread Dylan Neild
on CPU. 64-bit Linux is pretty much everywhere. SuSE and RedHat ship a stable 64-bit distribution, though Debian 3.1 works great as well (i personally use Debian). Once you have a 64-bit system setup, skies the limit, RAM wise. Hope it helps, Dylan On 15-Dec-04, at 5:54 AM, Andreas Ahlenstorf wrot

Re: Query Cache slow downs?

2003-08-04 Thread Dylan Neild
he. Right now (3:00pm on Monday), we're doing -about- 1500 queries per second, so by the evening, we'll be pushing 2500 or so. Anything else you want to know, let me know. Dylan On Monday, August 4, 2003, at 01:33 PM, Joe Shear wrote: Hi, Sorry to bring up something unrelated to you

Query Cache Issues, Continued

2003-08-03 Thread Dylan Neild
nnoDB? Are there any thoughts on this? Is there a resource specifically for high performance/high load MySQL implementation/usage? Dylan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Allowing remote login

2003-08-02 Thread Dylan Neild
7;d point you at this link for more info: http://www.mysql.com/doc/en/GRANT.html Take care, Dylan On Saturday, August 2, 2003, at 11:55 AM, Mary Grace wrote: I have been using MySQL for awhile, and for the first time someone from outside our portable /16 needs access to some tables. We have gi

Query Cache slow downs?

2003-08-01 Thread Dylan Neild
something. Up until this point, it's just grown and grown along with us (using InnoDB table system), so I'm hoping to continue. :) Thanks in advance, Dylan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AUTO_INCREMENT

2003-06-06 Thread Dylan Pham
Hi, I am new and am wodering if anyone can point out how to make AUTO_INCREMENT readjust the numbers so that when you delete a row it will go back to using the next number after the last row in the table? Thank you. Hai __ Do you Yahoo!? Yahoo! Calendar - Free onli

Re: Junction entities VS. JOIN

2001-01-24 Thread Dylan Shea
Benjamin, beautifully put. Thank you both so much. --Dylan Shea Benjamin Pflugmann wrote: > Hi. > > It's simply that you can look at (a_id,b_id) as a PRIMARY KEY. You > don't need an additional, aritificial sequence number ab_id. > > CREATE TABLE table_ab ( >

Back up procedure for Mysql

2001-01-24 Thread Dylan Shea
http://tips.pair.com/index.php3?page=php3mysql_backupmysqldatabase When use of the following examples replace $host with hostname/IP of your MySQL server. $user with your username $pass with your password $database with your databasename $table with your table

Re: ArabiaSoft and NuSphere

2001-01-24 Thread Dylan Shea
ckage. b.t.w. I was using the the RH7 Linux version. Installing Abriasoft SQL on top of a fresh RH7 install will solve you a lot of hassle due to bugs in key RH7 packages. --Dylan Shea "Frank J. Schmuck" wrote: > Any comments on the packages from ArabiaSoft

Re: Junction entities VS. JOIN

2001-01-24 Thread Dylan Shea
n record ids? Technically, it shouldn't, but does good db form require it? or is a junction entity normalization table exempt from that? thanks again --Dylan Shea "Carsten H. Pedersen" wrote: > > I'm afraid this borders on sql/db question material vs. specific mysql &g

Junction entities VS. JOIN

2001-01-24 Thread Dylan Shea
arches for b_id based on a a_id value are fast, and vice-versa? thanks --Dylan Shea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ