Re: Help Save MySQL

2009-12-17 Thread Claudio Nanni
I am in! Bruno B. B. Magalhaes wrote: Hi Guys, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants mysql to go forward would contribute from $500,00 to $1500,00, how much are we talking about? And we would have a 100% community owned and community

RE: Innodb buffer pool size filling up

2009-12-17 Thread machiel.richards
Good Morning all QUOTE: "We have a MySQL database where the INNODB_BUFFER_POOL_SIZE keeps on filling up" I have monitored this issue for the last couple of weeks and even though the buffer pool usage is increasing slowly, it is still headi

Re: Join using Table1 or Table2 - depending on content of rel table

2009-12-17 Thread Shawn Green
Miguel Vaz wrote: Hi, How would one go about doing this: - I have 3 tables: - A relationship table(REL), then TABLE1 and TABLE2: REL TABLE has fields: . ID . TYPE - type of event . ID_EVENT - id of event, but this id will either point to TABLE1 or TABLE2, depending on the content of the fiel

Re: Lesser of two values in list

2009-12-17 Thread Peter Brawley
>I need to find the lesser of two values provided in a list LEAST(). PB http://www.artfulsoftware.com - Cantwell, Bryan wrote: I need to find the lesser of two values provided in a list. I know I can do it with a couple of IF's in a function, but I'd really like to know if there is alre

Lesser of two values in list

2009-12-17 Thread Cantwell, Bryan
I need to find the lesser of two values provided in a list. I know I can do it with a couple of IF's in a function, but I'd really like to know if there is already a function that I can use. min(12,3,1,4) of course doesnt work, but is there some other math function I am overlooking in MySql? -

Re: copying a static table

2009-12-17 Thread Michael Dykman
Tom, For MyISAM tables, as long as you aren't overlapping your update cycles, I can see nothing wrong with this. We used to rync to prepare slaves under inndb: do a broken rsync from the live data files on the master to the archives.. when that is complete, the result file is quite broken but si

RE: Help Save MySQL

2009-12-17 Thread John Daisley
Bruno, I wasn't exactly joking when i suggested users put up an offer but the complexity of doing so is huge. I don't know what value Sun or Oracle would put on MySQL as it stands and there are lots of issues not least those existing MySQL customers with contracts which need to be honoured by

copying a static table

2009-12-17 Thread Tom Worster
i have a large myisam table (about 3gb) that is updated once a day in the middle of the night. when it is not being updated, is there any reason not to copy it out with rsync without shutting down the server or flush tables with read lock or whatever? -- MySQL General Mailing List For list arc

RE: Spatial extensions

2009-12-17 Thread Gavin Towey
Not only is it 5.1, but there's a special branch that has improved GIS functions not found in the regular MySQL. I'm not sure if/when they're planning on rolling them back into mysql: http://downloads.mysql.com/forge/mysql-5.1.35-gis/ If it's not possible to use that version, then you can stil

Re: Help saving MySQL

2009-12-17 Thread Bruno B. B. Magalhaes
Martjin, I really don't like to point fingers or anything like that, but the simple fact Oracle owns the MySQL copyrights is by it self very concerning, as all our investments (time and money) could be lost over night, if Oracles decides to close de source or change it's licensing policies. Man

Re: Help saving MySQL

2009-12-17 Thread Martijn Tonies
John, Another read on the subject: http://blogs.the451group.com/opensource/2009/12/10/the-case-against-the-case-against-oracle-mysql/ Enjoy. With regards, Martijn Tonies Upscene Productions http://www.upscene.com I see some of your point Martin but I think the eu would look at that letter a

Re: Help Save MySQL

2009-12-17 Thread Martijn Tonies
Maybe a three-years consul composed from and elected by the community (by community I mean the people >that contributed with funds, not the user community) by voting? I have been quite closely involved in doing this for the Firebird project, you would be amazed as to how hard it is to get thing

Re: Help Save MySQL

2009-12-17 Thread Bruno B. B. Magalhaes
Maybe a three-years consul composed from and elected by the community (by community I mean the people that contributed with funds, not the user community) by voting? Regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035, Br

Re: Help Save MySQL

2009-12-17 Thread Martijn Tonies
Hey, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants mysql to go >forward would contribute from $500,00 to $1500,00, how much are we talking about? And we would have a >100% community owned and community driven open source initiative... Course

Re: Spatial extensions

2009-12-17 Thread Jim Ginn
Rene: We've easily integrated GIS with MySQL into our sites: http://tenant.com/map-search.php http://yearlyrentals.com http://acnj.com/map.php ... Thanks! Jim Ginn Visit My Work (888) 546-4466 office (609) 226-5709 cell > Awesome, this is what I was trying to find, as you succinctly wro

Re: Help saving MySQL

