ورود

توجه ! این یک نسخه آرشیو شده میباشد و در این حالت شما عکسی را مشاهده نمیکنید برای مشاهده کامل متن و عکسها بر روی لینک مقابل کلیک کنید : پر شدن فضای هارد سرور مجازی



k-pax
November 1st, 2015, 10:17
سلام
سرور مجازی من هاردش پر میشه برای همین 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




نتیجه جستجوی

[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


حجم فایل /var/lib/mysql/ibdata1 تقریبا 6 گیگ و هر کدوم از فایلهای داخل var/lib/mysql/ که توی لیست بالا اومدن تقریبا 1 گیگ هست
من زیاد از دیتابیس استفاده میکنم و اطلاعت نوشته و پاک میشن
حجم دیتابیس اصلی من تقریبا 7 گیگ هستش


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/




کل دیتابیسم panel رو بکاپ گرفتم پاک کردم و دوباره بکاپ ریختم اما درست نشد

جدول های اصلی من با انیجن innodb هستش که اطلاعت زیادی نوشته و حذف میشن

ممنون میشم راهنمایی کنید

- - - Updated - - -

خودم یافتم

اینا فایل لاگ بودش .

الان اگه دستور

find /var/lib/mysql/ -type f -name "mysql-bin.*" -exec rm -f {} \;
بزنم مشکلی پیش نمیاد ؟