2

I have a question about my Database Administrators Stack Exchange post: MySQL database innodb tables

  • 3
    What's wrong with it is that the question doesn't have any relevant information for people to actually give an answer – Lamak May 4 '16 at 16:33
  • I already mentioned error whatever I received. that's wht I can provide. what else as per you I should provide? – Yesha May 4 '16 at 16:35
  • 2
    If the error message is all that's needed to give you an answer, then you could search that message on google. Stack Exchange is for specific questions within a scope – Lamak May 4 '16 at 16:36
  • 2
    You've deleted your question but that's not the purpose of downvotes. You've taken the course correcting action of asking on meta how to get your question fixed up, that's good. That's how the site should work. Look at the feedback we're providing. Help us better understand what the problem is, what the constraints we have to work against are. What is the minimal number of steps a person could take to reproduce your error. The database corruption isn't going to fix itself so take a breath and focus on getting your system back up and operational (if it's possible) – billinkc May 4 '16 at 16:44
  • it was by mistake.. I did undelete quickly. – Yesha May 4 '16 at 16:46
  • 1
    This should be your first read. And then you'll probably understand. – Marian May 4 '16 at 17:56
7

The Help Center has excellent resources for how the Stack Exchange model works.

Looking at your question - what do I know?

  • Something is wrong and a table is in a bad state.
  • You cannot repair it as the storage engine doesn't support it
  • You're using innodb

As a non-MySQL person, that question seems bereft of details. What command have you issued? Is the above the exact error message? What happened to get you into this state? etc

"Also how I can optimize mysql database?" That is unanswerable. Optimize for what - read, write, stability, etc? What are your constraints around optimization - do you have a budget? Have you taken a benchmark to establish what your current performance is and do you know what the target should be. Etc, etc etc. Much, much too broad to be answerable and not a good fit for the site.

$.02

  • first of all table is not in a bad state. – Yesha May 4 '16 at 16:36
  • 1
    Again, not a MySQL person, so why would you be running a repair on it? – billinkc May 4 '16 at 16:37
  • 1
    Then why are you trying to repait it? – Lamak May 4 '16 at 16:37
  • I'm getting message at frontend that your database corrupted. try to repair it. – Yesha May 4 '16 at 16:41
  • 2
    Your database is corrupted but that table is not in a bad state? – billinkc May 4 '16 at 16:41
  • As a non-MySQL person how you can comment on question as this is related to mysql and I added tag on question. – Yesha May 4 '16 at 16:42
  • 4
    An automobile mechanic that specializes in Ford is probably has enough general knowledge of automobiles to speculate on what the minimum a mechanic that focuses on Tata Motors vehicles would need to know. So, can I fix what's wrong with your database. No. Can I help you understand what you need to supply if you want someone to help, yes – billinkc May 4 '16 at 16:49
  • 3
    Everyone understands the question, it's just that's a bad question – Lamak May 4 '16 at 16:51
  • 2
    Read the help center on asking questions. For the points listed on the topic ask yourself, does my question meet the criteria? – billinkc May 4 '16 at 16:53
  • 2
    I already said why it's bad, it doesn't fit with the criteria of questions to ask on stack exchange. It literally is "I got this error message on a table, oh, and how can I optimize my database?" – Lamak May 4 '16 at 16:56
  • 2
    I don't know how it doesn't make sense, but if you don't want to listen to the advice posted here then I fail to understand why were you asking in meta in the first place – Lamak May 4 '16 at 17:09
  • 3
    Also covered in the Help Center is that voting is anonymous - you do not know whether jkavalik voted on your question at all, much less whether their vote was positive or negative. You came to meta asking why your question had -3. I have attempted to provide general purpose guidance to help you understand why it might be so. I feel that rather than taking this constructive criticism to heart, you are fighting and borderline insulting those who are trying to help you improve your question and your experience. While you're quibbling w/us over the details, your system remains in a corrupted state – billinkc May 4 '16 at 17:10
  • 4
    @Yesha: So what are you trying to say? Are you implying that all downvotes were by non-MySQL people, who failed to understand your question solely because it was about MySQL and thus not their area of expertise? Downvotes are an indication of what is wrong with the question, not of the fact that "I don't know X and don't like questions about X". Your question is unclear even to a non-MySQL person's eye. You are referring to jkavalik – right, he asked two clarifying questions in a single comment. Wasn't that a confirmation of the fact that your question was lacking details? – Andriy M May 4 '16 at 17:17
  • 4
    @Yesha: But why be offended by downvotes in the first place? They are not a personal attack on you. At the very least, I firmly believe they've been used according to their purpose in your case, even though I myself haven't downvoted (yet). Just try re-reading your question from a perspective of someone completely unacquainted with your situation. That person would know only as much as you have revealed. And apparently that hasn't been enough to answer your question so far, as you can see for yourself. Downvotes are there to motivate you to improve it. – Andriy M May 4 '16 at 17:27
  • 2
    People post here to get solution or help to others.. so whenever I was actively looking answer for whatever detail I have. instead of help user says bad question or irrelevant that's not solution for new members. new members always looking for help how to solve and learn more about this helpful community. I really like your kind answer to improve. thanks andriy! – Yesha May 4 '16 at 17:33
7

I've only just seen the question and my immediate problem with it is that it is asking about two very distinct problems:

  • How to repair a table,

    and

  • How to optimise a database.

The two issues may be related in your mind but they are still very different and should be asked about separately.

The second one, too, is extremely unspecific.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .