… symbol information to be present, so that it can print stack traces that show where memory is consumed. Without debug symbols… (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | | | ->10.10% (7,135,744B) 0x3ECF60677B: start_thread (in /lib64/libpthread… (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | | | ->27.73% (114,084,096B) 0x3ECF60677B: start_thread (in /lib64/libpthread…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… and the table cache and the size needed for each thread (thread stack, etc)? Those take memory too. The query cache can use…_allowed_packet bigger and ran the following on my laptop: mysql> set @a := repeat(‘a’, 1024 * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
… may have incorrectly analyzed which thread caused the crash. Inspecting the error log (which also contains a stack trace) may also help in such cases. So… maybe you were testing a C program with three threads executing… compilation time) First we inspect the mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql_execute_command (thd=thd@entry…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…=/usr/lib/libgalera_smm.so user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave_threads=2 wsrep_cluster_name=trimethylxanthine… see no messages after this, something went terribly wrong… stack_bottom = 0 thread_stack 0×30000 /usr/sbin/mysqld(my_print_stacktrace+0×33)[0×8415893…
Comment: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
… see no messages after this, something went terribly wrong… stack_bottom = 0x7fd1c1b6f0b8 thread_stack 0×40000 /usr/sbin/mysqld(my_print_stacktrace+0x2e… pointer Connection ID (thread ID): 495168 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains…
Comment: Impact of the number of idle connections in MySQL
December 20, 2010 By 21 Comments
… as client is idle. Thread-per-connection wastes system resources (at least a thread plus virtual memory for threads stack). And if there are many very many active connections, number of threads == number of… aimed to fix . But normal MySQL does not have problems with select()/poll() scalability, because MySQL server does not use multiplexing at…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… : 40 bits physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2…_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16 join_buffer…_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size=64M transaction_isolation…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… is mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql…-errors = 1062 back_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… command line mysql client returns error 34, Can’t create a new thread Also issuing a /usr/local/etc/rc.d/mysql-server…-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait… = 16M key_buffer_size = 32M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 64 query_cache_limit = 0 #query_cache_size…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…benchwork/benchmarks/sysbench/bin/sysbench –num-threads 1 –max-requests 0 –max-time 300 –thread-stack-size 32K –init-rng on …auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-…
