Re: Oracle, Sun and MySQL

2009-11-11 Thread John Daisley
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

Re: storage difference in VARCHAR(size)?

2009-11-11 Thread Martijn Tonies
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

Re: Oracle, Sun and MySQL

2009-11-11 Thread Xiong HE
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 john.dais...@butterflysystems.co.uk What I am more concerned

Re: Oracle, Sun and MySQL

2009-11-11 Thread Elizabeth Mattijsen
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 2009;

mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
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..

MySQL University session on November 12: Gearman for MySQL

2009-11-11 Thread Stefan Hinz
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

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
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 to

Re: mysql server is not starting

2009-11-11 Thread Krishna Chandra Prajapati
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 sac.fai...@gmail.com 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

Re: mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
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 ..

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
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

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
...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

Re: mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
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

Re: mysql server is not starting

2009-11-11 Thread F.A.I.Z.A.L
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

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
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.. folder is

Re: Oracle, Sun and MySQL

2009-11-11 Thread John Daisley
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 2009;

Re: Oracle, Sun and MySQL

2009-11-11 Thread Peter Brawley
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:

Re: storage difference in VARCHAR(size)?

2009-11-11 Thread Johan De Meersman
Your mail suggests that you *are* seeing a difference, though. What are you seeing? On 11/11/09, Martijn Tonies m.ton...@upscene.com wrote: You have stumbled across the secret. No, there is no difference at all as the calculations suggested here confirm.

Re: storage difference in VARCHAR(size)?

2009-11-11 Thread Waynn Lue
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 vegiv...@tuxera.bewrote: Your mail suggests that you *are* seeing a difference, though.

Re: storage difference in VARCHAR(size)?

2009-11-11 Thread Martijn Tonies
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 when

Re: storage difference in VARCHAR(size)?

2009-11-11 Thread Johan De Meersman
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 m.ton...@upscene.com wrote: Your mail suggests that you *are* seeing a difference, though. What are you seeing? What I was saying,

query cache extension

2009-11-11 Thread Amila Liyanaarachchi
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