Re: Small InnoDB table with many concurrent queries

2009-04-21 Thread living liquid | Christian Meisinger
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 c.meisin...@livingliquid.com Hi there. I've a small table with my daily banner hits. 1. version

Re: Sun bought by Oracle

2009-04-21 Thread Moon's Father
Waiting for more interesting points. On Tue, Apr 21, 2009 at 1:42 PM, Manish Gupta manish.in@gmail.comwrote: http://www.sun.com/third-party/global/oracle/ anyone saw this ?? On Tue, Apr 21, 2009 at 2:54 AM, John Meyer john.l.me...@gmail.com wrote: Yep. In particular the anti-trust

Re: Small InnoDB table with many concurrent queries

2009-04-21 Thread Moon's Father
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: A good US Hosting Site?

2009-04-21 Thread Mark
Okay, does anyone know of a hosting site that supports 'Image::Magick'? (the Perl package). The salesrep at AwardSpace said they didn't have it. P.S. This is probably getting a mite off-topic. So, feel free to reply to me off-list, if you happen to know the answer. Thanks, - Mark -- MySQL

Re: UNIX_TIMESTAMP - Can anyone explain this behavior?

2009-04-21 Thread Martijn Engler
Hi Keith, I'm not sure, but this might be DST that's in your way. Have you looked into that? Have a nice day, - Martijn On Mon, Apr 20, 2009 at 18:34, Keith Hughitt keith.hugh...@gmail.com wrote: Hi all, Does anyone know what is going on here: //Query: select

Oracle , what else ?

2009-04-21 Thread Gilles MISSONNIER
hello people, bad joke is not it ? After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - g...@iap.fr 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Oracle , what else ?

2009-04-21 Thread Simon Connah
On 21 Apr 2009, at 14:06, Gilles MISSONNIER wrote: hello people, bad joke is not it ? After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? I don't see what the problem is really. Anyway if there ever is a problem in the future (which I

Re: Oracle , what else ?

2009-04-21 Thread Martijn Tonies
Hey Gilles, After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? Not sure what we are gonna run, but my office is continuing to run MySQL when required, Firebird otherwise :-) With regards, Martijn Tonies Upscene Productions

Re: Sun bought by Oracle

2009-04-21 Thread russbucket
Arthur Fuller wrote: 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

mysql problem

2009-04-21 Thread AZZOPARDI Konrad
Hello people,   I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45  {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there including the

Re: mysql problem

2009-04-21 Thread Gerald L. Clark
AZZOPARDI Konrad wrote: Hello people, I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there

Re: Oracle , what else ?

2009-04-21 Thread mos
At 08:06 AM 4/21/2009, Gilles MISSONNIER wrote: hello people, bad joke is not it ? After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? It seems like the little fish are getting eaten by the bigger fish. I understand Microsoft is now going to

Re: mysql problem

2009-04-21 Thread Thomas Pundt
Konrad, AZZOPARDI Konrad schrieb: Hello people, I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems

Re: Sun bought by Oracle

2009-04-21 Thread Arthur Fuller
I too am a big entusiast of Sun's VirtualBox, and I hope that nothing goes sideways on this product. A. effects and that is VirtualBox. I've used MySQL for years and hope Oracle does not stop it, but you never know with Ellison encharge! Just my 2 cents. --

RE: Sun bought by Oracle

2009-04-21 Thread Joshua Gordon
I hope I start getting paid what Oracle DBA's make. -Original Message- From: Arthur Fuller [mailto:fuller.art...@gmail.com] Sent: Tuesday, April 21, 2009 12:04 PM To: russbucket Cc: mysql@lists.mysql.com Subject: Re: Sun bought by Oracle I too am a big entusiast of Sun's VirtualBox, and

Two COUNTs in one query

2009-04-21 Thread Nigel Peck
I think I probably can't do what I want, but am hoping I'm wrong. Please help :) I have three tables: Organisations - organisation_id - name - - 1 - Org A - - 2 - Org B -

Seeking MySQL Server Internals Developers

2009-04-21 Thread Hiromichi Watari
We are in early stage of a start-up seeking MySQL server internals developers. The developers will be involved in an effort to accelerate execution of a MySQL query with a multi-core CPU running concurrent slave threads. The effort will be made as modifications to a current release version of

Re: Two COUNTs in one query

2009-04-21 Thread Peter Brawley
Nigel, I want to select the name and id from Organisations along with a count of the number of one-to-many relationships it has in each of the two tables. Aggregation multiplies across multiple joins. For suggested solutions see Aggregates across multiple joins at

Re: Oracle , what else ?

2009-04-21 Thread Andy Shellam
Hi, To see what will happen to MySQL take a look at how Oracle handled InnoDb. How many updates have they released since they purchased it? I really don't know so someone will need to check. Is Oracle is too big to make MySQL updates any kind of priority? It seems that the larger the company

Optimizing iowait with tmpdir and tmpfs or ramfs?

2009-04-21 Thread Milan Andric
Hello, I have a rather burly Drupal based site that seems to be causing some problems, today we had a major outage. There are many slow queries and also mysql related iowait that causes server processes to hang, at least that is the theory. Here you can examine some of the stats on the server:

Re: Oracle , what else ?

2009-04-21 Thread John Daisley
MySQL will live on regardless of who owns the brand. First and foremost MySQL is a community and that community will continue to develop MySQL and take it in the direction they want it to go. Sure Oracle could try and force some 'features' or changes through but if the community didn't like them

Re: Oracle , what else ?

2009-04-21 Thread Arthur Fuller
I hereby bet the farm that this shall not occur. I have $10 to say that this shall not occur. a) Who is going to challenge the deal? b) What possible purpose would it serve to interr MySQL? c) Assuming there is some reason for b) above, why incur the wrath of the MySQL community and their

Re: Oracle , what else ?

2009-04-21 Thread Néstor
It will great if the MYSQL guys were to buy mysql from Oracle for half the price that Sun paid. They would come out making lots of money and back controlling their own destiny. :-) On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller fuller.art...@gmail.comwrote: I hereby bet the farm that this