Re: Small InnoDB table with many concurrent queries

Once your tables' engine are all of innodb, your configuration file has to be changed to fit innodb's feature, not myisam. On Tue, Apr 21, 2009 at 2:09 PM, living liquid | Christian Meisinger < c.meisin...@livingliquid.com> wrote: > ah sorry... there are a few UPDATEs too but most is SELECTs...

Re: Sun bought by Oracle

Waiting for more interesting points. On Tue, Apr 21, 2009 at 1:42 PM, Manish Gupta wrote: > http://www.sun.com/third-party/global/oracle/ > > anyone saw this ?? > > On Tue, Apr 21, 2009 at 2:54 AM, John Meyer > wrote: > > > Yep. In particular the anti-trust division of the DOJ. > > Kaushal Shriy

Re: Small InnoDB table with many concurrent queries

ah sorry... there are a few UPDATEs too but most is SELECTs... 60:40 i would say. > Excuse me. But why concurrent queries request table locks? > > 2009/4/20 living liquid | Christian Meisinger > >> Hi there. >> >> I've a small table with my daily banner hits. >> 1. version was with myisam but

Re: Sun bought by Oracle

http://www.sun.com/third-party/global/oracle/ anyone saw this ?? On Tue, Apr 21, 2009 at 2:54 AM, John Meyer wrote: > Yep. In particular the anti-trust division of the DOJ. > Kaushal Shriyan wrote: > > > > On Mon, Apr 20, 2009 at 11:14 PM, John Meyer > > wrote: >

Re: Sun bought by Oracle

Yep. In particular the anti-trust division of the DOJ. Kaushal Shriyan wrote: > > On Mon, Apr 20, 2009 at 11:14 PM, John Meyer > wrote: > > I'm wondering what the DOJ is going to think of that deal. > > -- > MySQL General Mailing List > For list archi

RE: A good US Hosting Site?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 22:29 To: Mark Cc: mysql@lists.mysql.com Subject: Re: A good US Hosting Site? > Mark wrote: > > Yeah, but a "Maximum file size limit 500 KB," what can you do with > > that?? Your average b

Re: A good US Hosting Site?

Mark wrote: Yeah, but a "Maximum file size limit 500 KB," what can you do with that?? Your average background image is bigger! Not to mention my MySQL really? you use background images bigger than 500kb? lucky if you get a second visit! mysql database of course has nothing to do with that

Re: Sun bought by Oracle

Quite frankly, if MySQL gets neglected in the future, I'll switch to PostgreSQL, as simple as that. However, the acquisition of Sun does place Oracle in an interesting market position - "the enterprise Apple" as mentioned in the ZDNet article. Let's see and hope the best. Cheers, Michael O

Re: A good US Hosting Site?

I would recommend PilotPig << http://www.pilotpig.net/ >> Good service, good support, reasonably priced, and integrity to boot. David

RE: A good US Hosting Site?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 17:22 To: Mark Cc: mysql@lists.mysql.com Subject: Re: A good US Hosting Site? > Well, > > not a joke for free hosting. > > But it is, for me, by far the best hosting site. > > Compleat,

Re: Sun bought by Oracle

We are talking of financial moves here. I think nothing will be touched at least for first years, I don't see product or services overlapping. Oracle is one thing, MySQL another. If they are so crazy to 'shut-down' MySQL, the second after there would be the fork, MySQL could be 'closed', but t

Re: Sun bought by Oracle

On Mon, Apr 20, 2009 at 11:14 PM, John Meyer wrote: > I'm wondering what the DOJ is going to think of that deal. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com > > DOJ ? does it

Re: Sun bought by Oracle

I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Small InnoDB table with many concurrent queries

MyISAM should be fine with many SELECTs running at once. Tables are only locked for INSERTs DELETEs and UPDATEs, and conditionally at that. You can set MySQL to always append INSERTs to the end of the file so you can insert while selecting. What is the whole picture? If you were having locking pro

Re: Sun bought by Oracle

