… all up front in one call. And what about the query cache and the table cache and the size needed for each thread (thread stack, etc)? Those take memory too. The query cache can use… setting up a my.cnf for a server, I usually calculate the Big Ones like the buffer pool, query cache etc; leave some…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a …cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size… have to do this check in the application. Just my experience. I know some…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql… after in X days. long_query_time = 2 thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… it desirable not to be too big. In practice we tend to see query cache sizes that are far too big more than… out because we don’t do it in the server defaults but in the default my.cnf file that we ship. It’s also…://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based on max_connections, just…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql… after in X days. long_query_time = 2 thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL Community …cc patching file sql/sql_cache.cc patching file sql/sql… -fstack-protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘CXX=gcc’…If you don’t specify it in my.cnf file, the remaining part of…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads…and the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file_size=1900M …file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user-specific options. # # In…_timeout=300 thread_cache = 40 max_connections=500 query_cache_size = 2000M # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 8 …
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… percona cluster in vm, if in file /etc/my.cnf,i add …my.cnf [mysqld] wsrep_provider=/usr/lib/libgalera_smm.so user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave_threads…size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = …100 table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log…
