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

packaging: Backport bower support utilities...

packaging: Backport bower support utilities To support nixos-16.03 the utilities to build bower components are backported inside of this PR. Once we switch to the new stable branch, we should be able to drop these pieces again.

marcink - - Load All Authors

File last commit:

r1:854a839a default


                r725:57489056

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