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
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!
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’ve collaborated with them and I can say they’re all very 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
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?