Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By jvieille on
I started using Drupal a couple of weeks ago, and I am very satisfied with the product. I would like to have an objective opinion on the level of performance I experiment: I am frustrated by the slowness for each editing action. It needs in average 5 seconds to open a page whatever it is, regardless its content. Multiplied by the huge number of content elements I have to fill up and then maintain is almost redhibitory.
This behaviour is very steady. I never get significant better or worst performance.
I am hosted by Blueshost, which is deemed to be a good solution. My internet connection is an optical fiber peaking 100MB/sec
I used to work with MS Frontpage, editing pages on my computer at the light speed and then sychnronizing with the online web site.
My traditional web site on the same server (Frontpage based) refreshes a page in less than half second.
I understand that it will never be like that again soon with a database/php site compared to a pure HTML site, but this slowness seems suspect to me.
I asked Bluehost, but they answered evasively
Is that behavior normal? I observe that the drupal.org web site is even worst but not that much (8 sec for refreshing in average) but this is a huge and highly sollicitated container.
Is there something I could do on the php setting side (I use PHP5 / Fastcgi) or MySQL?
What could I tell to Bluehost support to check
Thanks for any advice and opinion
Comments
Depending on your
Depending on your webserver+database, you should be able to get most pages in a second or so. Did you enable caching, css aggregation, etc in the "performance" section of drupal? After that, start looking at how to tune drupal and mysql. Perhaps start at http://drupal.org/node/2601
Well, one thing i question
Well, one thing i question about this is that when I surf d.o there's no way pages take 8 seconds to load, 1 or 2 sconds max (logged in).
I have a 24mb per second cable connection.
Frankly I have never had great performance running Drupal on a shared host, if its a concern I use VPS or dedicated servers and spend a lot of time performance tuning every last detail - it can make a huge difference. I recommend Rimu hosting or Rackspace (two that I have used and never let me down).
Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
Thank you for your
Thank you for your contributions
My database is still very small, everything is set correctly in Drupal.
I think this has something to do with Bluehost.
JV
You wouldn't happen to have
You wouldn't happen to have a list of sources with these sort of performance/security tweaks, would you?
Thanks either way,
- A
Another factor
First, you're right that manually editing html pages in FrontPage is nothing like using a CMS. That applies to Drupal, and all of the others.
Second, no one mentioned that the particular combination of modules you use can affect performance as well. I suggest that you try disabling all but core modules. Then do some testing to see how performance is. Then go back and enable a single module at a time and test again. You can also use the Devel module; it can show what queries are being run, and how long they take.
Finally, I just tested a shared host site on Bluehost, and didn't get any non-cached operations that took longer than 3 seconds. Different servers have different loads at different times, but this is pretty standard in my experience. Your situation sounds like it is significantly longer at all times.
"Nice to meet you Rose...run for your life." - The Doctor
Catched operations are
Catched operations are actually quite fast.
When browsing anonymously, most displays only take half second.
When loged in, the average is about 2-3 seconds. I would say that browsing is acceptable for users.
The problem is for administrative tasks and editing content.
I'll do some search as you sugest.
Thank you
JV
Some admin tasks take longer
There are some admin tasks that take longer (such as checking for module updates), but editing content, and most admin tasks, take no longer than viewing content.
"Nice to meet you Rose...run for your life." - The Doctor
Bluehost Drupal Hosting
I was happy with Bluehost until I went to Drupal.
Adminitrative taks and editing content is exceedingly under performing,I have to wait seconds or tenths of seconds each time I press a menu item.
When browsing anonymously, the speed is fairly acceptable. This let me think that the datbase performance is poor.
Bluehost is quite silent or evasive on my requests.
Any experience with Bluehost that would confirm that no hope is permitte with shared hosting, even when oit is well ranked as Bluehost?
JV
Takes 30 minutes to change permissions
I am back on this issue.
I can understand that shared hosting is not the fastest solution, but Bluehost does not have bad reputation, and I do not experience terrible perfromances when transferring files or processing around the databases.
My Drupal database is still quite small (100 tables, 2 MB)
I enquired about the slowness of each opening / saving contents that rarely take less than 30 seconds. This makes a half day job in best conditions taking 3 days in my case. I don't feel that it is normal.
But this looks definitely abnormal to me : Editing permissions takes 15 minutes to open the page and the same time for saving the changes...
Is it normal that these operations suck 100% of my processor so I can have a full coffee process, from making to draining it.
(I cannot do anything with IE during this time, and not more with anything else on the computer)
Any similar experience? Am I abnormally hurried, or am I suffering some unidentified adversity?
JV
Hello, I observed much of
Hello, I observed much of the same behavior when I first started, but not in lengths that you are mentioning. I can wait about 15sec to open my module page (IT's MASSIVE).
But to be honest, I think you must be experiencing something abnormal.
With Devel module checking my page load time it's about 3-4sec for logged in users, and less for anonymous.
I have about 13 views loaded PER page, using panels, views & cck.
Very few images however, and the bandwidth per page is low, just LOTS of database hits.
I'm on a shared host (Hostgator).
For production it's been fine, but I will be moving once the site is complete as I've had "out of memory" errors.
I don't use IE so I wouldn't know, but I DO have Firefox "freeze" on me sometimes when I load a new admin page. Sometimes this can last a good 5 seconds or longer and go to Not Responding... then BANG, it kicks back in. Sometimes a JQuery error pops up saying that it was having a problem running. I'm curious and lead to believe that the slow down might have something to do with that, or other possible conflicts.
Keep in mind that I have all caching and performance improvements turned OFF.
I do have to agree that Admin Tasks are slower then surfing the site itself, but mainly on pages like views, access control, and modules. These are EXTREMELY long pages that actually are very intensive.
If you are looking for faster development time I would recommend setting up a WAMP server or something and develop it locally then move. This will cut down the time considerably.
Computer 100% loaded when accessing permissions
This is related to the intial topic, it in fact triggered my initial question.
For some reasons discussed above, (shared hosting can never achieved an appropriate level of performance for site building / large maintenance jobs), some pages are quite slow to load.
Specifically, the permission settings page takes about 20 minutes to load, and the same to commit changes.
Though this is almost unbearable by its own, the biggest issue is that the process sucks 100% of the computer power: no way to do anything during these 2 * 20 minutes operations. (I would live with this long delays if I could work in the meantime...)
Is it normal that the client browser monopolyses the whole computer during the loading and the the saving, though there is no significant traffic with the server. Is this because of Winddows, on Browser normal behavioir, on PHP, or on the way Drupal is programmed?
Side question: is 20 minutes something unusual with shared hosting to process permissions?
JV
20 seconds would be more
20 seconds would be more normal, 20 minutes is just insane - I would pull my hair out and shift host before the next 20 minute page load completed...
I wonder if you are using Firefox 2, which is a resource hog and will eventually eat all your RAM. I'm thinking you should try Google Chrome, which opens each tab a separate instance, perhaps this might help?
Wonder if you have admined the site from another computer, as this sounds stupidly slow, even for overloaded shared hosting, one thinks the server would have thrashed itself to death in 20 mins if it were that overloaded.
Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
Google Chrome made a miracle
I downloaded Google Chrome and made a try: it took 10 seconds to open or save the permission page instead of 20 minutes with IE7
In addition, this page appeared totally messy in IE7, while it looks perfect with GC.
Thank you for your insight. You saved me
JV
Hooray!
Hooray!
Glad you got it sorted, maybe I am thinking your site has a JavaScript error that webkit (the engine under Chrome, same as Safari) is silently dropping whereas IE is caught in a loop.
Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
Firefox works too
I tried Firefox, and it opened and saved correctly the permission page
I seems slower than GC yet (15-20 seconds), and the look is terrible... Big ugly fonts.
I don't see any error, I don't know exactly how to catch them.
This seems to come from the permission page itself. This page is getting quite big with 11 roles and probably hundreds of items (field level permissions expands this setting dramatically).
JV
The fact your site acts so
The fact your site acts so differently in each browser and fonts look different etc, is a blatent point that the problem does not lie in drupal, but with the host/user. Like the post a couple above, you need to check out your javascript and see if anything is crapping out. Also remember that just because bluehost has a good reputation doesn't mean they offer powerful service. Much of the slowdown you could be experiencing can be throttling (popular on shared hosts), also you could have limited simultaneous connections to your mysql (more = faster). Normally when there's a caching problem, it can quit and then you can have a corrupted cache that it keeps trying to dump, making you wait a very long time. The #1 suggestion in ALL of these threads is to find atleast a vps where you can allocate more ram, etc. Don't bother saying it should run fine on a sharehost. Do a fresh install put in 5-10 modules it should run fine on a sharedhost. Go over that and don't complain, you'll need a vps with more control to optimize. Just because drupal is free and open source, does not mean that it runs fine on super cheap hosts (regardless of reputation).
I moved from hostgator, my friend moved from site5, and another from godaddy we are all VERY happy with the move and saw immediately performance increases.
The other benefit is caching. On VPS you can use php accelerators like memcache, apc, eaccelerator.
You can't use these on shared hosts, you can't raise php memory above 64MB, mysql is limited to 1MB probably 4-8 connections, really just sub par. You're also at bay to any other sites your sharing with. Get on the server with a hog and you're site will run like poo, even with no traffic.
Admin section stuff always takes longer mine takes 3-4 seconds, my site takes 1-2. Anonymous viewers see it in under a second generally.
Thanks for your advices. I
Thanks for your advices.
I am currently happy with my shared hosting now I am using Chrome instead of IE7
Anonymous users get in 1-3 seconds
Administrative section come in 3-10 seconds
I did not found any Javascript problem (don't really know were to look for that actually... IE is silent, just let me waiting, Windows event observer does not report anything)
I would be happy to switch to VPS, however I am a little bit affraid about the headache for transfering my domains registrations/DNS, and the 10 folds cost...
JV
Obviously you didn't read
Obviously you didn't read much.
10 Fold cost? You pay $2.00 for your hosting now? Wow that's cheap. My VPS hosting is only $20.00 at Eapps.com and slicehost has similar pricing. Heck do a search you'll find dozens with packages as low as $10.00
Also, transfering a DNS is simple as typing "ns1.eapps.com is your dns settings from your control panel. You don't need to transfer registrations to point them to a new name server.
And remember that the bigger your site gets, the more difficult it is to move. And the bigger it gets the more likely you'll HAVE to move.
If you avoided exaggerating things and did some research you might find it's very simple. Shared hosts are marketing schemes for suckers, advertising and offering unrealistic, unobtainable bandwidth and space limits, because they know the people that fall for there marketing will never actually USE the resources. Also remember many of them may not limit your monthly bandwidth or your space, but did you know that they often limit your thorough put? Meaning the speed at which you send?
Either way, best of luck, glad things are working for you. Remember that Chrome is a beta, and just a tip. MOST developers use firefox, because 1 it is NOT IE, it is NOT beta, and it has the best and easiest set of developers tools. If you are building a website you may want to check into that.
If your site doesn't work well in all browsers, you should concider it broken. Because it will be to some of your users.
You may want to take into
You may want to take into account that you have mentioned your site doesn't work well in either IE or Firefox, the 2 top browsers. A VERY small fraction of the web actually uses google chrome. Unless it's just a site for you and only you, always on the same browser, I'd suggest finding the root of the problem.
The site works the same with
The site works the same with any browser for a visitor.
It is just that some admin tasks get stuck with IE7.
The VPS hosting plans I have found ont he web are around 50$/month, I currently pay 99$ per year. Not ten folds, but around 6.
I would be glad to get the names of reliable, cheap VPS hosting provider...
JV
Like I said 2x in this
Like I said 2x in this thread, feel free to check out eapps.com or even slicehost there's many others as well.
If it's crapping out in the admin pages in certain browsers it's most likely javascript issue.
OK, OK
Thank you for your patience and determination despite my jumpy reading on your posts.
I begin to understand and may be convinced by soon...
I found a French (local), serious provider for RPS - dedicated 512K CPU, 10GB on a shared drive for 10€/month...
JV
How fast is your site to
How fast is your site to authenticated users?
I know you said it was fast to 'visitors', and you can tolerate the administrative slow down when you loading your modules, but what kind of speed hit do your authenticated users take?
Authenticated user speed
Not exactly speedy: 4-5 second per page.
I guess catching is not used for them.
Anyway, I disabled the caching as the speed is almost OK for anonymous.
JV
try dropping a php.ini file
try dropping a php.ini file in the root directory of your drupal install and set the memory limit to
= 40M
Turn on regular caching I think it is under site performance - not agressive.
Next turn on caching of your css and javascript.
Then cache the site for anon users. they will get served quicker.
How many modules have you installed? depending on the amount of modules, which kind and the themes and how you arange your pages, this will all affect the speed of drupal. Each of those shiny goodies make calls to the db. Depending on how you setup your pages to display you can get the same effect without so many db calls.
specially since its a shared host and everyone is fighting for the resources on one box.
I have 66 ticked items in
I have 66 ticked items in the page module (all necessay for my site)
I already set the memory limit to 96M - the site does not work with lower values
I just reactivated the cache, but this should not help for authenticated users
Thanks for your advices
JV
Speed update
JVI finally give a try to a dedicated server hosting very near to my location (Paris, France).
I have a 100Mb fiber connexion, a 100Mb server connection too.
I work on this system as it was my desktop, so the comparison with a shared hosting in US (Bluehost) might be interesting
Caching is didabled
Google Chrome
- logged in as administrator: I get any page at the constant delay of 3seconds. The heavy Permission page comes in 7 seconds, no crash
- logged out: 1 second
Firefox
- Logged in : 3-4 seconds - Permission in 12 seconds / sometimes crashes
- logged out: 1 seconds
IE7
- Logged in: 6-9 seconds - Permission crashes
- Logged out : 1 second
So this is good, but not as good as I wished. Creating/editing content is still annoying with a 3 seconds delay after each opening/saving action.
Doe anyone knows what can be done to improve that (tweaking MySQL I suppose)
JV
I dont think these values
I dont think these values are normal. It should be much faster than this. Was this a fresh install of Drupal? How long has it been since you optimized your computer?(defrag, checkdisk,cleaned browser cache, lots of plugins in browser?) How powerful is your computer?(cpu? ram?)
etc...
New tests - Local Wamp server, Disabled all modules
The RPS server is equipped with an Intel Celeron 1,2-1,33 GHz, 32/64 bits, RAM 512 K- the HDD is a networked iSCSI or NFS
I tried to setup a local wamp server on an "old" machine - 1GHZ PIII - 632 MB RAM
The results are terrible. It takes at least 12" to get any page when loged in, 3" for anonymous - cache disabled
I disabled all the modules I could. Times are divided by 2, still unacceptable
May be upgrading to the more powerfull configuration could make it. The hosting provider has 2 other RPS options
Intel Atom Dual 2x 1.6 GHz RAM 1GO
AMD Athlon 64 2x 1.9 GHz RAM 2GO
(But the disk is still a pseudo on a network)
What do you mean a "fresh Drupal install?"
Is there a chance that would release some blockade that would not be apparent in operation?
How could I check if something goes wrong in my site? (I get no warning at any time)
JV
nfs is not good. It tends
nfs is not good. It tends to lock up.
If you are running this site I would definitely check the read writes or I/O.
As far as fresh install - did you just install it?
Since you are just setting up your site then the cpu and ram are going to be negligable since you are not getting traffic.
Exactly why is your host forcing you to use NFS? Why cant your write from memory to the disk? Why must you read and write over nfs? IF there is no reason...get rid of it.
The disk is networked using
The disk is networked using iSCSI, not NFS. (this is a networked drive, not a physical local disk)
Did you noticed that my local config is much worse than this remote server?
Regarding the install, I just copied all the files and import the database, (plus some tweeks in system conf and ini files) that's all.
JV
iSCSI is fine. You probably
iSCSI is fine. You probably want to start by tweaking your my.cnf then. Take a look at that and see if increasing values that it uses helps.
Specifically target the memory and cache limits.
MySQL current variables
Bellow the current values of MySQL variables. Which ones could be wrong?
Thanks for help...
Variable name Current value
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_home /var/lib/mysql/
bdb_log_buffer_size 32768
bdb_logdir
bdb_max_lock 10000
bdb_shared_data OFF
bdb_tmpdir /tmp/
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 5
datadir /var/lib/mysql/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
div_precision_increment 4
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)
group_concat_max_len 1024
have_archive NO
have_bdb YES
have_blackhole_engine NO
have_compress YES
have_crypt YES
have_csv NO
have_dynamic_loading YES
have_example_engine NO
have_federated_engine NO
have_geometry YES
have_innodb DISABLED
have_isam NO
have_merge_engine YES
have_ndbcluster NO
have_openssl DISABLED
have_ssl DISABLED
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
hostname r17077.ovh.net
init_connect SET NAMES latin1
init_file
init_slave
innodb_additional_mem_pool_size 2097152
innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 16777216
innodb_checksums ON
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_data_file_path ibdata1:10M:autoextend:max:128M
innodb_data_home_dir
innodb_doublewrite ON
innodb_fast_shutdown 1
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 1
innodb_flush_method
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 8388608
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_rollback_on_timeout OFF
innodb_support_xa ON
innodb_sync_spin_loops 20
innodb_table_locks ON
innodb_thread_concurrency 8
innodb_thread_sleep_delay 10000
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 16777216
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language /usr/share/mysql/english/
large_files_support ON
large_page_size 0
large_pages OFF
lc_time_names en_US
license GPL
local_infile ON
locked_in_memory OFF
log OFF
log_bin ON
log_bin_trust_function_creators OFF
log_error /var/log/mysql/mysqld.err
log_queries_not_using_indexes OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 2046976
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connect_errors 10
max_connections 100
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_insert_delayed_threads 20
max_join_size 4294967295
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
multi_range_count 256
myisam_data_pointer_size 6
myisam_max_sort_file_size 2147483647
myisam_recover_options OFF
myisam_repair_threads 1
myisam_sort_buffer_size 8388608
myisam_stats_method nulls_unequal
net_buffer_length 8192
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords OFF
open_files_limit 1024
optimizer_prune_level 1
optimizer_search_depth 62
pid_file /var/run/mysqld/mysqld.pid
port 0
preload_buffer_size 32768
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 0
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 258048
read_only OFF
read_rnd_buffer_size 520192
relay_log_purge ON
relay_log_space_limit 0
rpl_recovery_rank 0
secure_auth OFF
secure_file_priv
server_id 1
skip_external_locking ON
skip_networking ON
skip_show_database OFF
slave_compressed_protocol OFF
slave_load_tmpdir /tmp/
slave_net_timeout 3600
slave_skip_errors OFF
slave_transaction_retries 10
slow_launch_time 2
socket /var/run/mysqld/mysqld.sock
sort_buffer_size 524280
sql_big_selects ON
sql_mode
sql_notes ON
sql_warnings OFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_key
storage_engine MyISAM
sync_binlog 0
sync_frm ON
system_time_zone CET
table_cache 64
table_lock_wait_timeout 50
table_type MyISAM
thread_cache_size 0
thread_stack 196608
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 33554432
tmpdir /tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
updatable_views_with_limit YES
version 5.0.44-log
version_bdb Sleepycat Software: Berkeley DB 4.1.24: (January 21, 2008)
version_comment Gentoo Linux mysql-5.0.44-r2
version_compile_machine i686
version_compile_os pc-linux-gnu
wait_timeout 28800
JV
try adding this to your
try adding this to your my.cnf file or my.ini file if you are using windows:
#my stuff
long_query_time=5
log-slow-queries=/var/log/slowqueries.log
max_connections=100
join_buffer_size=4M
read_buffer_size=16M
sort_buffer_size=32M
key_buffer=8M
table_cache=64M
tmp_table_size=16M
bulk_insert_buffer_size=2M
connect_timeout=4
wait_timeout=10
query_cache_limit=1M
query_cache_size=16M
key_buffer_size=16M
skip-bdb
skip-innodb
skip-ndbcluster
query_cache_min_res_unit=4k
This does not help
I tried to set these values:
- I don't know where to put these directives in the my.cnf file. It either doesn't do anything (when added at the bottom of the file) or it turns mysql in error (when added in the [mysql] section
I suppose it should go under a particular section, but I don't know wich one
- I tried on my home Wamp server. I could get the values but skip-bdb, skip-innodb, skip-ndbcluster are not accepted.
Anyway, this does not change anything on the performance.
Actually, the performances are bad whatever is the configuration. Yslow gives the following for (1) opening a simple text page for edition - logged (2) viewing this simple page - anonymous:
Bluehost (Mutualized hosting) :
(1) 5,5/5,5/5,8/6,9
(2) 2/1,5/2/1,6/1,5
OVH (Real Private Server/1,2GHz 512K RAM/iSCSI) :
(1) 4,37/4,2/4,6/4,3"
(2) 1/0,9/0,9/0,9
Wamp home server (PIII 1GHz / 636KRam:
(1) 5,9/4,8/4,6/4,7
(2) 1,7/1,8/1,5/1,5
JV
try finding one of these for
try finding one of these for windows. Then you can rule out the MySQL
http://www.howtogeek.com/howto/linux/using-a-mysql-performance-tuning-an...
by the way the recommedation I made above were just some values to play with. I didn't mean to use them. Each DB has different requirements which is why this link should help you sort out the values pasted above based on your hardware, software and usage requirements.
That should be something else
I am affraid something else should be wrong.
The database is still < 3M, single connection: the most terrible, inappropriate setting should make it.
Results are basically the same on 3 totally different plateforms (local WAMP, shared Linux hosting and dedicated Linux server)
Whatever I tried to adjust does not change anything.
I am not confortable running these kind of tools.
What else could make it so bad ?
JV
Install the Devel module
Install the Devel module and quantify how many queries and how long they take to execute. It'll point out really slow queries for you.
Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
Mutualized and RPS are not suitable for Drupal
I finally tried this famous devel module.
I loaded this simple page, http://www.controlchaingroup.com/?q=node/508, logged in as admin on the dedicated server
I tried with Mysql Query_cache_size = 0 and 100 Mb
With cache size = 100Mb, I get different results, for example:
560 queries in 710.95 ms / total time 1860.69 ms
519 queries in 363.49 ms / total time 1410.97 ms
With cache size = 0, In get stable results
518 queries in 579.33 ms / total time 1647.64 ms
In all cases, the memory usage is the same:
"Memory used at: devel_init()=1.24 MB, devel_shutdown()=19.63 MB"
When logged out, I cannot get this info, but the detail summary indicates the following:
Memory: 14.50 MB
ms: 569
queries: 103
query ms: 121
Conclusion: DRUPAL is a database killer: the best database performance is required for acceptable operation.
I found the final answer
- the shared hosting (Bluehost) performs much better the short queries - shortest time is 0.1 ms vs 0,22 ms
- the RPS server (dedicated CPU+iSCSI shared networked drive) is much better for heavy queries
- In average, I get similar results.
- both solutions are not adequat for Drupal: I have to go for VPS or dedicated server
JV
Glad you figured everything
Glad you figured everything out, and I hope that things speed up and become more reliable for you.
As per usual with these posts, it is often determined (as mentioned multiple times) that drupal is a hog and works best on vps or dedicated servers. Although this isn't what we want to hear, it is unfortunately the truth. Drupal is very extensive software and it's memory and DB usage are higher then many other similar softwares and as versions increase the requirements rise as well. Unfortunately the common mis-conception is free software should run on almost free services. If Drupal cost $1000.00 then nobody would ever question why it doesn't run on sub $10 hosts.
Also the fact that people expect newer versions to run FASTER then previous versions doesn't help matters, but this never holds true either. Otherwise we'd be running Vista on Pentium 3's... As the software becomes more robust, it requires more robust hardware. When we're lucky hardware advances faster then the software so it "appears" to be faster. Unfortunately web servers are not upgraded as frequent as technology advances (unlike vps or dedicated servers) for financial reasons and we are left at the mercy of the hosts OLD hardware.
I can make a good guess that D7 will be slower then D6 as people want CCK + Views + Panels all in core... yet expect it to work just as fast or faster then the current core, and they will for surely run it on the same host they are running D6 on, which is the same host that ran D5. Of course that hardware hasn't been upgraded, so performance will suffer.
If you've moved to a VPS or dedicated server you will for surely see the true power of drupal using things like the boost module, memcache, apc and similar software. Also a good suggestion is find out what queries are taking the longest and index those tables, this will speed things up tremendously. I indexed my node Titles + NIDs because my autocompletes were taking upto 10seconds to complete. Now they take less then 1.
Check 2bits.com for optimization articles, they have suggestions, work arounds and benchmarks, all very useful.