Not the answer you need?
Register and ask your own question!

Percona Server sample configuration

devi@visolve.com[email protected] EntrantInactive User Role Beginner
Hi,

I've just installed percona and what should be the configuration in .cnf. I just want to compare the performance (just a simple login page) of the application against oracle mysql 5.5.. Is there any sample configurations that i can use to see the performance.

Thanks
Devi

Comments

  • larishostinglarishosting Entrant Inactive User Role Beginner
    You can use the default one you had for mysql for testing. You can also generate a new one tools.percona.com
  • oldschoololdschool Entrant Current User Role Beginner
    Here mine:

    quick
    [mysql]
    no-auto-rehash
    [myisamchk]
    key_buffer=256M
    key_buffer_size=32M
    write_buffer=2M
    read_buffer=2M
    sort_buffer_size=256M
    [client]
    socket="/mysql/mysql.sock"
    [mysqld]
    # INNODB #
    innodb_flush_method = O_DIRECT
    innodb_log_files_in_group = 2
    innodb_log_file_size = 256M
    innodb_flush_log_at_trx_commit = 1
    innodb_file_per_table = 1
    innodb_buffer_pool_size = 4G

    wait_timeout = 600 seconds

    # CACHES AND LIMITS #
    tmp_table_size = 32M
    max_heap_table_size = 32M
    query_cache_type = 0
    query_cache_size = 32M
    max_connections = 100
    thread_cache_size = 50
    open_files_limit = 65535
    table_definition_cache = 4096
    table_open_cache = 10240

    # LOGGING #
    log_error = /mysql/mysql-error.log
    log_queries_not_using_indexes = 1
    slow_query_log = 1
    slow_query_log_file = /mysql/mysql-slow.log

    loose_handlersocket_port = 9998
    # the port number to bind to for read requests
    loose_handlersocket_port_wr = 9999
    # the port number to bind to for write requests
    loose_handlersocket_threads = 16
    # the number of worker threads for read requests
    loose_handlersocket_threads_wr = 1
    # the number of worker threads for write requests
    # to allow handlersocket to accept many concurrent
    # connections, make open_files_limit as large as
    # possible.

    #join_buffer_size=12M
    #thread_concurrency=4
    #query_cache_limit=256M
    #connect_timeout=1000
    #key_buffer=384M
    #table_cache=4096
    #max_user_connections=50
    #local-infile=0
    #server-id=14
    #wait_timeout=1000
    #read_rnd_buffer_size=16M
    #read_buffer_size=2M
    #myisam_sort_buffer_size=64M
    #max_allowed_packet=32M
    #socket="/mysql/mysql.sock"
    #skip-external-locking
    #sort_buffer_size=2M
    #datadir="/mysql"
    #[mysqlhotcopy]
    #interactive-timeout
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.