Tag Info

New answers tagged

1

Well, there's bad news, good news with a catch, and some really good news. The bad news T-SQL objects execute in the database where they reside. There are two (not very useful) exceptions: stored procedures with names prefixed with sp_ and that exist in the [master] database (not a great option: one DB at a time, adding something to [master], possibly ...


2

Index fragmentation is much overrated. Do not worry about it. Two adjacent, somewhat-empty, blocks are merged together by InnoDB as the natural processing. Random actions on a BTree cause it to naturally gravitate toward an average of 69% full. Sure, this is not 100%, but the overhead of "fixing" it is not worth it. SHOW TABLE STATUS gives you some ...


1

How do I check fragmentation of a particular index in MySQL, not the table as a whole Pass. Does OPTIMIZE TABLE actually fix the internal / external fragmentation of an index as in SQL Server? It completely rebuilds the table and its indexes. When I optimize a table in MySQL, does it actually rebuilds all the indexes on the table? That's the ...



Top 50 recent answers are included