Myisam.php 3.3 KB

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