u/pc/rhodecode-enterprise-ce-fork-pc Files · docs/admin/tuning-increase-db-performance.rst

celery: Reorder celery imports to fix case where celery tasks were being...

celery: Reorder celery imports to fix case where celery tasks were being registered before celery config was setup. Added comments to make this clear so we don't chase this problem in the future until it is refactored

marcink - - Load All Authors

File last commit:

r1:854a839a default


                r628:4d980275

default

Download file

             tuning-increase-db-performance.rst
        
                    23 lines
            
             | 911 B
            
                | text/x-rst
            
             |
                RstLexer
            
             / docs / admin / tuning-increase-db-performance.rst
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        marcink
    
project: added all source files and assets

              r1
            
      .. _db-session-ref:

      Increase Database Performance

      -----------------------------

      To increase database performance switch to database-based user sessions.

      File-based sessions are only suitable for smaller setups. The most common

      issue being file limit errors which occur if there are lots of session files.

      Therefore, in a large scale deployment, to give better performance,

      scalability, and maintainability we recommend switching from file-based

      sessions to database-based user sessions.

      To switch to database-based user sessions uncomment the following section in

      your :file:`/home/{user}/.rccontrol/{instance-id}/rhodecode.ini` file.

      .. code-block:: ini

            # db session

            beaker.session.type = ext:database

            # adjust this property to include your database credentials

            beaker.session.sa.url = postgresql://postgres:<pass>@localhost/rhodecode

            beaker.session.table_name = db_session

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

marcink project: added all source files and assets	r1	.. _db-session-ref:

		Increase Database Performance
		-----------------------------

		To increase database performance switch to database-based user sessions.
		File-based sessions are only suitable for smaller setups. The most common
		issue being file limit errors which occur if there are lots of session files.
		Therefore, in a large scale deployment, to give better performance,
		scalability, and maintainability we recommend switching from file-based
		sessions to database-based user sessions.

		To switch to database-based user sessions uncomment the following section in
		your :file:`/home/{user}/.rccontrol/{instance-id}/rhodecode.ini` file.

		.. code-block:: ini

		# db session
		beaker.session.type = ext:database

		# adjust this property to include your database credentials
		beaker.session.sa.url = postgresql://postgres:<pass>@localhost/rhodecode
		beaker.session.table_name = db_session