Bug 597390

Summary:	F13 mysql compile lacks --with-partition build option
Product:	[Fedora] Fedora	Reporter:	Hawk <penguinx64>
Component:	mysql	Assignee:	Tom Lane <tgl>
Status:	CLOSED ERRATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	high	Docs Contact:
Priority:	low
Version:	13	CC:	hhorak, tgl
Target Milestone:	---
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	mysql-5.1.47-2.fc13	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	598585 (view as bug list)		Environment:
Last Closed:	2010-06-24 16:25:15 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Hawk 2010-05-28 19:50:43 UTC

Description of problem:
The mysql-5.1.46-1.fc13.x86_64 does not have the  --with-partition build option used when installed. Therefore, partitioning is no longer supported.

Version-Release number of selected component (if applicable):
5.1.46-1.fc13.x86_64

How reproducible:
Very, any time you want to make, alter, etc a table that needs partitions

Steps to Reproduce:
1. Create a table that uses partitions. Ex, add  /*!50100 PARTITION BY HASH (user_nbr) PARTITIONS 5 */; in your create table statement
2. try to access tables that use partitioning, the engine type is not understood
3.
  
Actual results:
ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working


Expected results:
SUCCESS

Additional info:
The same version of mysql compiled for the fc12 tree works fine.

Comment 1 Hawk 2010-05-28 19:53:22 UTC

sorry, this would refer to the mysql-server-5.1.46-1.fc13.x86_64 package rather than the plain mysql pacakge I assume.

Comment 2 Tom Lane 2010-05-28 20:43:06 UTC

Hmm.  That was never explicitly selected in our builds, but apparently the configure script silently turns it on if you enable ndbcluster.  Which we stopped doing in F-13 because upstream has discontinued support for ndbcluster as part of the base mysql source distribution.  So the fact that partition was there in F-12 is really an artifact rather than intentional.  How big is the use-case for it?

Comment 3 Hawk 2010-05-28 20:54:53 UTC

if you have large databases, like I do on my servers, partitioning can increase the performance of queries since it is able to break tables into multiple files across the file system and then prune to only do table scans in the files needed.

i can separate my 14+million row DB into files that have 4million rows, queries go from 13 seconds to 2.5 seconds. It is really needed for my server setup, and it is one of the cool new features of mysql 5.1

Comment 4 Tom Lane 2010-06-01 16:55:36 UTC

OK, I'll see about turning it back on.  Has to wait till the pending security releases get out of the testing pipeline, though; I don't want to reset the karma clock on them.

Comment 5 Hawk 2010-06-02 13:30:15 UTC

Thanks for the update. I will wait for some more news

Comment 6 Fedora Update System 2010-06-08 00:42:44 UTC

mysql-5.1.47-2.fc13 has been submitted as an update for Fedora 13.
http://admin.fedoraproject.org/updates/mysql-5.1.47-2.fc13

Comment 7 Fedora Update System 2010-06-08 19:38:32 UTC

mysql-5.1.47-2.fc13 has been pushed to the Fedora 13 testing repository.  If problems still persist, please make note of it in this bug report.
 If you want to test the update, you can install it with 
 su -c 'yum --enablerepo=updates-testing update mysql'.  You can provide feedback for this update here: http://admin.fedoraproject.org/updates/mysql-5.1.47-2.fc13

Comment 8 Fedora Update System 2010-06-24 16:25:10 UTC

mysql-5.1.47-2.fc13 has been pushed to the Fedora 13 stable repository.  If problems still persist, please make note of it in this bug report.