Hi,
I'm thinking of extending the query cache to deal with following scenarios,
1. stop invalidating the cache entries when updates take place for
columns which are not in the select list of the cached queries
2. when a second query contains a subset of columns from a first query
(which has cache
Aware of that, but char brings you certain performance benefits that
are good to know about if you need every last drop of juice :-)
On 11/11/09, Martijn Tonies wrote:
>
>
>> Your mail suggests that you *are* seeing a difference, though. What
>> are you seeing?
>
> What I was saying, is that VARC
Your mail suggests that you *are* seeing a difference, though. What
are you seeing?
What I was saying, is that VARCHAR takes up space "l" (= length)
of the data plus 1 or 2 bytes to store the length, while CHAR takes
up the full space of the -defined- column size.
This is rather wasteful whe
Oh, I wasn't seeing a difference, I just wanted to make sure I understood
how the two choices affected our system.
Thanks so much for all the answers!
On Wed, Nov 11, 2009 at 11:12 AM, Johan De Meersman wrote:
> Your mail suggests that you *are* seeing a difference, though. What
> are you seeing
Your mail suggests that you *are* seeing a difference, though. What
are you seeing?
On 11/11/09, Martijn Tonies wrote:
>>You have stumbled across the secret. No, there is no difference at
>>all as the calculations suggested here confirm.
>>
>>http://dev.mysql.com/doc/refman/5.1/en/storage-requir
Martin,
> What does monty say?
Monty made a submission to EU regulators. I can't find the URL just now.
One-line summary: "Letting Oracle have MySQL is worse than putting the
fox in charge of the henhouse..." (Florian Mueller,
http://news.cnet.com/8301-13578_3-10379870-38.html).
Other URLs:
> On Nov 11, 2009, at 9:34 AM, John Daisley wrote:
>> On Tue, 2009-11-10 at 23:50 -0600, Peter Brawley wrote:
>>> European regulators agree with Monty that the Oracle-Sun deal threatens
>>> database competition. Apparently Oracle means to play hardball.
>>> Meanwhile
>>> Sun revenue fell 25% in 3rd
in your my.cnf is the data dir
"datadir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641"
in your list it should be :
"datadir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/data"
is this correct?
F.A.I.Z.A.L schrieb:
> yes.. folde
error log also having the same information..
do u feel any problem with the installation. bcos i could the files are
installed in different locations.any suggestion..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Nov 11, 2009 at 5:12 PM, Krishna Chandra Praj
yes.. folder is exist. but don't know why its not starting..
these are the files exist in the folder
drwx-- 2 amssys amssys 1536 Nov 11 17:12 bin
drwx-- 4 amssys amssys 512 Nov 11 12:52 data
drwx-- 2 amssys amssys 512 Apr 1 2009 docs
drwx-- 2 amssy
"...mysql_upgrade examines all tables in all databases for
incompatibilities with the current version of MySQL Server.
mysql_upgrade also upgrades the system tables so that you can take
advantage of new privileges or capabilities that might have been added"
http://dev.mysql.com/doc/refman/5.1/
hi,
exists this folder on your System?
/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit
F.A.I.Z.A.L schrieb:
> hi
>
> thanks for your reply,,
>
> i can see only limited parameters are there in my.cnf
>
> basedir=/var/LRM-INSTALL/ams/soft
hi
thanks for your reply,,
i can see only limited parameters are there in my.cnf
basedir=/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris
but this is not in /usr/local/mysql..
if u see my error log. it ask me to run mysql_upgrade. why it is asking ..
a
Hi faizal,
Check your mysql error log file.
Thanks,
Krishna
On Wed, Nov 11, 2009 at 4:17 PM, F.A.I.Z.A.L wrote:
> hi iam trying to start mysql services but it showing error. while i start
> it
> automatically goes to shutdown..
>
> what is errmsg.sys? its looking this file but it was not there
Check that your my.ini or my.cnf has the correct entry for the Basedir
option.
F.A.I.Z.A.L schrieb:
> hi iam trying to start mysql services but it showing error. while i start it
> automatically goes to shutdown..
>
> what is errmsg.sys? its looking this file but it was not there.. please help
>
Gearman for MySQL
http://forge.mysql.com/wiki/Gearman_for_MySQL
This Thursday (November 12th, 14:00 UTC), Giuseppe Maxia of the MySQL
Community Team will present Gearman for MySQL. Gearman is a
client/server infrastructure for generic tasks, usable on distributed
servers, with little worry about t
hi iam trying to start mysql services but it showing error. while i start it
automatically goes to shutdown..
what is errmsg.sys? its looking this file but it was not there.. please help
to fix this..
/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-spa
On Nov 11, 2009, at 9:34 AM, John Daisley wrote:
> On Tue, 2009-11-10 at 23:50 -0600, Peter Brawley wrote:
>> European regulators agree with Monty that the Oracle-Sun deal threatens
>> database competition. Apparently Oracle means to play hardball. Meanwhile
>> Sun revenue fell 25% in 3rd quarter 2
I believe MySQL will still have great influence in Open Source area.
The better is that MySQL will be a separate Company which has no relation to
Sun and Oracle.
Maybe Oracle can sell MySQL to a 3rd company.
2009/11/11 John Daisley
> What I am more concerned about at the moment is how much the u
You have stumbled across the secret. No, there is no difference at
all as the calculations suggested here confirm.
http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html
Note: as you can see in the above, CHAR data DOES take up room for it's
full size, stupidly enough.
On Tue, Nov 1
What I am more concerned about at the moment is how much the uncertainty
over the deal is hurting MySQL?
I was recently in a project planning meeting where MySQL was dismissed
completely because nobody could give guarantees about where MySQL was
going. There were a lot of concerns over where futur
21 matches
Mail list logo
