Intel Compiler

2004-06-21 Thread Mike Miller
I am trying to use my binary Intel installation to compile PHP (which seems to be doing a _very_ simple program). So in a statically linked installation these references are defined in the embedded C library, but if one is linking it with another application, it isn't. Possibly the intel C lib

Re: MySQL & Web Clustering...

2004-06-18 Thread Mike Miller
seamless. Would require some work to make one though. -Mike From: Jeff Smelser <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: MySQL & Web Clustering... Date: Fri, 18 Jun 2004 11:43:05 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Mi

Re: MySQL & Web Clustering...

2004-06-18 Thread Mike Miller
Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tel

Re: Safe Database Problem

2004-02-13 Thread Mike Miller
Y Lock_tables_priv: Y Cheers; -M From: Victoria Reznichenko <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Safe Database Problem Date: Fri, 13 Feb 2004 13:38:50 +0200 "Mike Miller" <[EMAIL PROTECTED]> wrote: > Hi, > > I believe I've done everything

Re: Connect to MySQL via PHP

2004-02-12 Thread Mike Miller
The _only_ real benefit of Apache2 over Apache1 is it's thread-based model. So why leave a stable, tried-and-true, robust Apache1 platform for no additional benefits at all? Why break compatibility? Why use the Apache2 branch if you don't need it? PHP itself works quite fine in a threaded mo

Re: Unique IDs

2004-02-12 Thread Mike Miller
code it within your program. If this is in fact a primary key (whcih you seem to describe it as), then it should be distinct anyway. So do an INSERT IGNORE or even just an INSERT. It will fail upon duplicates. Check the affected rows or the insert_id (using whatever API you use to access MyS

Thread Stack

2004-02-12 Thread Mike Miller
I receive the following warning in my .err file after upgrading from 3.23.56 to 4.0.17. Any ideas what's causing it and how to fix it? Warning: Asked for 196608 thread stack, but got 126976 Trying to find the source- maybe a setting is too high? Linux 2.4.x Thanks in advance, -M _

Safe Database Problem

2004-02-12 Thread Mike Miller
Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used t

MERGE tables still gamma?

2003-07-28 Thread mike . miller
, and I'd love to split our invoice table into years and use pack on the old years and replace the original table with a MERGE. -- Mike Miller Business Analyst & Applications Developer BMG Canada Inc. Tel: 416-586-1646 Fax: 416-586-0454 EMail: [EMAIL PROTECTED]

INDEX not getting used

2002-09-20 Thread mike . miller
omer | ALL | state_code| NULL |NULL | NULL | 2298 | where used | +--+--+---+--+-+--+--+-- --+ Anyone have any suggestions as to where I could look to fix this up? -- Mike Miller -- Happy 20'th Bir

RE: How to set permissions?

2002-03-14 Thread mike . miller
This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user&#x

Bug or Misunderstanding

2002-03-07 Thread mike . miller
this? This is MysQL 4.0.1 FreeBSD binary install. -- Mike Miller, BMG Canada Inc. Tel: 416-586-1646 Fax: 416-586-1661 EMail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (th

Re: Wildcard Hostname's in MySQL 3.23.41

2001-09-09 Thread Mike Miller
I just made the upgrade from 3.22 to 3.23.41 this weekend and had one little hiccup. I have a few users with host entries with wildcards (hostname = '%'). These users stopped working and were not able to login. When I added one for the hosts they were connecting from, it began to work fine.