I don't think the purchase was about MySQL at all. I'm sure Oracle is far more interested in java, zfs, and solaris than they are MySQL. MySQL is just an added bonus that will go well with their acquisition of Innobase Oy a few years ago. Oracle didn't kill InnoDB and it's not very likely that they

RE: Sun bought by Oracle

> From: Peter Brawley [mailto:peter.braw...@earthlink.net] > > An optimist wrote that. A pessimist, Larry Dignan at > http://blogs.zdnet.com/BTL/?p=16598&tag=nl.e539, wrote point six: > > "Oracle gets to kill MySQL. There's no way Ellison will let that > open source database mess with the ma

UNIX_TIMESTAMP - Can anyone explain this behavior?

Hi all, Does anyone know what is going on here: //Query: select UNIX_TIMESTAMP(TIMESTAMP('2003-01-01 00:00:00')) as first, UNIX_TIMESTAMP(TIMESTAMP('2003-10-05 00:00:00')) as second, UNIX_TIMESTAMP(TIMESTAMP('2004-01-01 00:00:00')) as third; ++++ | first

Re: Sun bought by Oracle

... the points behind the purchase: 1. To obtain the Sun hardware and thus provide a complete hardware and software solution. 2. To further optimize Oracle to take full advantage of the Solaris OS. 3. To continue to support Linux. 4. To get Java and thus penetrate the mobile device marketplace

Re: A good US Hosting Site?

I've been using www.host45.com for some years. linux and they've always been reliable. :-) -- unheralded genius: "A clean desk is the sign of a dull mind. " - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.

Re: Sun bought by Oracle

I think that you'e being paranoid. IMO, Oracle will continue to support and develop mySQL. Further, I think that these concerns about the future of mySQL overlook the points behind the purchase: 1. To obtain the Sun hardware and thus provide a complete hardware and software solution. 2. To further

Re: Sun bought by Oracle

At 08:22 AM 4/20/2009, Krishna Chandra Prajapati wrote: Whats the future of 'MySQL' under Oracle ? Here is a blog on ZDNet in case anyone is interested. http://blogs.zdnet.com/BTL/?p=16598&tag=nl.e539 Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: A good US Hosting Site?

I haven't had a problem with Hostgator yet. Prices are fair and reasonable Also I've installed web apps through their portal and on my own and haven't had a problem yet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?u

Re: Sun bought by Oracle

I figure that they'll either kill mysql or they'll limit the commnunity version in ways that will make you purchase a commercial version if you want to continue to use it. I figure there will be heavy migrations to open source alternatives. --C Andy Shellam wrote: I've just been made aware b

Re: A good US Hosting Site?

