NYCPHP Meetup

[nycphp-talk] MySQL 4.10 new features ...

Rolan Yang rolan at omnistep.com
Tue Apr 29 17:19:36 EDT 2003


Nice.

I just upgraded to 4 from 3.22.32 last night/this morning (yea, it's 
been a while since
I touched the thing). Converted all tables from iasm to myisam. The new 
version
"feels" a bit slower (haven't done any benchmarks yet), but disabling 
innodb support
freed up some extra RAM, which seemed to help a little.

I do have to admit though, the machine is a meager Cobalt celeron 300mhz 
with 96Megs of RAM
and it is wacked with a lot of daily traffic (currently hosting parts of 
the Mozilla project,
RealServer, about 150+ other websites, and a whole gaggle of other services)

The subqueries feature is something I'll definitely look forward to using.

~Rolan


Jon Baer wrote:

>http://www.mysql.com/newsletter/2003-04/a0000000151.html
>
>Just thought Id pass that URL along to anyone that wasn't subscribed to the
>newsletter ...
>
>- Jon
>
>-snip-
>Some new features include:
>
>* Subqueries:
>SELECT * FROM t1 WHERE t1.a=(SELECT t2.b FROM t2);
>SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM t2);
>* Derived tables: SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE
>t1.a=t3.a;
>* `INSERT ... ON DUPLICATE KEY UPDATE ...' syntax. This allows you to
>`UPDATE' an existing row if the insert would cause a duplicate value in a
>`PRIMARY' or `UNIQUE' key. (`REPLACE' allows you to overwrite an existing
>row, which is something entirely different. See
>http://www.mysql.com/doc/en/INSERT.html
>
>
>
>
>--- Unsubscribe at http://nyphp.org/list/ ---
>
>
>
>  
>




More information about the talk mailing list