2009-12-17 Thread Gene Heskett
On Thursday 17 December 2009, Daisley, John (Burton) wrote: >I think that letter actually does MySQL a favour as it points out > >'MySQL has been used as a pricing lever by Oracle customers' > >That single factor says Oracle should not be allowed to control MySQL as it > would enable Oracle to mor

Re: Spatial extensions

2009-12-17 Thread René Fournier
Awesome, this is what I was trying to find, as you succinctly wrote it. I *really* appreciate getting pointed in the right direction, since I haven't found a lot of MySQL's GIS tutorials directed at what I'm trying to do. Still, a couple questions, the Distance() function you included, that must

Re: Help Save MySQL

2009-12-17 Thread Bruno B. B. Magalhaes
Hi Guys, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants mysql to go forward would contribute from $500,00 to $1500,00, how much are we talking about? And we would have a 100% community owned and community driven open source initiative... Course

RE: Help Save MySQL

2009-12-17 Thread Neil Aggarwal
> If that’s what the price is going to be then perhaps I should > offer 2€ or maybe MySQL users should get together submit a > realistic offer. This sounds interesting... Get a community effort to accept donations and purchase MySQL. Then, put it under the GPL and make sure nobody owns it.

Re: Importing large databases faster

2009-12-17 Thread mos
At 03:59 AM 12/17/2009, you wrote: Madison Kelly wrote: Hi all, I've got a fairly large set of databases I'm backing up each Friday. The dump takes about 12.5h to finish, generating a ~172 GB file. When I try to load it though, *after* manually dumping the old databases, it takes 1.5~2 days

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-17 Thread Jerry Schwartz
>-Original Message- >From: Edward S.P. Leong [mailto:edward...@ita.org.mo] >Sent: Thursday, December 17, 2009 7:25 AM >To: mysql@lists.mysql.com >Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server >performance > >Dear all, > >Would you mind to give me the suggestion ? >I wa

Re: Help saving MySQL

2009-12-17 Thread Martijn Tonies
I see some of your point Martin but I think the eu would look at that letter and see the author is stating 'MySQL has been used as a pricing lever'. That single factor should be enough for them to be very concerned by an acquisition as removing an effective pricing lever from the market by acqui

Re: Simple Query Question

2009-12-17 Thread Ian
Hi, Thanks, I just checked and it was a memcache that was caching the output. See I knew it was a simple solution ;) Thanks for the effort everyone and sorry for wasting time. Regards Ian 2009/12/17 Aleksandar Bradaric > Hi Ian, > > Why do you think something's wrong? Here is my test data and

32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

2009-12-17 Thread Edward S.P. Leong
Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Re: Simple Query Question

2009-12-17 Thread Aleksandar Bradaric
Hi Ian, Why do you think something's wrong? Here is my test data and the results of your query: --- mysql> SELECT * FROM wp_views; +-+-++---+ | blog_id | post_id | date | views | +-+-++---+ | 1 | 1 | 2009-12-16 |

Simple Query Question

2009-12-17 Thread Ian
Hi, I am sure there is a simple solution to this problem, I just cant find it :) I have got a table that records views for an article for each blog per day. So the structure is as follows: CREATE TABLE `wp_views` ( `blog_id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `date` date NOT NULL, `vi

RE: Help saving MySQL

2009-12-17 Thread Daisley, John (Burton)
I see some of your point Martin but I think the eu would look at that letter and see the author is stating 'MySQL has been used as a pricing lever'. That single factor should be enough for them to be very concerned by an acquisition as removing an effective pricing lever from the market by acq

Help Save MySQL

2009-12-17 Thread Daisley, John (Burton)
Just wanted to see what people thought about the offer from Nexedi for MySQL http://www.nexedi.com/NXD-MySQL.Takeover/view They obviously have more reason to protect and develop MySQL but are they serious? 1€ for a profitable business unit with a turnover of around $100m. If that’s what the pr

Re: Importing large databases faster

2009-12-17 Thread Jay Ess
Madison Kelly wrote: Hi all, I've got a fairly large set of databases I'm backing up each Friday. The dump takes about 12.5h to finish, generating a ~172 GB file. When I try to load it though, *after* manually dumping the old databases, it takes 1.5~2 days to load the same databases. I am gue

Re: Help saving MySQL

2009-12-17 Thread Martijn Tonies
I think that letter actually does MySQL a favour as it points out 'MySQL has been used as a pricing lever by Oracle customers' That single factor says Oracle should not be allowed to control MySQL as it would enable Oracle to more >easily raise or maintain high prices! For something to be an

RE: Help saving MySQL

2009-12-17 Thread Daisley, John (Burton)
I think that letter actually does MySQL a favour as it points out 'MySQL has been used as a pricing lever by Oracle customers' That single factor says Oracle should not be allowed to control MySQL as it would enable Oracle to more easily raise or maintain high prices! For something to be an e