Complex Query: Best way to write it?

r_id | tinyint(1) | | PRI | NULL| auto_increment | | profile_gender_name | varchar(15) | | | || +-+-+--+-+-++ -- Keith Bussey Director of Operations - IwantU, Inc. ICQ: 38373031 Tel: +506-

Re: JOIN types

index | +---++++-+- -++-+ 4 rows in set (0.00 sec) Also, I'm running MySQL 4.0.13-standard, STRAIGHT JOIN doesnt seem to exist for me ;p -- Keith Bussey Mana Internet Solutions, Inc. Chief Technology Manager +50 6 280 2284 ext.108 Quoting Mat

re: JOIN types

MyQuoting [EMAIL PROTECTED]: > I'm suprised by your result too. Did you have an index on the join column? > If > not that might explain it. One place you might turn to learn more about how > > mysql optimizes joins is internals.texi. This file describes a lot of the > internal workings of m

JOIN types

ut it didnt explain their differences and uses very well), I'd greatly appreciate it =) Or, if you simply want to give the explanation yourself, that's fine too. Thanks, -- Keith Bussey Mana Internet Solutions, Inc. Chief Technology Manager +50 6 280 2284 ext.108 -- MySQL

Re: Using UNIX_TIMESTAMP() as default field value ?

is the display size, not the size of the > integer. You probably knew that, but just in case... Otherwise, > "int(10) unsigned not null default 0" should be fine. > > Michael > > Keith Bussey wrote: > > > Quoting Michael Stassen <[EMAIL PROTECTED]>: > &g

Re: Using UNIX_TIMESTAMP() as default field value ?

not in a mmddyy type. > Michael > > Keith Bussey wrote: > > > Hi all, > > > > I was wondering if it is possible to have the default value of an integer > > field be the current UNIX timestamp ? > > > > MySQL doesn't allow me to use

Using UNIX_TIMESTAMP() as default field value ?

uot;int(10) unsigned not null default 0" for my unix timestamp fields, is there perhaps a more efficient field type I should be using? Thx -- Keith Bussey Mana Internet Solutions, Inc. Chief Technology Manager +50 6 280 2284 ext.108 -- MySQL General Mailing List For list archives: http://

MySQL vs. MaxDB

features MySQL doesnt have yet.) ?? Off the top of my head, I assume MySQL would be faster than MaxDB for web- based applications/sites, but thats just an assumption I'd like to find some facts. Thanks, -- Keith Bussey Mana Internet Solutions, Inc. Chief Technology Manager (514) 398-9994 ex

Re: Table is full error

Thanks I will make new tables and transfer the data over =) Just wodnering though, any advice on how to tell what to set AVG_ROW_LENGTH to ? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting [EMAIL PROTECTED]: > > On Thu, 4 Sep 2003, Keith Bussey

Re: Table is full error

Quoting "Keith C. Ivey" <[EMAIL PROTECTED]>: > On 4 Sep 2003 at 15:31, Keith Bussey wrote: > > > I do have another Database on the same machine which has a table that > > is a lot bigger (about 9 GIGs) and it wasn't created with any of the > > spe

Re: Table is full error

450438 | 2002-10-21 11:58:24 | 2003-08-31 01:01:41 | 2002-11-30 01:41:00 || | ++++++-+-+--+---++-+-+-+----+-+ 1 row in set (0.00 sec) >

Re: Table is full error

oblem) as only 2: an ID autonumber field, and a text field. Perhaps there is some bug/limitation in Mysql whereby a field can only have so much size ?? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Colbey <[EMAIL PROTECTED]>: > > Most likel

Re: Table is full error

ws affected (0.23 sec) Records: 315 Duplicates: 0 Warnings: 0 mysql> select count(*) from email_body; +--+ | count(*) | +--+ | 319 | +--+ 1 row in set (0.00 sec) Your suggestion seemed to wipe out my rows ! (s'ok I got a backup ;p) -- Keith Bussey

Table is full error

ot increase max table size ? I have other databases on other servers with much larger tables without problem. I'm running MySQL-standard 4.0.13 on FreeBSD 4.8-Stable Thanks! -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For

Fixing Replication

bin files to the affected server's name. That method doesn't seem to work though. Thanks in advance! -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Very strange MySQL problem !

That's the problem, when the script runs, I can connect from serverA fine!...but seems the webpages can't ;/ -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting [EMAIL PROTECTED]: > > On Wed, 13 Aug 2003, Keith Bussey wrote: > > > Ar

Re: Very strange MySQL problem !

ks, which makes Server A unable to perform it's inserts until Server B > releases the lock. ServerB's updates/deletes are on a different database server though (as stated below ;p)...so it shouldn't factor in here at all. > On Wed, 13 Aug 2003, Keith Bussey wrote: >

Very strange MySQL problem !

ndard 4.0.13 Thanks!! -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lost connection to MySQL server during query

e software (re-installing mysql, upgrading, etc) and tried the hardware (RAM, ethernet card). Nothing seems to help. The DB server is Linux Redhat 7.3 with the 2.4.18-3smp kernel. I am running MySQL standard 4.0.13 Thanks -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-99

Re: URGENT problem with mysql processes

bservers) would still be wanting to send > > to IP addres 192.168.1.71 as configured for php or in your client. > > Best regards > > Nils Valentin > Tokyo/Japan > > > 2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました: > > Neither of these two machines send the re

Re: URGENT problem with mysql processes

No, replication is fine I can see those processes as they should be. The problem processes all come from the webservers' requests. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Dominicus Donny <[EMAIL PROTECTED]>: > If it is the repli

Re: URGENT problem with mysql processes

No, the slaves replicate fine and I can see their entries in the processlist normally (as their hostname), not as "unauthenticated user".. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, &g

Re: URGENT problem with mysql processes

-- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, > > soory now I got confused. Which machine is sending the requests (client) and > > which machine is the mysql server (server). Do you use

Re: URGENT problem with mysql processes

run normally with IP 192.168.1.71, but NOT with IP 192.168.1.79 even when they are on the same machine ? -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, > > The wrong IP address could only avoid a client t

URGENT problem with mysql processes

nnect | NULL | login | NULL | I need to fix this immediately as my site cannot run ! Thanks in advance. I've seen this exact same situation happen to others (posted on various boards), however never saw any solutions ;/ -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-99