www.webdeveloper.com
Results 1 to 3 of 3

Thread: How to Cache a MySQL DB & Questions

  1. #1
    Join Date
    Apr 2005
    Location
    Behind my DiGiCo SD7 Console
    Posts
    900

    How to Cache a MySQL DB & Questions

    Will caching a MySQL Database really speed up load time?

    How can I do this with CentOS5?
    Registered Linux User: #463250
    -----------------
    HELPFUL LINKS
    PHP - http://www.php.net
    Website Color Schemer - http://www.colorschemer.com/online.html

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,151
    Quote Originally Posted by comptech520 View Post
    Will caching a MySQL Database really speed up load time?
    For certain values of "really": maybe.
    How can I do this with CentOS5?
    One way (of many): PEAR::Cache_Lite
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Apr 2005
    Location
    Behind my DiGiCo SD7 Console
    Posts
    900
    If I add this to "my.cnf" file, will it hurt anything or dusrupt service?

    [mysqld]
    back_log = 75
    skip-innodb
    max_connections = 500
    key_buffer = 384M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1800
    thread_cache_size = 384
    wait_timeout = 7200
    connect_timeout = 10
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max_allowed_packet = 64M
    max_connect_errors = 1000
    read_rnd_buffer_size = 524288
    bulk_insert_buffer_size = 8M
    query_cache_limit = 4M
    query_cache_size =128M
    query_cache_type = 1
    query_prealloc_size = 65536
    query_alloc_block_size = 131072
    default-storage-engine = MyISAM

    [mysqld_safe]
    nice = -5
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
    Registered Linux User: #463250
    -----------------
    HELPFUL LINKS
    PHP - http://www.php.net
    Website Color Schemer - http://www.colorschemer.com/online.html

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles