[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Finding out if a table is partitioned in mysql

Posted on 2011-05-10
3
Medium Priority
?
361 Views
Last Modified: 2012-05-11
Googling about it and searching EE didn't give me immediate answers, so I post the question - how do you know from within mysql prompt only if a MySQL table uses partitioning?  "desc table_name" doesn't give any more than the basic info.  Thanks.  The reason why via mysql prompt only is the database is on Amazon RDS so I don't have access to the filesystem and I don't want to have to install tools such as phpmyadmin on my ec2 instance just to that.  Thanks.
0
Comment
Question by:johanntagle
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 2000 total points
ID: 35735024
EXPLAIN PARTITIONS SELECT * FROM tbl


Also use the data dictionary for details on the partition

http://dev.mysql.com/doc/refman/5.1/en/partitioning-info.html
0
 
LVL 24

Author Closing Comment

by:johanntagle
ID: 35735143
Thanks again mrjoltcola!

Funny how i missed that part of the documentation. I guess coffee is failing me - maybe I need.... Jolt Cola... LOL
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 35735218
:)
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month17 days, 14 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question