StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11357174
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-07-06T06:46:13.657
FavoriteCount
0
LastActivityDate
2016-10-08T13:42:39.767
LastEditDate
2016-10-08T13:42:39.767
LastEditorUserId
1505860
OwnerUserId
1505860
ParentId
5420029
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I am author of openark kit -- so I'm biased. Today, there is also <a href="http://www.percona.com/doc/percona-toolkit/2.1/pt-online-schema-change.html" rel="nofollow">pt-online-schema-change</a> from Percona Toolkit. It resembles the openark kit tool more than the facebook tool: it uses synchronous updates onto the "ghost" table being built, rather than asynchronous (as in the facebook tool). The Percona tool improves on the openark tool in at least two ways I'm aware of: 1. It can handle tables with foreign keys -- to some extent 2. It can take into account the status of replicating slaves, slowing down the process as needed for the slaves to be able to keep up. I do not know how many installations oak-online-alter-table has. I'm being approached now and then by users of this tool, but have no comparison to make on the numbers. The tool has been around for more than 3 years now on production. Edit 2016: It's been a long while since last worked on <code>openark-kit</code> and the <code>oak-online-alter-table</code> too is stale. Edit 2016: We've recently released <a href="https://github.com/github/gh-ost" rel="nofollow">gh-ost</a>, GitHub's online schema migration tool, a modern solution that is triggerless, auditable, controllable, suspendible... <code>gh-ost</code> is released to the open source with GitHub's ongoing support. It is well <a href="https://github.com/github/gh-ost/tree/master/doc" rel="nofollow">documented</a>. See also the <a href="http://githubengineering.com/gh-ost-github-s-online-migration-tool-for-mysql/" rel="nofollow">announcement</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POonline schema modification
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USShlomi Noach
UserOwnerUserId
1. USShlomi Noach
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.