Myisam.php 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4. * The MyISAM storage engine
  5. *
  6. * @package PhpMyAdmin-Engines
  7. */
  8. declare(strict_types=1);
  9. namespace PhpMyAdmin\Engines;
  10. use PhpMyAdmin\StorageEngine;
  11. /**
  12. * The MyISAM storage engine
  13. *
  14. * @package PhpMyAdmin-Engines
  15. */
  16. class Myisam extends StorageEngine
  17. {
  18. /**
  19. * Returns array with variable names dedicated to MyISAM storage engine
  20. *
  21. * @return array variable names
  22. */
  23. public function getVariables()
  24. {
  25. return [
  26. 'myisam_data_pointer_size' => [
  27. 'title' => __('Data pointer size'),
  28. 'desc' => __(
  29. 'The default pointer size in bytes, to be used by CREATE TABLE '
  30. . 'for MyISAM tables when no MAX_ROWS option is specified.'
  31. ),
  32. 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
  33. ],
  34. 'myisam_recover_options' => [
  35. 'title' => __('Automatic recovery mode'),
  36. 'desc' => __(
  37. 'The mode for automatic recovery of crashed MyISAM tables, as '
  38. . 'set via the --myisam-recover server startup option.'
  39. ),
  40. ],
  41. 'myisam_max_sort_file_size' => [
  42. 'title' => __('Maximum size for temporary sort files'),
  43. 'desc' => __(
  44. 'The maximum size of the temporary file MySQL is allowed to use '
  45. . 'while re-creating a MyISAM index (during REPAIR TABLE, ALTER '
  46. . 'TABLE, or LOAD DATA INFILE).'
  47. ),
  48. 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
  49. ],
  50. 'myisam_max_extra_sort_file_size' => [
  51. 'title' => __('Maximum size for temporary files on index creation'),
  52. 'desc' => __(
  53. 'If the temporary file used for fast MyISAM index creation '
  54. . 'would be larger than using the key cache by the amount '
  55. . 'specified here, prefer the key cache method.'
  56. ),
  57. 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
  58. ],
  59. 'myisam_repair_threads' => [
  60. 'title' => __('Repair threads'),
  61. 'desc' => __(
  62. 'If this value is greater than 1, MyISAM table indexes are '
  63. . 'created in parallel (each index in its own thread) during '
  64. . 'the repair by sorting process.'
  65. ),
  66. 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
  67. ],
  68. 'myisam_sort_buffer_size' => [
  69. 'title' => __('Sort buffer size'),
  70. 'desc' => __(
  71. 'The buffer that is allocated when sorting MyISAM indexes '
  72. . 'during a REPAIR TABLE or when creating indexes with CREATE '
  73. . 'INDEX or ALTER TABLE.'
  74. ),
  75. 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
  76. ],
  77. 'myisam_stats_method' => [],
  78. 'delay_key_write' => [],
  79. 'bulk_insert_buffer_size' => [
  80. 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
  81. ],
  82. 'skip_external_locking' => [],
  83. ];
  84. }
  85. }