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!
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
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.
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.
# 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
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!
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:
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
- 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.
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?