API tools faq
paste
Guest User

Untitled

a guest
Jun 20th, 2018
197
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.54 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW TABLE STATUS FROM `fil_stuff`;
  2. +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------------------------------+---------+
  3. | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
  4. +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------------------------------+---------+
  5. | archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  6. | category | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 6479151104 | 1 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  7. | categorylinks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  8. | externallinks | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 49152 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  9. | filearchive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 6479151104 | 1 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  10. | hitcounter | MEMORY | 10 | Fixed | 0 | 5 | 0 | 125000 | 0 | 0 | NULL | NULL | NULL | NULL | latin1_swedish_ci | NULL | max_rows=25000 | |
  11. | image | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  12. | imagelinks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  13. | interwiki | InnoDB | 10 | Compact | 93 | 176 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  14. | ipblocks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 81920 | 6479151104 | 1 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  15. | job | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | 1 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  16. | langlinks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  17. | logging | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 65536 | 6479151104 | 2 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  18. | math | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  19. | objectcache | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  20. | oldimage | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  21. | page | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 49152 | 6479151104 | 2 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  22. | page_props | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  23. | page_restrictions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 6479151104 | 1 | 2012-02-08 23:07:02 | NULL | NULL | utf8_general_ci | NULL | | |
  24. | pagelinks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  25. | protected_titles | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  26. | querycache | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  27. | querycache_info | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  28. | querycachetwo | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  29. | recentchanges | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 114688 | 6479151104 | 3 | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  30. | redirect | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  31. | revision | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 81920 | 6479151104 | 4 | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | max_rows=10000000 avg_row_length=1024 | |
  32. | searchindex | MyISAM | 10 | Dynamic | 1 | 392 | 392 | 281474976710655 | 4096 | 0 | NULL | 2012-02-08 23:07:03 | 2012-02-08 23:07:03 | 2012-02-08 23:07:03 | latin1_swedish_ci | NULL | | |
  33. | site_stats | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  34. | templatelinks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  35. | text | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 6479151104 | 4 | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | max_rows=10000000 avg_row_length=10240 | |
  36. | trackbacks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 6479151104 | 1 | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  37. | transcache | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  38. | updatelog | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  39. | user | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 6479151104 | 2 | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  40. | user_groups | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  41. | user_newtalk | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 6479151104 | NULL | 2012-02-08 23:07:03 | NULL | NULL | utf8_general_ci | NULL | | |
  42. | watchlist | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 6479151104 | NULL | 2012-02-08 23:07:04 | NULL | NULL | utf8_general_ci | NULL | | |
  43. +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------------------------------+---------+
  44. 38 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!