[ciapug] Mysql

[Dave J. Hala Jr.]

I can't upgrade until Aug-Sept of 2007. Its a live well tested, mature
working system. This server is also the replicating master for a number
of other servers.

Why this issue hasn't shown up in the last 3 years is beyond me. At this
point, doing that upgrade would be like buying a new car because I've
got a flat tire.

However, in 07' I'll probably move to mysql 5.0 and php 5, so the plan
is in the works.

With regard to your question regarding the select returning 1281, the
answer is yes. I just don't undertand  why the query doesn't move all
the records when using the wildcard.



:) Dave



On Fri, 2006-01-06 at 11:11, David Champion wrote:
> Dave J. Hala Jr. wrote:
> > I'm running  mysql 3.23.58.  I've run into an issue inserting records
> > into a table. The query criterion tells me there are 1281 records. When
> > I do the insert mysql only only inserts 591 records.
> > 
> > Here's the insert query:
> > 
> > INSERT INTO notify_temp SELECT * FROM lhpl_side WHERE SNP='0';
> > 
> > Anyone got any ideas as to why it skips/throws out 690 records?
> > 
> > 
> > 
> > :) Dave
> 
> So you mean if you say "SELECT count(*) FROM lhpl_side WHERE SNP='0'" it 
> returns 1281?
> 
> You might want to look into upgrading your mysql version. 3.23.58 was 
> released on 9/11/2003. That's ancient.
> 
> Going up to 4.1.x, or even 5.x would get you some nice performance 
> improvments, as well as several nice features, like sub selects...
> 
> -dc
> 
> _______________________________________________
> ciapug mailing list
> ciapug at cialug.org
> http://cialug.org/mailman/listinfo/ciapug
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606