Kiểm tra xem bảng nào không có auto_increment, nếu có kết quả thì nghĩa là các bảng đó không có auto_increment SELECT table_name FROM information_schema.tables WHERE table_schema = ‘vnsport_doelf’ AND table_type = ‘BASE TABLE’ AND table_name LIKE ‘sahdTR_%’ AND table_name NOT IN ( SELECT DISTINCT table_name FROM information_schema.key_column_usage WHERE table_schema = ‘vnsport_doelf’ AND constraint_name =
Nội dung này được bảo mật. Hãy nhập mật khẩu để xem tiếp: Mật khẩu:
/etc/my.cnf hoặc /var/log/syslog /etc/my.cnf.d/ step1: Go to this file (/etc/mysql/conf.d/mysqld_safe_syslog.cnf) and remove or comment those line. step2: Go to mysql conf file (/etc/mysql/my.cnf) and add following lines To enable error log add following [mysqld_safe] log_error=/var/log/mysql/mysql_error.log [mysqld] log_error=/var/log/mysql/mysql_error.log To enable general query log add following general_log_file = /var/log/mysql/mysql.log general_log = 1 To enable Slow Query Log add following
https://www.cyberciti.biz/faq/installing-kernel-2-6-32-131-2-1-el6-x86_64-needs-8mb-on-boot-filesystem/ # xem dung luong ổ boot df -H /boot rpm -qa | grep kernel # xóa các kernel cũ k dùng đến cho nhẹ bớt rpm -e kernel-2.6.32-71……. # xem dung luong ổ boot sau khi xóa df -H /boot yum -y update kernel yum -y update reboot
vi /etc/yum.repos.d/CentOS-Base.repo [base] name=CentOS-$releasever – Base baseurl=http://vault.centos.org/7.9.2009/os/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 [updates] name=CentOS-$releasever – Updates baseurl=http://vault.centos.org/7.9.2009/updates/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 [extras] name=CentOS-$releasever – Extras baseurl=http://vault.centos.org/7.9.2009/extras/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 [centosplus] name=CentOS-$releasever – Plus baseurl=http://vault.centos.org/7.9.2009/centosplus/$basearch/ gpgcheck=1 enabled=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 yum clean all hoặc chạy lệnh sau sed -i s/mirror.centos.org/vault.centos.org/g /etc/yum.repos.d/*.repo sed -i s/^#.*baseurl=http/baseurl=http/g /etc/yum.repos.d/*.repo sed -i s/^mirrorlist=http/#mirrorlist=http/g /etc/yum.repos.d/*.repo