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
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 pete...@yahoo.com
http://www.kionic.com
I've been a very active and heavy customer for years and very satisfied.
-- Pete Wilson
No, you will have to emulate them using triggers or stored procedures.
On Mon, Apr 20, 2009 at 12:28 PM, Lin Chun franks1...@gmail.com 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
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 data
On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com 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
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
No
On Mon, Apr 20, 2009 at 2:58 PM, Lin Chun franks1...@gmail.com 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
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
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
To:
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
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 those
mistakes
-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 it
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.
Whats the future of 'MySQL' under Oracle ?
On Mon, Apr 20, 2009 at 6:45 PM, Andy Shellam andy-li...@networkmail.euwrote:
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
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
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers cameronl...@gmail.com 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
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
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
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 myisam
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 ad...@asarian-host.net
-Original Message-
From: Claudio Nanni
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
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:
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=16598tag=nl.e539
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
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
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
... 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
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
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
An optimist wrote that. A pessimist, Larry Dignan at
http://blogs.zdnet.com/BTL/?p=16598tag=nl.e539, wrote point six:
Oracle gets to kill MySQL. There's no way Ellison will let that
open source database mess with the margins of
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
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
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
On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com 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
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
-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, easy
I would recommend PilotPig http://www.pilotpig.net/
Good service, good support, reasonably priced, and integrity to boot.
David
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
On
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
-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
Yep. In particular the anti-trust division of the DOJ.
Kaushal Shriyan wrote:
On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com
mailto:john.l.me...@gmail.com wrote:
I'm wondering what the DOJ is going to think of that deal.
--
MySQL General Mailing List
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 division of the DOJ.
Kaushal Shriyan wrote:
On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com
40 matches
Mail list logo