MYSQL 数据库遇到的瓶颈（数据表被破坏）

   --在我们一个客户反应的情况中，一个很奇怪的现象前台操作的数据不显示，后台数据库中都有数据，很郁闷。把客户的环境移到本地，数据操作都是成功的显示，百思不解。

   今天中午终于查到SQL语句中显示The table is full，显示数据表已满。以下是找到的解决方法，备案作查。

检查表是否被破坏了。然后修复表OK

optimize table weight_form;
optimize table users_role;
optimize table users_perms;
optimize table users_permission;
optimize table users;
optimize table user_info;
optimize table tmpemployeedmt;
optimize table tmp_wewl;
optimize table tmp_title;
optimize table tmp_source_080225;
optimize table tmp_salary_source_080225;
optimize table tmp_salary_source_080128;
optimize table tmp_salary_source_071010;
optimize table tmp_salary_other_dmt;
optimize table tmp_salary_m;
optimize table tmp_salary_idl_dmt;
optimize table tmp_salary_dl_dmt;
optimize table tmp_salary_dl;
optimize table tmp_salary_200706;
optimize table tmp_position;
optimize table tmp_no;
optimize table tmp_infoext;
optimize table tmp_import;
optimize table tmp_float;
optimize table tmp_employee_0810;
optimize table tmp_employee_070828;
optimize table tmp_employee;
optimize table tmp_dmt_source_dl;
optimize table tmp_dmt_source;
optimize table tmp_dmt_salary;
optimize table tmp_dmt_float;
optimize table tmp_dmt_bankaccount;
optimize table tmp_department080123;
optimize table tmp_department;
optimize table tmp_depart_map;
optimize table tmp_depart;
optimize table tmp_contract1;
optimize table tmp_contract;
optimize table tmp_bankaccount;
optimize table tmp_attendance_manual_record_071010;
optimize table tmp_att_sum06;
optimize table tmp_att_dmt_sum06;
optimize table tmp_0021;
optimize table title;
optimize table temp_user_operate_calculate_salary;
optimize table temp_salary_float;
optimize table temp_month_shift_0;
optimize table temp_attendance_to_salary;
optimize table temp_attendance_summary;
optimize table temp_attendance_plan_infact;
optimize table temp_analysis_4;
optimize table temp_analysis_1;
optimize table tax_plan_rank;
optimize table tax_plan;
optimize table system_customize_field;
optimize table sysatt_type;
optimize table sql_log;
optimize table shift_time;
optimize table shift_month;
optimize table shift_day_overtime;
optimize table shift_day;
optimize table setoption;
optimize table session;
optimize table seq_weight_form_form_id;
optimize table seq_users_user_id;
optimize table seq_title_title_id;
optimize table seq_tax_plan_tax_plan_id;
optimize table seq_tax_plan_rank_tax_plan_rank_id;
optimize table seq_shift_time_shift_time_id;
optimize table seq_shift_month_shift_month_id;
optimize table seq_shift_day_shift_day_id;
optimize table seq_salary_plan_plan_id;
optimize table seq_salary_addition_addition_id;
optimize table seq_roles_self_role_id;
optimize table seq_roles_role_id;
optimize table seq_reward_punishment_rp_id;
optimize table seq_report_template_id;
optimize table seq_recruitment_recruitment_id;
optimize table seq_preference_pref_id;
optimize table seq_position_position_id;
optimize table seq_learning_center_lc_id;
optimize table seq_kpi_kpi_id;
optimize table seq_kpi_flow_kpi_flow_id;
optimize table seq_employee_transfer_transfer_id;
optimize table seq_employee_sr_sr_id;
optimize table seq_employee_salary_descendant_history_history_id;
optimize table seq_employee_reward_punishment_erp_id;
optimize table seq_employee_history_history_id;
optimize table seq_employee_employee_id;
optimize table seq_employee_education_education_id;
optimize table seq_employee_contract_contract_id;
optimize table seq_employee_contract_attachment_attachment_id;
optimize table seq_download_history_history_id;
optimize table seq_department_department_id;
optimize table seq_demission_survey_item_demission_survey_item_id;
optimize table seq_demission_survey_demission_survey_id;
optimize table seq_demission_demission_id;
optimize table seq_course_type;
optimize table seq_course_setting;
optimize table seq_course_record;
optimize table seq_course_class;
optimize table seq_course_attendance;
optimize table seq_course;
optimize table seq_category_category_id;
optimize table seq_candidate_interview_interview_id;
optimize table seq_candidate_flow_candidate_flow_id;
optimize table seq_candidate_candidate_id;
optimize table seq_bulletin_bulletin_id;
optimize table seq_bank_id;
optimize table seq_attendance_rule_attendance_rule_id;
optimize table seq_attendance_manual_record_manual_record_id;
optimize table seq_attendance_manual_record_flow_amrf_id;
optimize table seq_attendance_machine_format_machine_format_id;
optimize table self_service_session;
optimize table self_roles;
optimize table self_permission;
optimize table self_module_perm4role;
optimize table self_module;
optimize table self_memo;
optimize table self_mail;
optimize table salary_track;
optimize table salary_system_field;
optimize table salary_status;
optimize table salary_source;
optimize table salary_plan;
optimize table salary_import_data;
optimize table salary_field_200707;
optimize table salary_field_200706;
optimize table salary_field_200705;
optimize table salary_field;
optimize table salary_detail;
optimize table salary_addition_detail;
optimize table salary_addition;
optimize table salary_200812;
optimize table salary_200811;
optimize table salary_200810;
optimize table salary_200809;
optimize table salary_200808;
optimize table salary_200807;
optimize table salary_200806;
optimize table salary_200805;
optimize table salary_200804;
optimize table salary_200803;
optimize table salary_200802;
optimize table salary_200801;
optimize table salary_200712;
optimize table salary_200711;
optimize table salary_200710;
optimize table salary_200709;
optimize table salary_200708;
optimize table salary_200706;
optimize table salary_200705;
optimize table roles;
optimize table reward_punishment;
optimize table reportsys;
optimize table reportpms;
optimize table reportdptlist;
optimize table reportcondition;
optimize table report_type;
optimize table report_template;
optimize table report_label;
optimize table recruitment;
optimize table recorrectpos;
optimize table preference;
optimize table position;
optimize table pbcatvld;
optimize table pbcattbl;
optimize table pbcatfmt;
optimize table pbcatedt;
optimize table pbcatcol;
optimize table module_perm4role;
optimize table module;
optimize table learning_center;
optimize table kpi_flow;
optimize table kpi;
optimize table flow_type;
optimize table flow_run_prcs;
optimize table flow_run_feedback;
optimize table flow_run_data;
optimize table flow_run;
optimize table flow_process;
optimize table flow_form_type;
optimize table employee_transfer;
optimize table employee_sr;
optimize table employee_shift_month;
optimize table employee_salary_descendant_history;
optimize table employee_role;
optimize table employee_reward_punishment;
optimize table employee_history;
optimize table employee_education;
optimize table employee_customize;
optimize table employee_contract_attachment;
optimize table employee_contract;
optimize table employee_attendance_card;
optimize table employee;
optimize table ehrlog;
optimize table download_history;
optimize table dmt_wewl;
optimize table department_bak_0913;
optimize table department;
optimize table demission_type;
optimize table demission_survey_item;
optimize table demission_survey;
optimize table demission;
optimize table course_type;
optimize table course_setting_type;
optimize table course_setting;
optimize table course_record;
optimize table course_class;
optimize table course_attendance;
optimize table course;
optimize table category;
optimize table candidate_interview;
optimize table candidate_flow;
optimize table candidate_customize;
optimize table candidate;
optimize table bulletin_embracer;
optimize table bulletin;
optimize table bankfield;
optimize table bank;
optimize table attendance_system_field;
optimize table attendance_summary_200812;
optimize table attendance_summary_200811;
optimize table attendance_summary_200810;
optimize table attendance_summary_200809;
optimize table attendance_summary_200808;
optimize table attendance_summary_200807;
optimize table attendance_summary_200806;
optimize table attendance_summary_200805;
optimize table attendance_summary_200804;
optimize table attendance_summary_200803;
optimize table attendance_summary_200802;
optimize table attendance_summary_200801;
optimize table attendance_summary_200712;
optimize table attendance_summary_200711;
optimize table attendance_summary_200710;
optimize table attendance_summary_200709;
optimize table attendance_summary_200708;
optimize table attendance_summary_200707;
optimize table attendance_summary_200706;
optimize table attendance_summary_200705;
optimize table attendance_summary_200702;
optimize table attendance_summary_200701;
optimize table attendance_status;
optimize table attendance_salary_field;
optimize table attendance_rule;
optimize table attendance_manual_record_flow;
optimize table attendance_manual_record;
optimize table attendance_machine_result_200912;
optimize table attendance_machine_result_200911;
optimize table attendance_machine_result_200910;
optimize table attendance_machine_result_200909;
optimize table attendance_machine_result_200908;
optimize table attendance_machine_result_200907;
optimize table attendance_machine_result_200906;
optimize table attendance_machine_result_200905;
optimize table attendance_machine_result_200904;
optimize table attendance_machine_result_200903;
optimize table attendance_machine_result_200902;
optimize table attendance_machine_result_200901;
optimize table attendance_machine_result_200812;
optimize table attendance_machine_result_200811;
optimize table attendance_machine_result_200810;
optimize table attendance_machine_result_200809;
optimize table attendance_machine_result_200808;
optimize table attendance_machine_result_200807;
optimize table attendance_machine_result_200806;
optimize table attendance_machine_result_200805;
optimize table attendance_machine_result_200804;
optimize table attendance_machine_result_200803;
optimize table attendance_machine_result_200802;
optimize table attendance_machine_result_200801;
optimize table attendance_machine_result_200712;
optimize table attendance_machine_result_200711;
optimize table attendance_machine_result_200710;
optimize table attendance_machine_result_200709;
optimize table attendance_machine_result_200708;
optimize table attendance_machine_result_200707;
optimize table attendance_machine_result_200706;
optimize table attendance_machine_result_200705;
optimize table attendance_machine_result_200704;
optimize table attendance_machine_result_200703;
optimize table attendance_machine_result_200702;
optimize table attendance_machine_result_200701;
optimize table attendance_machine_raw_data;
optimize table attendance_machine_format;
optimize table attendance_machine_data_log;
optimize table attendance_machine_data_2;
optimize table attendance_machine_data;
optimize table attendance_logical;
optimize table attendance_log;
optimize table attendance_employee_month_day_time_shift_200912;
optimize table attendance_employee_month_day_time_shift_200911;
optimize table attendance_employee_month_day_time_shift_200910;
optimize table attendance_employee_month_day_time_shift_200909;
optimize table attendance_employee_month_day_time_shift_200908;
optimize table attendance_employee_month_day_time_shift_200907;
optimize table attendance_employee_month_day_time_shift_200906;
optimize table attendance_employee_month_day_time_shift_200905;
optimize table attendance_employee_month_day_time_shift_200904;
optimize table attendance_employee_month_day_time_shift_200903;
optimize table attendance_employee_month_day_time_shift_200902;
optimize table attendance_employee_month_day_time_shift_200901;
optimize table attendance_employee_month_day_time_shift_200812;
optimize table attendance_employee_month_day_time_shift_200811;
optimize table attendance_employee_month_day_time_shift_200810;
optimize table attendance_employee_month_day_time_shift_200809;
optimize table attendance_employee_month_day_time_shift_200808;
optimize table attendance_employee_month_day_time_shift_200807;
optimize table attendance_employee_month_day_time_shift_200806;
optimize table attendance_employee_month_day_time_shift_200805;
optimize table attendance_employee_month_day_time_shift_200804;
optimize table attendance_employee_month_day_time_shift_200803;
optimize table attendance_employee_month_day_time_shift_200802;
optimize table attendance_employee_month_day_time_shift_200801;
optimize table attendance_employee_month_day_time_shift_200712;
optimize table attendance_employee_month_day_time_shift_200711;
optimize table attendance_employee_month_day_time_shift_200710;
optimize table attendance_employee_month_day_time_shift_200709;
optimize table attendance_employee_month_day_time_shift_200708;
optimize table attendance_employee_month_day_time_shift_200707;
optimize table attendance_employee_month_day_time_shift_200706;
optimize table attendance_employee_month_day_time_shift_200705;
optimize table attendance_employee_month_day_time_shift_200704;
optimize table attendance_employee_month_day_time_shift_200703;
optimize table attendance_employee_month_day_time_shift_200702;
optimize table attendance_employee_month_day_time_shift_200701;
optimize table attendance_detail_log_200812;
optimize table attendance_detail_log_200811;
optimize table attendance_detail_log_200810;
optimize table attendance_detail_log_200809;
optimize table attendance_detail_log_200808;
optimize table attendance_detail_log_200807;
optimize table attendance_detail_log_200806;
optimize table attendance_detail_log_200805;
optimize table attendance_detail_log_200804;
optimize table attendance_detail_log_200803;
optimize table attendance_detail_log_200802;
optimize table attendance_detail_log_200801;
optimize table attendance_detail_log_200712;
optimize table attendance_detail_log_200711;
optimize table attendance_detail_log_200710;
optimize table attendance_detail_log_200709;
optimize table attendance_detail_log_200708;
optimize table attendance_detail_log_200707;
optimize table attendance_detail_log_200706;
optimize table attendance_detail_log_200705;
optimize table attendance_detail_log_200702;
optimize table attendance_detail_log_200701;
optimize table attend_daily_log;
optimize table attend_daily_data;
optimize table approval_position_flow;
optimize table approval_flow;
optimize table approval_employee_flow;

check table attendance_employee_month_day_time_shift_200901;