RE: upgrade from version 5.0.45

[Parikh, Dilip Kumar]

Hey if you are using any archive engines in your existing database then
please use (5.0.8x) if not then u can upgrade to 5.1.45 (stable).

Thanks,
Dilipkumar

-Original Message-
From: ing.baigu...@gmail.com [mailto:ing.baigu...@gmail.com] On Behalf
Of Marco Baiguera
Sent: Tuesday, March 30, 2010 7:07 PM
To: mysql@lists.mysql.com
Subject: upgrade from version 5.0.45

Hello everyone,
i am quite new to mysql and i recently begin to work with a company
who is using mysql 5.0.45 in production.
i think this version is too old and would like to upgrade to the most
recent 5.0.xx

my os is CentOS release 5.3.

is it safe to simply use "yum upgrade mysql" ?

are there any important differences i should be aware of between
5.0.45 and 5.0.77 ?
any diffferences in password encoding etc. ?

the db is properly backed up and replicated on two 5.0.77 slaves.

thank you
Marco

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=dilipkumar.par...@eds.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: MySQLTuner

[Raj Shekhar]

In infinite wisdom sangprabv  wrote:

> My physical RAM is only 16Gb. I am afraid it will freezed the server
> if I set key_buffer_size (> 23.2G). Any suggestion to optimize it?
> Thanks for any response.
> 

IIRC, on Linux, Mysql will scale back the settings it sees that you are
trying to allocate more memory to mysql than what is actually present in
the box.  

- Check if you have any duplicate indexes
  ( or
  mk-duplicate-key-checker from maatkit toolkit)

- if you have indexes of varchars, check if you are using column
  prefixes for indexes, and if not,  try using that (i.e. have a index
  on name(10), instead if name)

- Analyze your SELECT queries to see which tables are used most often and
  increase the key buffer size to hold at least the indexes from those
  table in the memory. (the 80/20 rule might be applicable here)

- If you have been doing lots of deletes, you should get some benefit
  from optimize table or by doing "myisamchk -f" (in other words,
  rebuilding your index)

-- 
Raj Shekhar
-
If there's anything more important than my ego around, I want it
caught and shot now.
- 
Read the latest at my blog: "casio's g-shock watch" 




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

Re: MySQLTuner

[Johan De Meersman]

>
> - Analyze your SELECT queries to see which tables are used most often and
>  increase the key buffer size to hold at least the indexes from those
>  table in the memory. (the 80/20 rule might be applicable here)
>

Additionally, have a look around the documentation for named key buffer
pools, and allocate the most-used indices to a separate pool so they're
always in-memory, even when the default pool is filling up.

Keep in mind, indices will still be faster than a full tablescan, even if
they're read from disk; so it's no disaster to leave some of the lesser-used
ones out of memory.



-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

ANN: Database Workbench 3.4.4 released

[Martijn Tonies]

ANN: Database Workbench 3.4.4 released!

Ladies, gentlemen,

Upscene Productions is proud to announce the next
version of the popular database development tools:

" Database Workbench 3.4.4 "

This release includes the Pro and Lite Editions.


Order now and get a 25% discount AND version 4.0
for free, available later this month. Use coupon
code " DBW3X " when ordering.



Version 3.4.4 mostly includes bugfixes in addition to the
new features in previous versions.

Changes Highlights in 3.4 and previous versions
---
- NexusDB v3 support
- Many diagramming improvements
- Better Stored Routine Debugger
- Ability to cancel import/export processes
- Monitoring GUI for Firebird 2.1
- Ability to cancel running queries in NexusDB, SQL Anywhere and Firebird 
2.1

- Stored Routine debugger for SQL Anywhere
- Many new features, enhancements and bug fixes...
... and much more ...

Download a trial at: http://www.upscene.com/go/?go=download

Full list of features and fixes:
http://www.upscene.com/go/?go=tracker&v=3.4.4&id=1
http://www.upscene.com/go/?go=tracker&v=3.4.3&id=1
http://www.upscene.com/go/?go=tracker&v=3.4.2&id=1
http://www.upscene.com/go/?go=tracker&v=3.4.1&id=1
http://www.upscene.com/go/?go=tracker&v=3.4.0&id=1


Database Workbench supports:
- Borland InterBase ( 4.x - 8.x )
- Firebird ( 1.x, 2.x )
- MS SQL Server/MSDE ( v6.5, 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
- MySQL 4.x, 5.x
- Oracle Database ( 8i, 9i, 10g, 11g )
- Sybase SQL Anywhere ( 9, 10 and 11 )
- NexusDB ( 2.08.x, 3.0.x )


Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com


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

Tokutek Acquires Oracle

[Krishna Chandra Prajapati]

Hi guys,

Is the information is true.

http://planet.mysql.com/

http://tokutek.com/2010/04/tokutek-acquires-oracle/

Regards,
Krishna

Re: Tokutek Acquires Oracle

[Johan De Meersman]

April's fools not a tradition where you are ? :-)


On Thu, Apr 1, 2010 at 4:39 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:

> Hi guys,
>
> Is the information is true.
>
> http://planet.mysql.com/
>
> http://tokutek.com/2010/04/tokutek-acquires-oracle/
>
> Regards,
> Krishna
>



-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Re: Tokutek Acquires Oracle

[Gary Smith]

Krishna Chandra Prajapati wrote:

Hi guys,

Is the information is true.

http://planet.mysql.com/

http://tokutek.com/2010/04/tokutek-acquires-oracle/
  

Might want to check the date.

Gary

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

RE: Tokutek Acquires Oracle

[Jerry Schwartz]

Happy April Fool's Day.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com

>-Original Message-
>From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
>Sent: Thursday, April 01, 2010 10:39 AM
>To: MySQL
>Subject: Tokutek Acquires Oracle
>
>Hi guys,
>
>Is the information is true.
>
>http://planet.mysql.com/
>
>http://tokutek.com/2010/04/tokutek-acquires-oracle/
>
>Regards,
>Krishna




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

RE: Tokutek Acquires Oracle

[Martin Gainty]

short of exxon there is no other entity that comes close to acquiring Oracle


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.



 

> From: jschwa...@the-infoshop.com
> To: prajapat...@gmail.com; mysql@lists.mysql.com
> Subject: RE: Tokutek Acquires Oracle
> Date: Thu, 1 Apr 2010 14:28:31 -0400
> 
> Happy April Fool's Day.
> 
> Regards,
> 
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
> 
> 860.674.8796 / FAX: 860.674.8341
> 
> www.the-infoshop.com
> 
> >-Original Message-
> >From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
> >Sent: Thursday, April 01, 2010 10:39 AM
> >To: MySQL
> >Subject: Tokutek Acquires Oracle
> >
> >Hi guys,
> >
> >Is the information is true.
> >
> >http://planet.mysql.com/
> >
> >http://tokutek.com/2010/04/tokutek-acquires-oracle/
> >
> >Regards,
> >Krishna
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
> 
  
_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_1