{"id":98,"date":"2014-11-25T22:30:42","date_gmt":"2014-11-25T20:30:42","guid":{"rendered":"http:\/\/yusufziyagulec.com\/?p=98"},"modified":"2014-12-12T11:36:51","modified_gmt":"2014-12-12T09:36:51","slug":"vcenter-veritabani-boyutunu-kucultme","status":"publish","type":"post","link":"https:\/\/yusufziyagulec.com\/blog\/vcenter-veritabani-boyutunu-kucultme\/","title":{"rendered":"Vcenter veritaban\u0131 boyutunu k\u00fc\u00e7\u00fcltme"},"content":{"rendered":"

Vcenter veritaban\u0131 boyutu 10GB s\u0131n\u0131r\u0131na ula\u015ft\u0131\u011f\u0131nda Vcenter hizmeti otomatik olarak duracakt\u0131r. Bunu \u00f6nlemenin tek yolu Vcenter veritaban\u0131 dosyas\u0131n\u0131 (VIM_VCDB) k\u00fc\u00e7\u00fcltmektir. Bunun i\u00e7in a\u015fa\u011f\u0131daki sorgu \u00e7al\u0131\u015ft\u0131r\u0131labilir:<\/p>\n

use\u00a0vim_vcdb\r\ntruncate table vpx_event_arg; \r\ndelete from vpx_event;<\/pre>\n
Daha sonra veritaban\u0131 shrink edilir. Dosya boyutu k\u00fc\u00e7\u00fcld\u00fc\u011f\u00fcnde servis yeniden ba\u015flat\u0131labilecektir.<\/p>\n
* Cannot truncate vpx_event due to the presence of foreign keys inside<\/i><\/strong> hatas\u0131<\/div>\n
vpx_event tablosu \u00e7ok b\u00fcy\u00fckse transaction log dosyas\u0131 (vim_vcdb.ldf) boyutunun artmas\u0131 nedeniyle silme i\u015flemi ba\u015far\u0131s\u0131z olabilir. Bu durumda a\u015fa\u011f\u0131daki komut i\u015fe yarayacakt\u0131r:<\/div>\n
<\/div>\n
\n
delete from vpx_event where create_time < getdate() - DAYS<\/pre>\n<\/div>\n
* DAYS yerine silme i\u015fleminin ba\u015flat\u0131laca\u011f\u0131 ge\u00e7mi\u015fteki g\u00fcn say\u0131s\u0131 girilir.<\/div>\n
<\/div>\n
<\/div>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Vcenter veritaban\u0131 boyutu 10GB s\u0131n\u0131r\u0131na ula\u015ft\u0131\u011f\u0131nda Vcenter hizmeti otomatik olarak duracakt\u0131r. Bunu \u00f6nlemenin tek yolu Vcenter veritaban\u0131 dosyas\u0131n\u0131 (VIM_VCDB) k\u00fc\u00e7\u00fcltmektir. Bunun i\u00e7in a\u015fa\u011f\u0131daki sorgu \u00e7al\u0131\u015ft\u0131r\u0131labilir: use\u00a0vim_vcdb truncate table vpx_event_arg; delete from vpx_event; Daha sonra veritaban\u0131 shrink edilir. Dosya boyutu k\u00fc\u00e7\u00fcld\u00fc\u011f\u00fcnde servis yeniden ba\u015flat\u0131labilecektir. * Cannot truncate vpx_event due to the presence of foreign keys inside… Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,43],"tags":[30,36,9,37,8],"class_list":["post-98","post","type-post","status-publish","format-standard","hentry","category-notlar","category-vmware-2","tag-mssql","tag-sql","tag-vcenter","tag-vcenter-problemi","tag-vmware"],"_links":{"self":[{"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/posts\/98","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":3,"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":101,"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/posts\/98\/revisions\/101"}],"wp:attachment":[{"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yusufziyagulec.com\/blog\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}