tailieunhanh - MySQL Enterprise Solutions phần 10

sử dụng yêu cầu bồi thường gấp mười lần tăng trong thực hiện sau khi chuyển đổi các ứng dụng ASP của họ để PHP. Đó là chi phí-hiệu quả với quy mô hiệu suất Web bằng cách tạo ra một trang trại máy chủ Web của các hệ thống uniprocessor hoặc bộ xử lý kép hơn để mua các máy chủ quad. Việc thiếu lệ phí giấy phép trở thành một yếu tố chi phí quan trọng khi | 358 Exploring MySQL Server Internals optimize Called during processing of OPTIMIZE TABLE to defragment and otherwise improve the table. By default it returns HA_ADMIN_NOT_IMPLEMENTED. analyze Called during processing of ANALYZE TABLE to update key distribution statistics. By default it returns HA_ADMIN_NOT_ IMPLEMENTED. backup Backs up table files to a directory. It is implemented only for MyISAM tables and used in handling the BACKUP TABLE command. restore Restores the table backed up with the BACKUP TABLE command. It is used in processing the RESTORE TABLE command. dump Dumps the table in binary format across the network. It is used by the master to send a copy of the table to the slave. It is currently implemented only for MyISAM tables. deactivate_non_unique_index Temporarily disables non-unique index updates to speed up data import. It is used in handling ALTER TABLE . DISABLE_KEYS and to speed up LOAD DATA INFILE and multirow inserts. The index is reenabled and updated with a call to activate_all_index . activate_all_index Re-enables all keys and updates them based on the inserted data. It will be called to finalize a multirow insert and LOAD DATA INFILE with disabled keys or through the invocation of ALTER TABLE . ENABLE KEYS. net_read_dump Reads the binary table dump sent by dump and recreates the table on the slave. It is currently implemented only for the MyISAM handler. update_table_comment Updates the comment field on the table with its stored definition. It is used in ALTER TABLE. append_create_info Appends extra information that cannot normally be deduced from the regular table structures and that is available only to the handlers via the output of SHOW CREATE TABLE command. get_foreign_key_create_info Obtains the string used for creating the foreign keys from the handler if the handler supports them. Currently InnoDB is the only handler that supports foreign keys. init_table_handler_for_HANDLER Initializes the table to prepare it for the use of the .