Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
MySQL 5.1 (or even 6.0)
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
scawa
Apprentice
Apprentice


Joined: 11 Feb 2003
Posts: 178
Location: Villa Rica, Georgia

PostPosted: Tue Feb 19, 2008 2:11 am    Post subject: MySQL 5.1 (or even 6.0) Reply with quote

Is anyone working on an ebuild for MySQL 5.1.... Has been out a while and need some features in 5.1

Thanks
_________________
Boredom is a personal Defect
-- Lamar Stephens
Back to top
View user's profile Send private message
drescherjm
Advocate
Advocate


Joined: 05 Jun 2004
Posts: 2778
Location: Pittsburgh, PA, USA

PostPosted: Wed Feb 20, 2008 2:43 pm    Post subject: Reply with quote

See here:

https://bugs.gentoo.org/show_bug.cgi?id=194561
_________________
John

My gentoo overlay
Instructons for overlay
Back to top
View user's profile Send private message
scawa
Apprentice
Apprentice


Joined: 11 Feb 2003
Posts: 178
Location: Villa Rica, Georgia

PostPosted: Thu Feb 21, 2008 9:03 pm    Post subject: Reply with quote

I see this in the bug tracker. But the conversation is rather greek to me. It doesn't tell me if or where it is available.

Stephen McConnell
_________________
Boredom is a personal Defect
-- Lamar Stephens
Back to top
View user's profile Send private message
drescherjm
Advocate
Advocate


Joined: 05 Jun 2004
Posts: 2778
Location: Pittsburgh, PA, USA

PostPosted: Thu Feb 21, 2008 9:06 pm    Post subject: Reply with quote

Ahh, Sorry.

There are a few versions in portage:
http://gentoo-portage.com/dev-db/mysql-community

Although none are the current version 5.1.23.
_________________
John

My gentoo overlay
Instructons for overlay
Back to top
View user's profile Send private message
scawa
Apprentice
Apprentice


Joined: 11 Feb 2003
Posts: 178
Location: Villa Rica, Georgia

PostPosted: Fri Feb 22, 2008 12:16 am    Post subject: Reply with quote

There are hard masked. If I'm not mistaken they are found in the packages.masked file and could be commented out if you wanted to emerge them?

I guess I'll just use Postgress for those functions I need out of 5.1.... and wait till it gets out of being hard masked.

Thanks
_________________
Boredom is a personal Defect
-- Lamar Stephens
Back to top
View user's profile Send private message
jonnevers
Veteran
Veteran


Joined: 02 Jan 2003
Posts: 1594
Location: Gentoo64 land

PostPosted: Fri Feb 22, 2008 1:31 am    Post subject: Reply with quote

scawa wrote:
There are hard masked. If I'm not mistaken they are found in the packages.masked file and could be commented out if you wanted to emerge them?

I guess I'll just use Postgress for those functions I need out of 5.1.... and wait till it gets out of being hard masked.

Thanks

not even, just a quick
Code:
echo "dev-db/mysql-community" >> /etc/portage/package.unmask
echo "dev-db/mysql-community" >> /etc/portage/package.keywords

should get you on your way.

thanks for brining mysql-community to my attention... may I ask what functions you need from 5.1? (trying to learn what new important stuff it contains).
Back to top
View user's profile Send private message
scawa
Apprentice
Apprentice


Joined: 11 Feb 2003
Posts: 178
Location: Villa Rica, Georgia

PostPosted: Fri Feb 22, 2008 1:53 am    Post subject: Reply with quote

One of the features on MySQL5.1 and its Tablespaces is the ability to create a tablespace in a "specific" location. You can specify a folder it will build the associated tables in.

I'm creating a database that will extend over 1.7 TB (multiple hard drives). The ability to break the DB up in to specific tablespaces in specific locations is important.

I'm glad that it will be that easy to install MySQL 5.1. One of the frustrating things about Postgresql and it's JDBC drivers (even their JDBC 3.0) drivers is that they do not support transactions as nicely as MySQL 5.1 does (even though the Postgresql community had ragged and ragged on MySQL about it's lack of trigger, and Stored Procedure and foreign indexes as MySQL was growing into maturity....).

The specific thing that Postgresql JDBC drives down support is the statement.getGeneratedKeys() method... where any autokeys generated in an add or update transaction are returned in a resultset and one can then insert them back into the object to which they are associated. This is important. Then one doesn't have to perform a query to create a key and put it into the object before saving OR do a read of the object just created to get the autogenerated key to put back into the object..... It does much better in keeping your objects in line with the DB and also in commit/rollback processing....

Anyway, there are a bunch of more feature (MySQL 5.1 lets you use Java Stored Procedures -- sort of like Oracle), better triggers..... just to start.

Thanks for your answers....
_________________
Boredom is a personal Defect
-- Lamar Stephens
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum