Skip to content

Instantly share code, notes, and snippets.

@Sacristan

Sacristan/Wordpress_KB.md

Last active May 18, 2016 07:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Sacristan/26d0a5176a92c9d2e0bb1d44b04b64a5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Sacristan/26d0a5176a92c9d2e0bb1d44b04b64a5 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Sacristan renamed this gist May 18, 2016. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions MySQL_KB.md → Wordpress_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -5,6 +5,8 @@ sudo rvim /etc/mysql/my.cnf

    80% RAM to innodb_buffer_pool_size -> https://www.percona.com/blog/2015/06/02/80-ram-tune-innodb_buffer_pool_size/


    #XMLRPC issues
    Search for XMLRPC POST logs
    ```
    grep xmlrpc.php /var/log/apache2/access.log
    @@ -20,8 +22,6 @@ Deny from all
    </Files>
    ```

    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

    #GET memory usage
    http://php.net/manual/en/function.memory-get-usage.php

  2. Sacristan revised this gist May 18, 2016. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -13,11 +13,12 @@ grep xmlrpc.php /var/log/apache2/access.log
    * /var/www/html/.htaccess
    Add this line to deny access to xmlrpc.php

    ```
    <Files "xmlrpc.php">
    Order Deny,Allow
    Deny from all
    </Files>

    ```

    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

  3. Sacristan revised this gist May 18, 2016. 1 changed file with 9 additions and 0 deletions.
    9 changes: 9 additions & 0 deletions MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -10,6 +10,15 @@ Search for XMLRPC POST logs
    grep xmlrpc.php /var/log/apache2/access.log
    ```

    * /var/www/html/.htaccess
    Add this line to deny access to xmlrpc.php

    <Files "xmlrpc.php">
    Order Deny,Allow
    Deny from all
    </Files>


    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

    #GET memory usage
  4. Sacristan revised this gist May 16, 2016. 1 changed file with 3 additions and 2 deletions.
    5 changes: 3 additions & 2 deletions MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -20,8 +20,9 @@ http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restori

    #SET PHP memory limit Wordpress

    http://ideaboxthemes.com/increase-php-memory-limit-wordpress/
    source: http://ideaboxthemes.com/increase-php-memory-limit-wordpress/
    ```
    sudo rvim /etc/php5/apache2/php.ini
    memory_limit = 128M
    memory_limit = -1 (unlimited)

    ```
  5. Sacristan revised this gist May 16, 2016. 1 changed file with 4 additions and 4 deletions.
    8 changes: 4 additions & 4 deletions MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    * Edit MySQL config: *
    #Edit MySQL config:
    ```
    sudo rvim /etc/mysql/my.cnf
    ```
    @@ -12,13 +12,13 @@ grep xmlrpc.php /var/log/apache2/access.log

    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

    * GET memory usage *
    #GET memory usage
    http://php.net/manual/en/function.memory-get-usage.php

    * PHP memory limit*
    #PHP memory limit
    http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restoring-memory-php

    * SET PHP memory limit Wordpress *
    #SET PHP memory limit Wordpress

    http://ideaboxthemes.com/increase-php-memory-limit-wordpress/
    sudo rvim /etc/php5/apache2/php.ini
  6. Sacristan revised this gist May 16, 2016. 1 changed file with 8 additions and 4 deletions.
    12 changes: 8 additions & 4 deletions MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    Edit MySQL config:
    * Edit MySQL config: *
    ```
    sudo rvim /etc/mysql/my.cnf
    ```
    @@ -12,10 +12,14 @@ grep xmlrpc.php /var/log/apache2/access.log

    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

    GET memory usage -> http://php.net/manual/en/function.memory-get-usage.php
    PHP memory limit -> http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restoring-memory-php
    * GET memory usage *
    http://php.net/manual/en/function.memory-get-usage.php

    * PHP memory limit*
    http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restoring-memory-php

    * SET PHP memory limit Wordpress *

    SET PHP memory limit Wordpress
    http://ideaboxthemes.com/increase-php-memory-limit-wordpress/
    sudo rvim /etc/php5/apache2/php.ini
    memory_limit = 128M
  7. Sacristan revised this gist May 16, 2016. 1 changed file with 8 additions and 1 deletion.
    9 changes: 8 additions & 1 deletion MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -13,4 +13,11 @@ grep xmlrpc.php /var/log/apache2/access.log
    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

    GET memory usage -> http://php.net/manual/en/function.memory-get-usage.php
    PHP memory limit -> http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restoring-memory-php
    PHP memory limit -> http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restoring-memory-php

    SET PHP memory limit Wordpress
    http://ideaboxthemes.com/increase-php-memory-limit-wordpress/
    sudo rvim /etc/php5/apache2/php.ini
    memory_limit = 128M
    memory_limit = -1 (unlimited)

  8. Sacristan revised this gist May 16, 2016. 1 changed file with 6 additions and 1 deletion.
    7 changes: 6 additions & 1 deletion MySQL_KB.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,4 +8,9 @@ sudo rvim /etc/mysql/my.cnf
    Search for XMLRPC POST logs
    ```
    grep xmlrpc.php /var/log/apache2/access.log
    ```
    ```

    find / -xdev -type f -print0 | xargs -0 grep -H "ini_set('memory_limit'"

    GET memory usage -> http://php.net/manual/en/function.memory-get-usage.php
    PHP memory limit -> http://stackoverflow.com/questions/10738990/ini-set-ini-get-memory-limit-restoring-memory-php
  9. Sacristan renamed this gist May 11, 2016. 1 changed file with 0 additions and 0 deletions.
    0 MySQL KB → MySQL_KB.md
    View file
    File renamed without changes.
  10. Sacristan revised this gist May 11, 2016. 1 changed file with 6 additions and 2 deletions.
    8 changes: 6 additions & 2 deletions MySQL KB
    View file
    Original file line number Diff line number Diff line change
    @@ -1,7 +1,11 @@
    Edit MySQL config:
    ``` sudo rvim /etc/mysql/my.cnf ```
    ```
    sudo rvim /etc/mysql/my.cnf
    ```

    80% RAM to innodb_buffer_pool_size -> https://www.percona.com/blog/2015/06/02/80-ram-tune-innodb_buffer_pool_size/

    Search for XMLRPC POST logs
    ```grep xmlrpc.php /var/log/apache2/access.log```
    ```
    grep xmlrpc.php /var/log/apache2/access.log
    ```
  11. Sacristan revised this gist May 11, 2016. 1 changed file with 4 additions and 2 deletions.
    6 changes: 4 additions & 2 deletions MySQL KB
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,7 @@
    sudo rvim /etc/mysql/my.cnf
    Edit MySQL config:
    ``` sudo rvim /etc/mysql/my.cnf ```

    80% RAM to innodb_buffer_pool_size -> https://www.percona.com/blog/2015/06/02/80-ram-tune-innodb_buffer_pool_size/

    grep xmlrpc.php /var/log/apache2/access.log
    Search for XMLRPC POST logs
    ```grep xmlrpc.php /var/log/apache2/access.log```
  12. Sacristan revised this gist May 11, 2016. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion MySQL KB
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,5 @@
    sudo rvim /etc/mysql/my.cnf

    https://www.percona.com/blog/2015/06/02/80-ram-tune-innodb_buffer_pool_size/
    80% RAM to innodb_buffer_pool_size -> https://www.percona.com/blog/2015/06/02/80-ram-tune-innodb_buffer_pool_size/

    grep xmlrpc.php /var/log/apache2/access.log
  13. Sacristan created this gist May 11, 2016.
    3 changes: 3 additions & 0 deletions MySQL KB
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    sudo rvim /etc/mysql/my.cnf

    https://www.percona.com/blog/2015/06/02/80-ram-tune-innodb_buffer_pool_size/