Wagento Creative

  • Apple News - New Laptop With No Keyboard

    News from the Onion

    The MacBook Wheel lets consumers accomplish everyday tasks like typing with just a few dozen spins and clicks of a wheel.

  • Magento - Combine CSS and JS Files from Admin

    Tips to speed up your Magento site.

    Go to Admin -> System - Configuration -> Developer

    Javascript Settings: Merge Javascript -> YES CSS Settings: Merge CSS Files -> Yes

  • Stuff Apple Owners Say ...

    I had been a long time PC users until 6 months ago. Now I am like a smoker who has quit. This encapsulates the Apple user perfectly!
    Of course the original title was a bit more explicit.


    The creators of the video promise that a follow-up is in the works. I can’t wait to watch it. On my Apple TV. Streamed from my iPad. Because “it just works.”

  • Magento MySQL my.cnf perfect setup

    Here is my ever evolving my.cnf file for a Magento install. If anyone has anything to add please comment, I will add it to my script and test!

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    
    #innodb settings
    innodb_log_file_size=100M
    innodb_additional_mem_pool_size=20M
    innodb_flush_log_at_trx_commit=2
    innodb_lock_wait_timeout=1800
    innodb_buffer_pool_size=20G 
    
    #other vars
    net_read_timeout=120
    skip-locking
    skip-name-resolve
    table_cache=2048
    thread_cache_size=16
    back_log=100
    max_connect_errors=10000
    open-files-limit=20000
    interactive_timeout=3600
    wait_timeout=1800
    max_connections=200
    key_buffer_size=1G
    connect_timeout=120
    
    #skip-name-resolve
    max_allowed_packet=16M
    tmp_table_size=64M
    max_heap_table_size=64M
    query_cache_size=256M
    sort_buffer_size=1M
    read_buffer_size=1M
    read_rnd_buffer_size=8M
    join_buffer_size=3M
    
    old_passwords=1
    
  • The Best Dedicated Server for Magento

    This posting is more for question answers than anything else.

    Background:

    I do a lot of Magento upgrades, the bottom line, your upgrading server matters. What I would like to do is collaborate (knowledge) on the best machine (and the cheapest) and the best configuration on a single dedicated server.

    My best case example is a 4gb Magento 1.3 database run on a HPDL160 G6 Dual Quad Core 1.6ghz processors, 16gb RAM, and SATA 7200rpm drives.

    I installed and configured CentOS 5.5 with MySQL 5.1. I tuned MySQL (I will post a script later)

    I will use my desktop machine (at the time) as my benchmark.
    Intel i7 Quad core
    16gb Memory
    7200 RPM SATA Drive
    CentOS 5.5, MySQL 5.1
    (Purchased all from Microcenter)

    In addition, I also tested a Dual Intel i7 Quad Core with 16GB memory and a 7200RPM SATA drive running Ubuntu 10.04

    My best completion time on my Desktop Machine was 12 hours
    My best completion time for the Ubuntu Desktop was 10 hours
    My best completion time for the HP G6 was just under 5 hours.

    My latest endevor involves a HP DL385 AMD Quad -Dual Core server (4-dual core CPUs) with 32GB memory and RAID 5 SCSI Ultra 320.

    A 2gb Magento database is taking more than 12 hours to upgrade.

    I am not a hardware GURU, so I am looking for some explanations on why the G6 ran so much faster? In addition, I would be happy to post anyone configuration that allows for the fastest Magento upgrades. Ideally I would like to first find the optimum server configuration, then find the optimum server.

  • Super Easy Magento Compatible Centos Install

    The Basic Magento Web Server Install Guide

    This install guide assumes that you already have the basic install of Centos 5.6 complete. We will now install Apache, MySQL and PHP 5.2.17

    First let's install some basic tools

    yum groupinstall 'Development Tools'
    yum groupinstall 'Development Libraries'
    

    Ok let's install Apache, NTP and MySQL

    yum install ntp httpd mysql-server httpd-devel
    

    Look to see what PHP packages are installed and remove any if needed.

    rpm -qa | grep php
    

    remove all php 5.3 packages

    We are going to need some re-requisites for our PHP so lets install them now!!

    yum install libc-client libmcrypt libmhash net-snmp libtidy  unixODBC-devel libpng-devel libmcrypt-devel
    

    Now we are ready to install PHP5.2.17

    cd ~/mkdir php5.2.17
    cd php5.2.17
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-bcmath-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-cli-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-common-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-dba-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-devel-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-eaccelerator-5.2.17_0.9.6.1-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-gd-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-imap-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-ldap-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-mbstring-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-mcrypt-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-mhash-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-mysql-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-ncurses-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-odbc-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-pdo-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-pgsql-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-readline-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-snmp-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-soap-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-tidy-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-xml-5.2.17-1.x86_64.rpm'
    wget 'http://www.atoomnet.net/./php/php-5.2.17/php-xmlrpc-5.2.17-1.x86_64.rpm'
    rpm -ivh *.rpm
    

    (I removed wget 'http://www.atoomnet.net/./php/php-5.2.17/php-mssql-5.2.17-1.x86_64.rpm')

    Make sure MySQL is on

    chkconfig --levels 235 mysqld on
    /etc/init.d/mysqld start
    

    And let's make sure we have MySQL locked down (follow instructions)

    mysql_secure_installation
    

    Make sure Apache is on

    chkconfig --levels 235 httpd on
    /etc/init.d/httpd start
    

    Finally, add another repo

    cd /etc/yum.repos.d/
    wget http://centos.karan.org/kbsingh-CentOS-Extras.repo
    

    then make the following changes:

    vi /etc/yum.repos.d/kbsingh-CentOS-Extras.repo
    

    gpgcheck to 0 and enabled to 1 in the [kbs-CentOS-Testing]

    You will need to configure your Apache and MySQL

  • Magento events: Cheat Sheet

    This post is for me as well as for everyone else who is always looking for the Magento events.

    My personal favorite is from Mastering Magento:

    http://masteringmagento.com/2010/06/events-list-in-magento-community-1-4/

    The section that I found most helpful is this

    $this->_eventPrefix.'_add_is_active_filter
    $this->_eventPrefix.'_delete_after
    $this->_eventPrefix.'_delete_after_done
    $this->_eventPrefix.'_delete_before
    $this->_eventPrefix.'_delete_commit_after
    $this->_eventPrefix . '_load_after
    $this->_eventPrefix.'_load_after
    $this->_eventPrefix . '_load_before
    $this->_eventPrefix.'_move_after
    $this->_eventPrefix.'_move_before
    $this->_eventPrefix.'_'.$process.'_process_run_after
    $this->_eventPrefix.'_'.$process.'_process_run_before
    $this->_eventPrefix.'_save_after
    $this->_eventPrefix.'_save_before
    $this->_eventPrefix.'_save_commit_after
    $this->_eventPrefix.'_validate_after
    $this->_eventPrefix.'_validate_before
    

    What we can do is take the event prefix from the list below and attach the action after. So for example you catalog_product event you want to do something after you simple do catalog_product_save_after. This is in no way a comprehensive list. The website Mastering Magento does offer a script to generate the Magento Events on your Linux server (I have not tried it)

    admin_roles
     admin_user
     catalog_category
     catalog_category_collection
     catalog_compare_item
     catalog_entity_attribute
     cataloginventory_stock_item
     catalog_product
     catalogrule_rule
     cms_page
     core_abstract
     core_config_data
     customer
     customer_address
     customer_entity_attribute
     customer_group
     eav_entity_attribute
     eav_form_element
     eav_form_fieldset
     eav_form_type
     giftregisty_gift
     newsletter_subscriber
     review
     sales_creditmemo_item
     sales_invoice_item
     sales_order
     sales_order_creditmemo
     sales_order_invoice
     sales_order_item
     sales_order_shipment
     sales_order_shipment_track
     sales_quote
     sales_quote_address
     sales_quote_item
     sales_quote_payment
     salesrule_rule
     sales_shipment_item
     store
     store_group
     system_config_price_scope
     tag
     website
     wishlist_item
    

    Nick Says has a very good list of Magento 1.5 Events here

    http://www.nicksays.co.uk/magento_events_cheat_sheet/

    Twitter: @brentwpeterson on Twitter
    Linkedin: http://www.linkedin.com/in/brentwpeterson
    View My Magento Profile

101-107 of 107

Page:
  1. 1
  2. ...
  3. 7
  4. 8
  5. 9
  6. 10
  7. 11