Well, not a joke for free hosting. But it is, for me, by far the best hosting site. Compleat, easy to use, five subdomains, and also mysql included. Paid hosting is outstanding. Cheers Claudio 2009/4/20 Mark > -Original Message- > From: Claudio Nanni [mailto:claudio.na...@gmail.com

Re: Small InnoDB table with many concurrent queries

change connect timeout to 10sec flatly use skip-name-resolve whats the total size of your database. On Mon, Apr 20, 2009 at 7:58 PM, living liquid | Christian Meisinger < c.meisin...@livingliquid.com> wrote: > Hi there. > > I've a small table with my daily banner hits. > 1. version was with myis

Re: Sun bought by Oracle

At 08:31 AM 4/20/2009, you wrote: Only time will tell what will happen, but I have read a few articles saying Oracle had been interested specifically in buying MySQL from Sun as it gives them an open source DB offering (which they dont have now right?), and that brings with it contact with potent

Small InnoDB table with many concurrent queries

Hi there. I've a small table with my daily banner hits. 1. version was with myisam but with a lot of concurrent queries (all SELECTs) i get too many table locks. so i changed it to an innodb table. works great most of the time. sometimes it seems to be too much, starting at about 500 concurrent

Re: A good US Hosting Site?

On Sun, Apr 19, 2009 at 23:42, Cameron Rogers wrote: > Hi everyone. I am starting my first web site. I have a temporary contract > with godaddy but know there are better options out there. The only problem > is, I don't know reliable sources to research which hosting program to use. > Any reco

Re: Sun bought by Oracle

Only time will tell what will happen, but I have read a few articles saying Oracle had been interested specifically in buying MySQL from Sun as it gives them an open source DB offering (which they dont have now right?), and that brings with it contact with potential customers for support or

Re: Sun bought by Oracle

Whats the future of 'MySQL' under Oracle ? On Mon, Apr 20, 2009 at 6:45 PM, Andy Shellam wrote: > I've just been made aware by a client that Oracle have purchased Sun > Microsystems. The article below on Sun's website mentions that Oracle are > committed to Linux and "other open platforms" and m

Sun bought by Oracle

I've just been made aware by a client that Oracle have purchased Sun Microsystems. The article below on Sun's website mentions that Oracle are committed to Linux and "other open platforms" and mentions the fact that Java touches practically every business system around. http://www.sun.com/thi

RE: A good US Hosting Site?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 10:28 To: p...@pwilson.net Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com Subject: Re: A good US Hosting Site? > www.awardspace.com > > I have both free and paid hosting and

RE: Need help with mysql prob

> Date: Mon, 20 Apr 2009 13:03:14 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi Alugo, > > abdulazeez alugo wrote: > > > > Hi Andy, > > Thank you very much you have been really very helpful. All tho

Re: Need help with mysql prob

Hi Alugo, abdulazeez alugo wrote: Hi Andy, Thank you very much you have been really very helpful. All those mistakes you pointed at in the script about the apostrophe and others, are simple mistakes I just made in the rush of typing the message; and yes $conn is the result from mysql_connect

RE: Need help with mysql prob

> Date: Mon, 20 Apr 2009 08:06:05 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi, > > abdulazeez alugo wrote: > > > >> Date: Sun, 19 Apr 2009 23:19:56 +0100 > >> From: andy-li...@networkmail.eu > >>

Fwd: Does mysql support materialized views?

Query cache stores "select" query together with its results. When the same query is sent again, result from the cache is returned. Whenever some table is modified, all cache entries referencing it are deleted. That happens even when modification doesn't affect cached rows, eg.: SELECT a FROM a_ta

Re: Does mysql support materialized views?

On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun wrote: > Hi  Olexandr Melnyk > > That's to say, create the aggregation tables and update them by triggers? > I've noticed a "update view" in Mysql , can it work under the aggretate > operation? You're not looking for views, you need to use normal tables.

Re: Does mysql support materialized views?

On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote: No, you will have to "emulate" them using triggers or stored procedures. Or: 1. Create table "this_is_not_a_view" and use that as the materialized view 2. Build a new version in the background "this_is_not_a_view_pending" as per your

Re: Does mysql support materialized views?

No, you will have to "emulate" them using triggers or stored procedures. On Mon, Apr 20, 2009 at 12:28 PM, Lin Chun wrote: > Hi > > I am now working with Mondrian , and need  tuning the database, as the > materialized views can improve the performance > and doesn't need to create the fact tables

Re: Does mysql support materialized views?

No On Mon, Apr 20, 2009 at 2:58 PM, Lin Chun wrote: > Hi > > I am now working with Mondrian , and need tuning the database, as the > materialized views can improve the performance > and doesn't need to create the fact tables > > > > cheers > -- > - > Lin Chun > -- Kr

Does mysql support materialized views?

Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun

Re: A good US Hosting Site?

www.awardspace.com I have both free and paid hosting and it is really really good, it has a lot of tools. Claudio 2009/4/20 Pete Wilson > > > http://www.kionic.com > > I've been a very active and heavy customer for years and very satisfied. > > -- Pete Wilson > http://www.pwilson.net/ > > >

Re: Need help with mysql prob

Hi, abdulazeez alugo wrote: Date: Sun, 19 Apr 2009 23:19:56 +0100 From: andy-li...@networkmail.eu To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Need help with mysql prob Hi Alugo, Hi Andy, Thanks for your prompt response. However, since tbl1_id has an auto_increment