Myisam.php 3.2 KB

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