MySql performance optimization tricks

- blog

MySql performance optimization is an interesting task, I like to focus on it on my free time.

Please note that these are house rules. There is no guarantee that your performance will improve. Use with precautions!

key_buffer_size

An important variable setting is key_buffer_size; a good value is the 20% of total RAM.

Here it is a sample:

key_buffer_size = 820M

max_connections

Also, the max_connections variable could be safely lowered from its default value. Take a look at your Max used connections status variable; you can safely set the max_connections to Max used connections x 5, with a minimum of 40.

Sample:

max_connections = 85

tmp_table_size and max_heap_table_size

Finally, it’s important to take a look to tmp_table_size and max_heap_table_size. You can get a good value for them by dividing the available RAM by the max_connections variable.

Sample:

# Total RAM: 4GB; Mysql supposed available RAM: 3GB; Max_connections: 85;
# Good Value = 3GB / 80 = 35MB
tmp_table_size = 35M
max_heap_table_size = 35M

Thank you 500000!

- blog

This is a special day for our little project! The Really Simple Share plugin just reached 500,000 downloads; at the same time our Really Simple Twitter Widget plugin reached 100,000 downloads.

We’re busy keeping them (and the other plugins) update and working. At the moment we’re focusing on the Twitter side, making every plugin API 1.1 compliant.

Thank you everyone, for your requests and support!

Cool companies using WordPress in Rome

- blog,

Plugin development for WordPress in Rome? Yes we can!

Today the 2.9 release of Really simple Facebook Twitter share buttons for WordPress is out, with a brand new Pinterest implementation… I recommend you to update quickly because Pinterest backward compatibility is virtually non-existent.

In the meanwhile, here are some links of cool italian companies, using WordPress in Rome  on a daily basis and active on free plugin development.

I worked with them, they’re talented people:

Winsxs folder: save space on windows server 2008 cleaning it

- blog

On Windows Server 2008 R2 the folder winsxs (generally under c:\windows\winsxs) can grow bigger and bigger through time, saving all system updates.

To remove superseded backup images, you can use the dism command from the Administrator command prompt, with the following syntax:

dism /online /Cleanup-Image /spsuperseded

Continue reading →

Some Bookmarks

- blog,
  • Web Speech API for voice driven web apps has been implemented in the Chrome browser (version 25 and later); speech recognition is made over the web with a Google service;
  • Domize is a very fast and smart domain name search engine; it quickly activates as you type, in SSL, also looking for substring automatically;
  • Frank is a free WordPress theme by P.J. Onori, surprisingly fast and clean.

How to show .htaccess and hidden files in ftp sessions

- blog

We had some issues on some websites, so we had to modify some rules in the .htaccess file. Unfortunately, none of the programs we use on windows for ftp connection shows by default this and other hidden files, e.g. the files whose filenames starts with a dot, according to the linux/unix convention.

How to enable hidden files viewing?

Continue reading →