title: Can Joomla handle Queries for Millions of Users in the jos_users table?
body: <p>I am almost done developing a large website.</p>
  
  <p>The only problem is i get MySQL gone away errors all the time...</p>
  
  <p>I posted another question here on <a href="https://stackoverflow.com/questions/10387706/how-resolve-this-error-loading-modulesmysql-server-has-gone-away-for-large-jooml">stackoverflow</a> but did not get my answer </p>
  
  <p>So my Question is is Joomla fit enough or right CMS solution for a large users ( 5 million users)?</p>
  
  <p>I have spent almost 5 months developing this... and now although i am on a Quad dedicated server (2 GB Ram) i feel that Joomla maybe perhaps not a right solution for this large database website..</p>
  
  <p>Edit : I just want to make this clear I am not talking about the traffic...its brand new site. I am talking about the number of rows in some tables </p>
  
  <p>Please advise </p>
  
  <p>MySQL Server info :</p>
  
  <pre><code>MySQL error log: /var/lib/mysql/eta.etalenthunt.com.err
  
  root@eta [~]# cat /etc/my.cnf
  [mysqld]
  safe-show-database
  open_files_limit = 5000
  tmp_table_size = 32M
  max_heap_table_size = 32M
  query_cache_limit=1M
  query_cache_size=100M ## 32MB for every 1GB of RAM
  query_cache_type=1
  max_connections=100
  collation_server=utf8_unicode_ci
  character_set_server=utf8
  delayed_insert_timeout=40
  interactive_timeout=30
  wait_timeout=60
  connect_timeout=60
  thread_cache_size=64
  key_buffer=32M ## 32MB for every 1GB of RAM
  join_buffer=1M
  max_connect_errors=20
  max_allowed_packet=16M
  table_cache=2048
  record_buffer=1M
  sort_buffer_size=3M ## 1MB for every 1GB of RAM
  read_buffer_size=3M ## 1MB for every 1GB of RAM
  read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
  thread_concurrency=8 ## Number of CPUs x 2
  myisam_sort_buffer_size=16M
  innodb_file_per_table=1
  innodb_buffer_pool_size=18M ## (&gt;= 18M)
  </code></pre>
  
  <p>i am running dedi server XEON QUAD 2 GB</p>