MySQL monitoring tools
Hi,
Here's a couple of tools that may help in monitoring MySQL performace:
- mysqlresources script - Measuring resources for a MySQL server on Linux (looking at /proc)
- innotop script - MySQL and InnoDB monitor (requires InnoDB)
Anyone using similar scripts to monitor high performance mysql servers?
Cheers
Read moreexcellent idea - some starting points
I've posted on standard benchmarking information before (with no responses...) in the performance and scalability forum which is a pretty good source of information in general.
Read moreFast private file transfers for Drupal
For those looking to have Drupal serve private files efficiently, I've posted a simple core patch that adds X-Sendfile support:
http://drupal.org/node/74472
Views Fields and Performance
In this post
http://drupal.org/node/67502
I describe my troubles with slow views. I learned that as I add fields to my views (esp. fields from different tables), queries slow down a lot. My solution was remove all fields from my views, then load them inside my theme_views_view_... function, using node_load(). This cut my page execution time from 6 seconds to 1 second.
Now I find that I am doing all my views this way, for performance optimization. I find it too expensive to add fields to my views (for CCK nodes anyway, which is ~all I am using).
So I wonder if CCK's views implementation could effectively do this in the background.
Read moreusing ereg* functions
I just noticed 35 occurences of ereg* functions in Drupal code (most of them in modules, 4.6.6).
This short story is just a memo to advise all developers NOT to use ereg* functions and use preg_match instead, which is significantly faster. I would also like to do same stats in Drupal 4.7 and collect some volunteers to provide patches replacing ereg with preg_match.
bash-3.00$ grep -Ri "ereg" * | wc -l
35
bash-3.00$
Any volunteers?
Read moreusing quotes and double quotes
This is about PHP common development mainly, some advices to improve strings parsing performance.
Read moreimproving performance: magic_quotes_gpc
Just make sure, you have magic_quotes_gpc variable in php.ini set to Off, otherwise, Drupal will walk all $_GET, $_POST, etc. arrays to manually fix magic quotes. This can affect Drupal performance.
Read more