Score:0

What does fragmented table mean in MySQL?

in flag

I have a MariaDB database with an InnoDB engine and querying data take a lot of time so I search and found that it is maybe related to the tables being fragmented but I cannot understand what it means and what I have to do about it.

cn flag
And you ask here because on dba.stackexchange.com you would find real specialists for databases?
ua flag
Not likely to be a fragmentation issue. Show up the query, `SHOW CREATE TABLE`, and how big the table is.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.