How to clean DB from old logs in Magento 1.x

How to clean DB from old logs in Magento 1.x

Using MySQL

 
truncate log_customer;
truncate log_quote;
truncate log_summary;
truncate log_summary_type;
truncate log_url;
truncate log_url_info;
truncate log_visitor;
truncate log_visitor_info;
truncate log_visitor_online;
 
 
login to shell(SSH) 
go with root/shell folder.

execute the below command inside the shell folder
 
php -f log.php clean
 
enter this command to view the log data's size
php -f log.php status
This method will help you to clean the log data's very easy way.
 

Comments

  1. GAMINGMarch 27, 2018 at 1:22 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. sriramMay 15, 2018 at 2:23 PM

    That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.
    Magento course in chennai

    ReplyDelete
  3. -takipci_satin_al-February 15, 2024 at 6:24 AM

    8D90D
    mexc
    çörek otu sabunu
    kucoin
    bitcoin nasıl oynanır
    copy trade nedir
    kantaron sabunu
    mexc
    huobi
    bitcoin ne zaman çıktı

    ReplyDelete
  4. --takipci satin al-February 18, 2024 at 7:32 AM

    795FD
    poloniex
    bitcoin giriş
    paribu
    bitexen
    4g mobil
    kaldıraç ne demek
    binance
    btcturk
    telegram kripto kanalları

    ReplyDelete
  5. -----------takipci_satin_alFebruary 18, 2024 at 5:49 PM

    C8331
    poloniex
    bitcoin hesabı nasıl açılır
    paribu
    kızlarla canlı sohbet
    binance referans kodu
    cointiger
    bitcoin haram mı
    binance
    paribu

    ReplyDelete
  6. CFE84EsperanzaFFD79April 9, 2024 at 1:06 AM

    9DFCF
    mobil uygulama yapma
    vds satın al
    çıkmış ehliyet soruları 2023
    ev tipi jeneratör fiyatları
    mkr coin yorum
    türkiye proxy
    bnt coin yorum
    dedicated server
    fiziksel sunucu kirala

    ReplyDelete
  7. 8376EMarcoA42CFMay 16, 2024 at 4:30 PM

    2B59D
    Grt Coin Yorum
    Op Coin Yorum
    BTC Forum
    Gal Coin Yorum
    Mkr Coin Yorum
    BTC Son Dakika Haberleri
    Bitcoin Yorum
    Gtc Coin Yorum
    Doge Coin Yorum

    ReplyDelete
  8. pelinJuly 25, 2024 at 9:10 AM

    web postegro
    takipcimx 1000
    techy hit tools
    postegro
    takipçi satın al
    QVMOK

    ReplyDelete

Post a Comment

Popular posts from this blog

Securing the Pi-hole with fail2ban to prevent DNS Amplification attacks

Securing the Pi-hole with fail2ban to prevent DNS Amplification attacks   1. Install fail2ban  sudo apt-get update ; sudo apt-get install fail2ban 2. create jail file vi /etc/fail2ban/jail.d/pihole-dns.conf [pihole-dns] enabled = true port     = 53 action   = %(banaction)s[name=%(__name__)s-tcp, port="%(port)s", protocol="tcp", chain="%(chain)s", actname=%(banaction)s-tcp]            %(banaction)s[name=%(__name__)s-udp, port="%(port)s", protocol="udp", chain="%(chain)s", actname=%(banaction)s-udp] logpath = /var/log/pihole.log findtime = 60 maxretry = 5 bantime = 3600   3. create filter file vi /etc/fail2ban/filter.d/pihole-dns.conf # Fail2Ban configuration file # # script from www.marek.tokyo # [INCLUDES] # Read common prefixes. If any customizations available -- read them from # common.local before = common.conf [Definition] _daemon = dnsmasq # log example from /var/log/pihole.
Read more

Reduce (shrink) and resize raw disk at Proxmox

 Reduce (shrink) and resize raw disk at Proxmox 1. Check the status of raw disk:   #e2fsck -fy /hdd-img/images/111/vm-111-disk-1.raw e2fsck 1.46.5 (30-Dec-2021) Pass 1: Checking inodes, blocks, and sizes Pass 2: Checking directory structure Pass 3: Checking directory connectivity Pass 4: Checking reference counts Pass 5: Checking group summary information /hdd-img/images/111/vm-111-disk-1.raw: 135279/327680000 files (1.8% non-contiguous), 857599886/1310720000 blocks  2. At first, check raw disk size:   #qemu-img info /hdd-img/images/111/vm-111-disk-1.raw image: /hdd-img/images/111/vm-111-disk-1.raw file format: raw virtual size: 4.88 TiB (5368709120000 bytes) disk size: 3.59 TiB  3. Resize filesystem: -M - will resize to the minimum size based on saved files -p - will display progress bar #resize2fs -M -p /hdd-img/images/111/vm-111-disk-1.raw resize2fs 1.46.5 (30-Dec-2021) Resizing the filesystem on /hdd-img/images/111/vm-111-disk-1.raw to 852166716 (4k) blocks. Begin pass 2 (max = 196
Read more