Re: VPN Recommendation

articularly the queries even when I used stored procedures and functions. So I would like to know some of your suggestions on my setup. Thanks, Michael Louie Loria LoRz Technology Solutions htttp://www.lorztech.com James Nobis Web Developer / System Engineer Academic Superstore 2101 E. Sa

RE: Considering migration from MyISAM to InnoDB

> http://www.innodb.com/bench.php, though I'm not sure our environment calls > for InnoDB. Thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] James Nobis Web Developer Academic Sup

Re: Solution to slow queries

ng List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com -- MySQ

Re: mysqld just ending...

Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com --

Re: possible bug left join and null

Thanks everyone for such quick and thorough responses! Quoting [EMAIL PROTECTED]: James Nobis <[EMAIL PROTECTED]> wrote on 04/21/2005 10:44:07 AM: The problem is something fairly simple but yet MySQL seems to make this complicated. Essentially, find a list of customers who have not bought p

possible bug left join and null

FT JOIN `Order` ON Customer.id = Order.customer_id INNER JOIN OrderLines ON Order.id = OrderLines.order_id AND OrderLines.product_id =9 WHERE Order.customer_id IS NULL I would expect this to return a single row with Customer.id 2. Is there something obvious my coworkers and I are missing? James

dependent subquery/correlated subquery

? Apparantly the MySQL team refuses to even recognize this as a bug. http://bugs.mysql.com/bug.php?id=9090 James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com -- MySQL General

Segfault 5.0.4 with subquery of the form <> ANY ( inner query )

ndard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-big-tables' '--with-mysqld-ldflags=-all-static' '--with-readline' '

Re: avg and timestamp/datetime

EMAIL PROTECTED]: James Nobis <[EMAIL PROTECTED]> wrote on 04/12/2005 10:19:33 AM: Hi all, Essentially I was asked to look into a problem with a query at the office which used AVG on a datetime column which produces incorrect results. (MySQL 4.1.10 on RHEL 3 update 4) As you can see belo

avg and timestamp/datetime

art of the manual that I missed which explains this unexpected behavior? AVG(col) v FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(col))) 20050258324839 v 2005-03-24 02:05:11 James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450

Re: MySQL server disconnects when executing simple Select statements++

t; -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-

Re: slowly running mysql server

model, cena; > # Time: 050309 17:03:10 > > additionally, this query returns 2216 rows with pictures. the process > longs about 2 minutes :( > and additionally, I'm a newbie with mysql. > Any ideas will be highly appreciated. > Thanks in advance, > /iv > *** > * >

innodb update issues

table is again fine for a short duration. Is there something obvious that I'm missing? James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com -- MySQL General Mailing Lis