سلام
سرور مجازی من هاردش پر میشه برای همین Mysql کار نمیکنه
نتیجه جستجویکد:[root@server ~]# df -hFilesystem Size Used Avail Use% Mounted on /dev/vda1 144G 137G 230M 100% / tmpfs 1.5G 0 1.5G 0% /dev/shm
حجم فایل /var/lib/mysql/ibdata1 تقریبا 6 گیگ و هر کدوم از فایلهای داخل var/lib/mysql/ که توی لیست بالا اومدن تقریبا 1 گیگ هستکد:[root@server ~]# find / -size +1000M/var/lib/mysql/mysql-bin.000021 /var/lib/mysql/mysql-bin.000093 /var/lib/mysql/mysql-bin.000354 /var/lib/mysql/mysql-bin.000114 /var/lib/mysql/mysql-bin.000019 /var/lib/mysql/mysql-bin.000015 /var/lib/mysql/mysql-bin.000082 /var/lib/mysql/mysql-bin.000060 /var/lib/mysql/mysql-bin.000020 /var/lib/mysql/mysql-bin.000034 /var/lib/mysql/mysql-bin.000199 /var/lib/mysql/mysql-bin.000025 /var/lib/mysql/mysql-bin.000139 /var/lib/mysql/mysql-bin.000080 /var/lib/mysql/mysql-bin.000077 /var/lib/mysql/mysql-bin.000010 /var/lib/mysql/mysql-bin.000012 /var/lib/mysql/mysql-bin.000178 /var/lib/mysql/mysql-bin.000131 /var/lib/mysql/mysql-bin.000253 /var/lib/mysql/mysql-bin.000363 /var/lib/mysql/mysql-bin.000084 /var/lib/mysql/mysql-bin.000040 /var/lib/mysql/mysql-bin.000079 /var/lib/mysql/mysql-bin.000051 /var/lib/mysql/mysql-bin.000083 /var/lib/mysql/mysql-bin.000059 /var/lib/mysql/mysql-bin.000128 /var/lib/mysql/mysql-bin.000004 /var/lib/mysql/mysql-bin.000081 /var/lib/mysql/mysql-bin.000011 /var/lib/mysql/mysql-bin.000076 /var/lib/mysql/mysql-bin.000271 /var/lib/mysql/mysql-bin.000069 /var/lib/mysql/mysql-bin.000070 /var/lib/mysql/mysql-bin.000358 /var/lib/mysql/mysql-bin.000003 /var/lib/mysql/mysql-bin.000364 /var/lib/mysql/mysql-bin.000092 /var/lib/mysql/mysql-bin.000362 /var/lib/mysql/mysql-bin.000026 /var/lib/mysql/mysql-bin.000049 /var/lib/mysql/mysql-bin.000073 /var/lib/mysql/mysql-bin.000183 /var/lib/mysql/mysql-bin.000047 /var/lib/mysql/mysql-bin.000007 /var/lib/mysql/mysql-bin.000008 /var/lib/mysql/mysql-bin.000022 /var/lib/mysql/mysql-bin.000197 /var/lib/mysql/mysql-bin.000196 /var/lib/mysql/mysql-bin.000043 /var/lib/mysql/mysql-bin.000355 /var/lib/mysql/mysql-bin.000002 /var/lib/mysql/mysql-bin.000006 /var/lib/mysql/mysql-bin.000357 /var/lib/mysql/mysql-bin.000132 /var/lib/mysql/mysql-bin.000005 /var/lib/mysql/mysql-bin.000172 /var/lib/mysql/mysql-bin.000192 /var/lib/mysql/mysql-bin.000038 /var/lib/mysql/mysql-bin.000037 /var/lib/mysql/mysql-bin.000072 /var/lib/mysql/mysql-bin.000027 /var/lib/mysql/mysql-bin.000198 /var/lib/mysql/mysql-bin.000335 /var/lib/mysql/mysql-bin.000055 /var/lib/mysql/mysql-bin.000016 /var/lib/mysql/mysql-bin.000356 /var/lib/mysql/mysql-bin.000017 /var/lib/mysql/mysql-bin.000078 /var/lib/mysql/mysql-bin.000018 /var/lib/mysql/ibdata1 find: `/proc/3108/task/3108/fd/5': No such file or directory find: `/proc/3108/task/3108/fdinfo/5': No such file or directory find: `/proc/3108/fd/5': No such file or directory find: `/proc/3108/fdinfo/5': No such file or directory
من زیاد از دیتابیس استفاده میکنم و اطلاعت نوشته و پاک میشن
حجم دیتابیس اصلی من تقریبا 7 گیگ هستش
کل دیتابیسم panel رو بکاپ گرفتم پاک کردم و دوباره بکاپ ریختم اما درست نشدکد:du -h /var/lib/mysql/212K /var/lib/mysql/performance_schema 29M /var/lib/mysql/temp 6.9G /var/lib/mysql/panel 1.6M /var/lib/mysql/da_atmail 1.1M /var/lib/mysql/mysql 176K /var/lib/mysql/da_roundcube 131G /var/lib/mysql/
جدول های اصلی من با انیجن innodb هستش که اطلاعت زیادی نوشته و حذف میشن
ممنون میشم راهنمایی کنید
- - - Updated - - -
خودم یافتم
اینا فایل لاگ بودش .
الان اگه دستور
بزنم مشکلی پیش نمیاد ؟کد:find /var/lib/mysql/ -type f -name "mysql-bin.*" -exec rm -f {} \;






پاسخ با نقل قول