Posts

Showing posts from March, 2014

MySQL 5.6 Wordpress Optimization

My my.cnf I am setting the blog based on information from: 

High Performance Wordpress
SlideShare of Above link

Use of mysqlreport

# Config start

key_buffer = 256M
sort_buffer_size = 4M
read_buffer_size = 4M
innodb_buffer_pool_size = 256M
innodb_log_buffer_size = 8M
tmp_table_size = 32M
max_heap_table_size = 32M
table_open_cache = 128
thread_cache_size = 64
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M

skip-name-resolve

# Set Log
slow_query_log_file=/var/log/mysql-slow-query.log
log_error=/var/log/mysql-error.log

Hope it helps someone.

.htaccess not working?

If you find that you have a proven/tested .htaccess file but for some unknown reasons, you cannot make it work on other server, one thing to check is that if you set "AllowOverride" to "All" instead of "None".

"None" means .htaccess cannot be override.

My example:  My web directory is under htdocs/:

<Directory "/usr/local/apache2/htdocs">
    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   AllowOverride FileInfo AuthConfig Limit
    #
    AllowOverride All
</Directory>

It costed me 1 day to find that out....
Hope it helps someone.

OptimizePress integrated with JVZoo Notes

If you did not receive email after test purchase, use WP Mail SMTP and WP Mail Log to see if you really can send out email.  Chances are your website is blocked from sending out emailTell your hosting service provider if you want to send out email.  They will help you.Follow the optimizepress JVZoo integration video and you should be fine.Do not enable customize email, it seems that it does not use the tinyurl.com to create a URL that buyers can use to register.Integration with JVZoo and Paypal (Non-US currency): I stuck in this part for quite some time.  If you cannot checkout with the $0.01 purchase, the problem is that you have a currency setting that includes both USD and your country currency.  Even though you set USD as your primary currency, when you check out using test purchase, Paypal will still automatically convert it to your country currency.  In Paypal, a $0.01 purchase cannot be converted to other currency because the amount is too little.  This is Paypal problem.  To s…