Re: Oracle, Sun and MySQL

[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 future development would
go and a fear that when the deal goes through Oracle may slowly raise
support and training costs to the sort of levels applicable to Oracle
database products. These kind of arguments seem impossible to counter
for as long as the uncertainty continues and I for one wish they would
just resolve the situation either way very quickly because its hurting
my business and open source software!

regards
John 


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; who else but an anti-competitive
> giant would take a chance on buying Sun now? Story here:
> http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272&;
> source=features_box1.
> 
> PB


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: storage difference in VARCHAR(size)?

[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 10, 2009 at 6:37 PM, Waynn Lue  wrote:

Hey all,

I was building a table for storing email addresses today and ran into an
issue that I couldn't find an answer for using Google. If I declare the
column as a VARCHAR (this is an InnoDB table), does it matter what size I
declare it as if it's between 1 and 255? I know there's an extra byte of
storage once it goes above 255 because of the length, but is there a 
storage

difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
functional difference in what gets cut off when I try to store into that
table, but is that the only difference?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Oracle, Sun and MySQL

[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 

> 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 future development would
> go and a fear that when the deal goes through Oracle may slowly raise
> support and training costs to the sort of levels applicable to Oracle
> database products. These kind of arguments seem impossible to counter
> for as long as the uncertainty continues and I for one wish they would
> just resolve the situation either way very quickly because its hurting
> my business and open source software!
>
> regards
> John
>
>
> 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; who else but an
> anti-competitive
> > giant would take a chance on buying Sun now? Story here:
> >
> http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272&;
> > source=features_box1.
> >
> > PB
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=hexi...@gmail.com
>
>


-- 
Thanks & Best regards,
Xiong HE

Re: Oracle, Sun and MySQL

[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; who else but an anti-competitive
>> giant would take a chance on buying Sun now? Story here:
>> http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272&;
>> source=features_box1.
> 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 future development would
> go and a fear that when the deal goes through Oracle may slowly raise
> support and training costs to the sort of levels applicable to Oracle
> database products. These kind of arguments seem impossible to counter
> for as long as the uncertainty continues and I for one wish they would
> just resolve the situation either way very quickly because its hurting
> my business and open source software!

Please remember that there are 3rd parties offering MySQL support already now, 
outside of MySQL AB.

I'm pretty sure that should Oracle raise these prices, 3rd parties will take up 
that part of the market pretty quickly.



Liz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysql server is not starting

[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..


/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
bash-3.00#
/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
-u root
09 16:14:01 [ERROR] Can't find messagefile
'/usr/local/mysql/share/english/errmsg.sys'
/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
Unknown error 1146
09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
09 16:14:01  InnoDB: Started; log sequence number 0 46409
09 16:14:01 [ERROR] Aborting

09 16:14:01  InnoDB: Starting shutdown...
09 16:14:02  InnoDB: Shutdown completed; log sequence number 0 46409
09 16:14:02 [Warning] Forcing shutdown of 1 plugins
09 16:14:02 [Note]


please help to solve

MySQL University session on November 12: Gearman for MySQL

[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 the details. No matter what language
you speak, Gearman can meet your needs in C, PHP, Perl, Ruby, shell
scripting, and several more. Gearman can also work in conjunction with
MySQL, either using UDFs, or simply through its basic architecture.
Giuseppe's talk will show examples of how to use Gearman for remote
installation and how to call a complicate data warehousing function
written in Perl from any other language, with no knowledge of Perl at all.

For MySQL University sessions, point your browser to this page:

http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity

You need a browser with a working Flash plugin. You may register for a
Dimdim account, but you don't have to. (Dimdim is the conferencing
system we're using for MySQL University sessions. It provides integrated
voice streaming, chat, whiteboard, session recording, and more.)

MySQL University is a free educational online program for
engineers/developers. MySQL University sessions are open to anyone, not
just Sun employees. Sessions are recorded (slides and audio), so if you
can't attend the live session you can look at the recording anytime
after the session.

Here's the schedule for the upcoming weeks:

* November 19: memcached Functions for MySQL (UDFs) (Patrick Galbraith)
* November 26: The Spider Storage Engine (Giuseppe Maxia)
* December  3: Practical Full-Text Search in MySQL (Bill Karwin)

The schedule is not engraved in stone at this point. Please visit
http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the
up-to-date list. On that page, you can also find the starting time for
many time zones.

Cheers,

Stefan
-- 
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.de/mysql  mailto: stefan.h...@sun.com

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql server is not starting

[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 fix this..
> 
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
> bash-3.00#
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
> -u root
> 09 16:14:01 [ERROR] Can't find messagefile
> '/usr/local/mysql/share/english/errmsg.sys'
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
> Unknown error 1146
> 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 09 16:14:01  InnoDB: Started; log sequence number 0 46409
> 09 16:14:01 [ERROR] Aborting
> 
> 09 16:14:01  InnoDB: Starting shutdown...
> 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0 46409
> 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
> 09 16:14:02 [Note]
> 
> 
> please help to solve
> 

-- 
--
S&P data GmbH
T 06131 218111
F 06131 218112
E schackenb...@termindoc.de
W www.termindoc.de

Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm

Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
der Schriftform versehen mit zwei Originalunterschriften.

Kommunikation über E-mail
Bei der Kommunikation über E-mail ist nicht in jedem Fall auszuschliessen,
dass Dritte unbefugt Kenntnis von den versandten Informationen nehmen.
Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass Ihnen
diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass wir
Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen anderen
Kommunikationsweg zu benennen.

Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
Betrachten den Acrobat Reader, den Sie hier erhalten können.
http://www.adobe.de/products/acrobat/readstep2.html
GF: Benedikt Schackenberg und Christian Peiter
AG & Sitz: Mainz am RheinHandelsregister: HR-B
8608 Umsatzsteuer ID: DE126633578

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql server is not starting

[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  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.. 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-sparc-64bit/bin
> bash-3.00#
>
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
> -u root
> 09 16:14:01 [ERROR] Can't find messagefile
> '/usr/local/mysql/share/english/errmsg.sys'
>
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
> Unknown error 1146
> 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 09 16:14:01  InnoDB: Started; log sequence number 0 46409
> 09 16:14:01 [ERROR] Aborting
>
> 09 16:14:01  InnoDB: Starting shutdown...
> 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0 46409
> 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
> 09 16:14:02 [Note]
>
>
> please help to solve
>

Re: mysql server is not starting

[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 ..
any idea




Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


2009/11/11 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 fix this..
> >
> >
> >
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
> > bash-3.00#
> >
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
> > -u root
> > 09 16:14:01 [ERROR] Can't find messagefile
> > '/usr/local/mysql/share/english/errmsg.sys'
> >
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
> > Unknown error 1146
> > 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
> > mysql_upgrade to create it.
> > 09 16:14:01  InnoDB: Started; log sequence number 0 46409
> > 09 16:14:01 [ERROR] Aborting
> >
> > 09 16:14:01  InnoDB: Starting shutdown...
> > 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0 46409
> > 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
> > 09 16:14:02 [Note]
> >
> >
> > please help to solve
> >
>
> --
> --
> S&P data GmbH
> T 06131 218111
> F 06131 218112
> E schackenb...@termindoc.de
> W www.termindoc.de
>
> Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm
>
> Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
> der Schriftform versehen mit zwei Originalunterschriften.
>
> Kommunikation über E-mail
> Bei der Kommunikation über E-mail ist nicht in jedem Fall auszuschliessen,
> dass Dritte unbefugt Kenntnis von den versandten Informationen nehmen.
> Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass Ihnen
> diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass wir
> Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen anderen
> Kommunikationsweg zu benennen.
>
> Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
> Betrachten den Acrobat Reader, den Sie hier erhalten können.
> http://www.adobe.de/products/acrobat/readstep2.html
> GF: Benedikt Schackenberg und Christian Peiter
> AG & Sitz: Mainz am RheinHandelsregister: HR-B
> 8608 Umsatzsteuer ID: DE126633578
>
port=3307
server-id=2229395502
basedir=/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit
datadir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641
pid-file=/tmp/mysql.pid
socket=/tmp/mysql.sock
expire_logs_days=2
max_connections=800
max_allowed_packet=128M
log-bin=emlplatform-bin
binlog-do-db=emlplatform
binlog-do-db=NI
sync-binlog=1
transaction-isolation=READ-COMMITTED
default-table-type=InnoDB
innodb
innodb_file_per_table
innodb_data_home_dir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641/ibdatadir
innodb_data_file_path=ibdata:100M:autoextend
innodb_flush_log_at_trx_commit=1
innodb_log_group_home_dir=/var/LRM-INSTALL/ams/database/lrm_2.0.0.0_9.0.0.0-76641/iblogs
character_set_server=utf8
collation_server=utf8_bin
innodb_buffer_pool_size=2000M
innodb_additional_mem_pool_size=340M
innodb_log_buffer_size=68M
innodb_log_file_size=512M
innodb_log_files_in_group=3
innodb_mirrored_log_groups=1
innodb_file_io_threads=4
innodb_lock_wait_timeout=300
binlog_format=row
net_read_timeout=3600
key_buffer=20M

[mysqld_safe]
user=amssys

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql server is not starting

[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
> 
> 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
> .. any idea
> 
> 
> 
> 
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
> 
> 
> 2009/11/11 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 fix this..
> >
> >
> >
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
> > bash-3.00#
> >
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
> > -u root
> > 09 16:14:01 [ERROR] Can't find messagefile
> > '/usr/local/mysql/share/english/errmsg.sys'
> >
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
> > Unknown error 1146
> > 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
> > mysql_upgrade to create it.
> > 09 16:14:01  InnoDB: Started; log sequence number 0 46409
> > 09 16:14:01 [ERROR] Aborting
> >
> > 09 16:14:01  InnoDB: Starting shutdown...
> > 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0
> 46409
> > 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
> > 09 16:14:02 [Note]
> >
> >
> > please help to solve
> >
> 
> --
> --
> S&P data GmbH
> T 06131 218111
> F 06131 218112
> E schackenb...@termindoc.de 
> W www.termindoc.de 
> 
> Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm
> 
> Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
> der Schriftform versehen mit zwei Originalunterschriften.
> 
> Kommunikation über E-mail
> Bei der Kommunikation über E-mail ist nicht in jedem Fall
> auszuschliessen,
> dass Dritte unbefugt Kenntnis von den versandten Informationen nehmen.
> Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass
> Ihnen
> diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass wir
> Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen
> anderen
> Kommunikationsweg zu benennen.
> 
> Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
> Betrachten den Acrobat Reader, den Sie hier erhalten können.
> http://www.adobe.de/products/acrobat/readstep2.html
> GF: Benedikt Schackenberg und Christian Peiter
> AG & Sitz: Mainz am RheinHandelsregister: HR-B
> 8608 Umsatzsteuer ID: DE126633578
> 
> 

-- 
--
S&P data GmbH
T 06131 218111
F 06131 218112
E schackenb...@termindoc.de
W www.termindoc.de

Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm

Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
der Schriftform versehen mit zwei Originalunterschriften.

Kommunikation über E-mail
Bei der Kommunikation über E-mail ist nicht in jedem Fall auszuschliessen,
dass Dritte unbefugt Kenntnis von den versandten Informationen nehmen.
Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass Ihnen
diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass wir
Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen anderen
Kommunikationsweg zu benennen.

Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
Betrachten den Acrobat Reader, den Sie hier erhalten können.
http://www.adobe.de/products/acrobat/readstep2.html
GF: Benedikt Schackenberg und Christian Peiter
AG & Sitz: Mainz am RheinHandelsregister: HR-B
8608 Umsatzsteuer ID: DE126633578

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql server is not starting

[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"

http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html


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/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
> .. any idea
> 
> 
> 
> 
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
> 
> 
> 2009/11/11 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 fix this..
> >
> >
> >
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
> > bash-3.00#
> >
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
> > -u root
> > 09 16:14:01 [ERROR] Can't find messagefile
> > '/usr/local/mysql/share/english/errmsg.sys'
> >
> 
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
> > Unknown error 1146
> > 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
> > mysql_upgrade to create it.
> > 09 16:14:01  InnoDB: Started; log sequence number 0 46409
> > 09 16:14:01 [ERROR] Aborting
> >
> > 09 16:14:01  InnoDB: Starting shutdown...
> > 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0
> 46409
> > 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
> > 09 16:14:02 [Note]
> >
> >
> > please help to solve
> >
> 
> --
> --
> S&P data GmbH
> T 06131 218111
> F 06131 218112
> E schackenb...@termindoc.de 
> W www.termindoc.de 
> 
> Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm
> 
> Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
> der Schriftform versehen mit zwei Originalunterschriften.
> 
> Kommunikation über E-mail
> Bei der Kommunikation über E-mail ist nicht in jedem Fall
> auszuschliessen,
> dass Dritte unbefugt Kenntnis von den versandten Informationen nehmen.
> Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass
> Ihnen
> diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass wir
> Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen
> anderen
> Kommunikationsweg zu benennen.
> 
> Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
> Betrachten den Acrobat Reader, den Sie hier erhalten können.
> http://www.adobe.de/products/acrobat/readstep2.html
> GF: Benedikt Schackenberg und Christian Peiter
> AG & Sitz: Mainz am RheinHandelsregister: HR-B
> 8608 Umsatzsteuer ID: DE126633578
> 
> 
> 
> 
> 
> 

-- 
--
S&P data GmbH
T 06131 218111
F 06131 218112
E schackenb...@termindoc.de
W www.termindoc.de

Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm

Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
der Schriftform versehen mit zwei Originalunterschriften.

Kommunikation über E-mail
Bei der Kommunikation über E-mail ist nicht in jedem Fall auszuschliessen,
dass Dritte unbefugt Kenntnis von den versandten Informationen nehmen.
Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass Ihnen
diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass wir
Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen anderen
Kommunikationsweg zu benennen.

Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
Betrachten den Acrobat Reader, den Sie hier erhalten können.
http://www.adobe.de/products/acrobat/readstep2.html
GF: Benedikt Schackenberg und Christian Peiter
AG & Sitz: Mainz am RheinHandelsregister: HR-B
8608 Umsatzsteuer ID: DE126633578

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql server is not starting

[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 amssys   amssys  1024 Apr  1  2009 include
drwx--   3 amssys   amssys  1024 Nov 11 12:28 lib
drwx--   4 amssys   amssys   512 Apr  1  2009 man
drwx--  11 amssys   amssys   512 Nov 11 15:57 mysql-test
drwx--   2 amssys   amssys   512 Apr  1  2009 scripts
drwx--  27 amssys   amssys  1024 Apr  1  2009 share
drwx--   5 amssys   amssys  1024 Apr  1  2009 sql-bench
drwx--   2 amssys   amssys   512 Apr  1  2009 support-files
drwx--   2 amssys   amssys   512 Nov 11 12:28 tools


Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


2009/11/11 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
> >
> >
> 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
> > .. any idea
> >
> >
> >
> >
> > Best Regards
> > Faizal S
> > GSM : 9840118673
> > Blog: http://oradbapro.blogspot.com
> >
> >
> > 2009/11/11 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 fix this..
> > >
> > >
> > >
> >
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
> > > bash-3.00#
> > >
> >
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
> > > -u root
> > > 09 16:14:01 [ERROR] Can't find messagefile
> > > '/usr/local/mysql/share/english/errmsg.sys'
> > >
> >
> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
> > > Unknown error 1146
> > > 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please
> run
> > > mysql_upgrade to create it.
> > > 09 16:14:01  InnoDB: Started; log sequence number 0 46409
> > > 09 16:14:01 [ERROR] Aborting
> > >
> > > 09 16:14:01  InnoDB: Starting shutdown...
> > > 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0
> > 46409
> > > 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
> > > 09 16:14:02 [Note]
> > >
> > >
> > > please help to solve
> > >
> >
> > --
> > --
> > S&P data GmbH
> > T 06131 218111
> > F 06131 218112
> > E schackenb...@termindoc.de 
> > W www.termindoc.de 
> >
> > Unser Impressum finden Sie unter
> http://www.termindoc.de/Impressum.htm
> >
> > Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer
> Wirksamkeit
> > der Schriftform versehen mit zwei Originalunterschriften.
> >
> > Kommunikation über E-mail
> > Bei der Kommunikation über E-mail ist nicht in jedem Fall
> > auszuschliessen,
> > dass Dritte unbefugt Kenntnis von den versandten Informationen
> nehmen.
> > Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass
> > Ihnen
> > diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass
> wir
> > Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen
> > anderen
> > Kommunikationsweg zu benennen.
> >
> > Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
> > Betrachten den Acrobat Reader, den Sie hier erhalten können.
> > http://www.adobe.de/products/acrobat/readstep2.html
> > GF: Benedikt Schackenberg und Christian Peiter
> > AG & Sitz: Mainz am RheinHandelsregister:
> HR-B
> > 8608 Umsatzsteuer ID: DE126633578
> >
> >
>
> --
> --
> S&P data GmbH
> T 06131 218111
> F 06131 218112
> E schackenb...@termindoc.de
> W www.termindoc.de
>
> Unser Impressum finden Sie unter http://www.termindoc.de/Impressum.htm
>
> Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer Wirksamkeit
> der Schriftform versehen mit zwei Originalunterschriften.
>
> Kommunikation über E-mail
> Bei der Kommunikation über E-mail ist nicht in jede

Re: mysql server is not starting

[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 Prajapati <
prajapat...@gmail.com> wrote:

> 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.. 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-sparc-64bit/bin
>> bash-3.00#
>>
>> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
>> -u root
>> 09 16:14:01 [ERROR] Can't find messagefile
>> '/usr/local/mysql/share/english/errmsg.sys'
>>
>> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
>> Unknown error 1146
>> 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please run
>> mysql_upgrade to create it.
>> 09 16:14:01  InnoDB: Started; log sequence number 0 46409
>> 09 16:14:01 [ERROR] Aborting
>>
>> 09 16:14:01  InnoDB: Starting shutdown...
>> 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0 46409
>> 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
>> 09 16:14:02 [Note]
>>
>>
>> please help to solve
>>
>
>

Re: mysql server is not starting

[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 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 amssys   amssys  1024 Apr  1  2009 include
> drwx--   3 amssys   amssys  1024 Nov 11 12:28 lib
> drwx--   4 amssys   amssys   512 Apr  1  2009 man
> drwx--  11 amssys   amssys   512 Nov 11 15:57 mysql-test
> drwx--   2 amssys   amssys   512 Apr  1  2009 scripts
> drwx--  27 amssys   amssys  1024 Apr  1  2009 share
> drwx--   5 amssys   amssys  1024 Apr  1  2009 sql-bench
> drwx--   2 amssys   amssys   512 Apr  1  2009 support-files
> drwx--   2 amssys   amssys   512 Nov 11 12:28 tools
> 
> 
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
> 
> 
> 2009/11/11 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
>>>
>>>
>> 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
>>> .. any idea
>>>
>>>
>>>
>>>
>>> Best Regards
>>> Faizal S
>>> GSM : 9840118673
>>> Blog: http://oradbapro.blogspot.com
>>>
>>>
>>> 2009/11/11 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 fix this..
>>> >
>>> >
>>> >
>>>
>> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin
>>> > bash-3.00#
>>> >
>>>
>> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld
>>> > -u root
>>> > 09 16:14:01 [ERROR] Can't find messagefile
>>> > '/usr/local/mysql/share/english/errmsg.sys'
>>> >
>>>
>> /var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit/bin/mysqld:
>>> > Unknown error 1146
>>> > 09 16:14:01 [ERROR] Can't open the mysql.plugin table. Please
>> run
>>> > mysql_upgrade to create it.
>>> > 09 16:14:01  InnoDB: Started; log sequence number 0 46409
>>> > 09 16:14:01 [ERROR] Aborting
>>> >
>>> > 09 16:14:01  InnoDB: Starting shutdown...
>>> > 09 16:14:02  InnoDB: Shutdown completed; log sequence number 0
>>> 46409
>>> > 09 16:14:02 [Warning] Forcing shutdown of 1 plugins
>>> > 09 16:14:02 [Note]
>>> >
>>> >
>>> > please help to solve
>>> >
>>>
>>> --
>>> --
>>> S&P data GmbH
>>> T 06131 218111
>>> F 06131 218112
>>> E schackenb...@termindoc.de 
>>> W www.termindoc.de 
>>>
>>> Unser Impressum finden Sie unter
>> http://www.termindoc.de/Impressum.htm
>>> Alle Willenserklärungen der S&P data GmbH bedürfen zu ihrer
>> Wirksamkeit
>>> der Schriftform versehen mit zwei Originalunterschriften.
>>>
>>> Kommunikation über E-mail
>>> Bei der Kommunikation über E-mail ist nicht in jedem Fall
>>> auszuschliessen,
>>> dass Dritte unbefugt Kenntnis von den versandten Informationen
>> nehmen.
>>> Soweit Sie per E-mail mit uns Kontakt aufnehmen, nehmen wir an, dass
>>> Ihnen
>>> diese Risiken bekannt und Sie dennoch damit einverstanden sind, dass
>> wir
>>> Ihnen per E-mail antworten. Anderenfalls bitten wir Sie, uns einen
>>> anderen
>>> Kommunikationsweg zu benennen.
>>>
>>> Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum
>>> Betrachten den Acrobat Reader, den Sie hier erhalten können.
>>> http://www.adobe.de/products/acrobat/readstep2.html
>>> GF: Benedikt Schackenberg und Christian Peiter
>>> AG & Sitz: Mainz am RheinHandelsregister:
>> HR-B
>>> 8608 Umsatzsteuer ID: DE126633578
>>>
>>>
>> --
>> --
>> S&P data GmbH
>> T 06131 218111
>> F 06131

Re: Oracle, Sun and MySQL

[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; who else but an
>>> anti-competitive
>>> giant would take a chance on buying Sun now? Story here:
>>> http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272&;
>>> source=features_box1.
>> 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 future development would
>> go and a fear that when the deal goes through Oracle may slowly raise
>> support and training costs to the sort of levels applicable to Oracle
>> database products. These kind of arguments seem impossible to counter
>> for as long as the uncertainty continues and I for one wish they would
>> just resolve the situation either way very quickly because its hurting
>> my business and open source software!
>
> Please remember that there are 3rd parties offering MySQL support already
> now, outside of MySQL AB.
>
> I'm pretty sure that should Oracle raise these prices, 3rd parties will
> take up that part of the market pretty quickly.
>
>
>
> Liz

I am aware of this Liz but corporate customers like to see support coming
from 'source'. There is also a bit of an unknown with 3rd party support
whereas MySQL's own support has a very good reputation and from personal
experience I know it to be second to none.

Regards
John

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Oracle, Sun and MySQL

[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:
http://monty-says.blogspot.com/2009/10/press-release-concerning-oraclesun.html
http://monty-says.blogspot.com/
http://news.cnet.com/8301-13578_3-10379870-38.html

PB
http://www.artfulsoftware.com

-

Martin Gainty wrote:

tendency to work "normal working hours" 7am-7pm PST
which could be a problem for someone in Europe, Asia or even GMT+5 who 
needs an immediate answer and cant wait until 7am PST


i too would like MySQL to stay OpenSource
there is no better a feeling of applying a patch (for your own 
purposes) without having to wait for the corporate leviathans 6 month 
cycle to release a minor patch


what does monty say?
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene 
Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede 
unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. 
Diese Nachricht dient lediglich dem Austausch von Informationen und 
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten 
Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den 
Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le 
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez 
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est 
interdite. Ce message sert à l'information seulement et n'aura pas n'importe 
quel effet légalement obligatoire. Étant donné que les email peuvent facilement 
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité 
pour le contenu fourni.





> Date: Wed, 11 Nov 2009 12:48:28 +
> Subject: Re: Oracle, Sun and MySQL
> From: j...@butterflysystems.co.uk
> To: l...@dijkmat.nl
> CC: john.dais...@butterflysystems.co.uk; 
peter.braw...@earthlink.net; mysql@lists.mysql.com

>
> > 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; who else but an
> >>> anti-competitive
> >>> giant would take a chance on buying Sun now? Story here:
> >>> 
http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272&;

> >>> source=features_box1.
> >> 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 future development 
would

> >> go and a fear that when the deal goes through Oracle may slowly raise
> >> support and training costs to the sort of levels applicable to Oracle
> >> database products. These kind of arguments seem impossible to counter
> >> for as long as the uncertainty continues and I for one wish they 
would
> >> just resolve the situation either way very quickly because its 
hurting

> >> my business and open source software!
> >
> > Please remember that there are 3rd parties offering MySQL support 
already

> > now, outside of MySQL AB.
> >
> > I'm pretty sure that should Oracle raise these prices, 3rd parties 
will

> > take up that part of the market pretty quickly.
> >
> >
> >
> > Liz
>
> I am aware of this Liz but corporate customers like to see support 
coming

> from 'source'. There is also a bit of an unknown with 3rd party support
> whereas MySQL's own support has a very good reputation and from personal
> experience I know it to be second to none.
>
> Regards
> John
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
>


Bing brings you maps, menus, and reviews organized in one place. Try 
it now. 
 





No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.425 / Virus Database: 270.14.60/2496 - Release Date: 11/11/09 07:40:00


  

Re: storage difference in VARCHAR(size)?

[Johan De Meersman]

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-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 10, 2009 at 6:37 PM, Waynn Lue  wrote:
>> Hey all,
>>
>> I was building a table for storing email addresses today and ran into an
>> issue that I couldn't find an answer for using Google. If I declare the
>> column as a VARCHAR (this is an InnoDB table), does it matter what size I
>> declare it as if it's between 1 and 255? I know there's an extra byte of
>> storage once it goes above 255 because of the length, but is there a
>> storage
>> difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
>> functional difference in what gets cut off when I try to store into that
>> table, but is that the only difference?
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: storage difference in VARCHAR(size)?

[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 wrote:

> 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-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 10, 2009 at 6:37 PM, Waynn Lue  wrote:
> >> Hey all,
> >>
> >> I was building a table for storing email addresses today and ran into an
> >> issue that I couldn't find an answer for using Google. If I declare the
> >> column as a VARCHAR (this is an InnoDB table), does it matter what size
> I
> >> declare it as if it's between 1 and 255? I know there's an extra byte of
> >> storage once it goes above 255 because of the length, but is there a
> >> storage
> >> difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
> >> functional difference in what gets cut off when I try to store into that
> >> table, but is that the only difference?
> >
> > With regards,
> >
> > Martijn Tonies
> > Upscene Productions
> > http://www.upscene.com
> >
> > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> > Anywhere, MySQL, InterBase, NexusDB and Firebird!
> >
> > Database questions? Check the forum:
> > http://www.databasedevelopmentforum.com
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=waynn...@gmail.com
>
>

Re: storage difference in VARCHAR(size)?

[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 storing CHAR data that doesn't take up
the full available space (as this is padded with spaces up to the defined
length) and is a storage engine "feature" ;-)

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com



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-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 10, 2009 at 6:37 PM, Waynn Lue  wrote:

Hey all,

I was building a table for storing email addresses today and ran into an
issue that I couldn't find an answer for using Google. If I declare the
column as a VARCHAR (this is an InnoDB table), does it matter what size 
I

declare it as if it's between 1 and 255? I know there's an extra byte of
storage once it goes above 255 because of the length, but is there a
storage
difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
functional difference in what gets cut off when I try to store into that
table, but is that the only difference?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: storage difference in VARCHAR(size)?

[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  wrote:
>
>
>> 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 storing CHAR data that doesn't take up
> the full available space (as this is padded with spaces up to the defined
> length) and is a storage engine "feature" ;-)
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
>> 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-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 10, 2009 at 6:37 PM, Waynn Lue  wrote:
 Hey all,

 I was building a table for storing email addresses today and ran into an
 issue that I couldn't find an answer for using Google. If I declare the
 column as a VARCHAR (this is an InnoDB table), does it matter what size
 I
 declare it as if it's between 1 and 255? I know there's an extra byte of
 storage once it goes above 255 because of the length, but is there a
 storage
 difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
 functional difference in what gets cut off when I try to store into that
 table, but is that the only difference?
>>>
>>> With regards,
>>>
>>> Martijn Tonies
>>> Upscene Productions
>>> http://www.upscene.com
>>>
>>> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
>>> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>>>
>>> Database questions? Check the forum:
>>> http://www.databasedevelopmentforum.com
>>>
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>>>
>>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

query cache extension

[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 cached results) obtain the results from the cache, this
will not happen due to the difference in the query, but since the
select list of the second query is a subset of the select list of the
first query (and the where clause should be identical) we can obtain
the results from the cache.
3. identify the queries with identical select lists but having column
names in different orders and process them as identical queries and
take the advantage of query cache.

Still this is in idea level and I haven't done any coding yet. I just
wanted to try out this as an experiment and check the performance on a
database where the updates are relatively less.

I know that this needs some more memory for the query cache, and need
some additional query parsing.

Since I'm a beginner in this area I would like to know whether this is
doable and any problems that may arise 

Thanks,
Amila

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org