RE: Why is MySQL always linked to PHP?

[snip] I merely wished to dispel the common, newb impression that PHP is the only realistic choice. [/snip] I don't think that is the impression but I think that the low barrier to entry and extensive support community make PHP a widely acceptable choice. I have seen many a newb turned off by the

deletes from a VERY large table

I have to delete old records from a very large table (1.6billion rows) in a stored procedure. CREATE TABLE mytable( id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, unix_time INT(11) NOT NULL DEFAULT 0, value DOUBLE (20, 4) NOT NULL DEFAULT 0., UNIQUE INDEX history_1 USING BTREE (id, unix_ti

Re: Why is MySQL always linked to PHP?

I realize this is somewhat off-topic for this list but: I too have extensive experience with PHP/MySQL used in large scale projects but I have experience with other languages and frameworks as well. I merely wished to dispel the common, newb impression that PHP is the only realistic choice. - m

RE: [ANN] PBXT 1.5.02 Beta Released!

> -Original Message- > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On > Behalf Of Johan De Meersman > Sent: Friday, July 16, 2010 7:41 AM > To: MySQL List > Subject: Re: [ANN] PBXT 1.5.02 Beta Released! > > Can I somehow unsubscribe (that is opt-out , as opposed to the more >

RE: Why is MySQL always linked to PHP?

> -Original Message- > From: Jay Blanchard [mailto:jblanch...@pocket.com] > Sent: Friday, July 16, 2010 5:25 AM > To: Michael Dykman; mysql > Subject: RE: Why is MySQL always linked to Php? > > [snip] > PHP applications are, for the most part, not that ambitious > and mysql is simply the

Re: [ANN] PBXT 1.5.02 Beta Released!

Hi Johan, I understand what you are saying, but this is certainly not the announcement of a commercial product. It is also not spam, because the announcement of the release of a open source MySQL Storage Engine is relevant to this list. Nevertheless, I prefix my e-mails with [ANN] (for an

Re: [ANN] PBXT 1.5.02 Beta Released!

Can I somehow unsubscribe (that is opt-out , as opposed to the more civilised opt-in) from the myriad of commercial announcements on this list, or do I just have to spambrand all senders ? Some weeks it feels as if there's more productspamming than posting going on. On Fri, Jul 16, 2010 at 4:25

[ANN] PBXT 1.5.02 Beta Released!

Hi All, I have just released PBXT 1.5.02 Beta. This version adds a 2nd level (SSD based) cache! For more information on the 2nd Level Cache, please check out my blog: http://pbxt.blogspot.com/2010/07/pbxt-1502-beta-adds-2nd-level-cache.html The new version is available for download from: ht

RE: Why is MySQL always linked to Php?

[snip] PHP applications are, for the most part, not that ambitious and mysql is simply the most accessible database with the best developed API. [/snip] I know that you said "for the most part" and you are absolutely correct. I just want to point out that there are many corporations relying on PHP

Re: Myisam advantages

Hi, Much more conservative approach to disk space management - each MyISAM table is stored in a separate file, which could be compressed then with myisamchk if needed. With InnoDB the tables are stored in tablespace, and not much further optimization is possible. All data except for TEXT and BLOB