598585 – mysql lacks --with-partition build option

RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 598585 - mysql lacks --with-partition build option

Summary: mysql lacks --with-partition build option

Keywords:
Status:	CLOSED CURRENTRELEASE
Alias:	None
Product:	Red Hat Enterprise Linux 6
Classification:	Red Hat
Component:	mysql
Sub Component:
Version:	6.0
Hardware:	All
OS:	Linux
Priority:	low
Severity:	medium
Target Milestone:	rc
Target Release:	---
Assignee:	Tom Lane
QA Contact:	Karel Volný
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2010-06-01 16:46 UTC by Tom Lane
Modified:	2013-07-03 03:29 UTC (History)
CC List:	3 users (show)
Fixed In Version:	mysql-5.1.47-2.el6
Doc Type:	Bug Fix
Doc Text:
Clone Of:	597390
Environment:
Last Closed:	2010-11-10 21:11:31 UTC
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Description Tom Lane 2010-06-01 16:46:50 UTC

+++ This bug was initially created as a clone of Bug #597390 +++

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.

--- Additional comment from penguinx64 on 2010-05-28 15:53:22 EDT ---

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

--- Additional comment from tgl on 2010-05-28 16:43:06 EDT ---

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?

--- Additional comment from penguinx64 on 2010-05-28 16:54:53 EDT ---

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 2 Karel Volný 2010-08-19 10:30:52 UTC

the option "--with-plugin-partition" is passed to %configure

trying to use partitions seems to work:

mysql> use test
Database changed
mysql> create  table tm8 (s1 int) partition by hash (s1) as select 1;
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> drop table tm8;
Query OK, 0 rows affected (0.00 sec)

(I took the create statement example from http://bugs.mysql.com/bug.php?id=15336 , testing that bug as a sideeffect)

(tested on mysql-server-5.1.47-4.el6.ppc64)

Comment 3 releng-rhel@redhat.com 2010-11-10 21:11:31 UTC

Red Hat Enterprise Linux 6.0 is now available and should resolve
the problem described in this bug report. This report is therefore being closed
with a resolution of CURRENTRELEASE. You may reopen this bug report if the
solution does not work for you.

Note You need to log in before you can comment on or make changes to this bug.