… (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok… use the following information to find out where mysqld died. If you see… invalid and cause the dump to abort. Query (0): is an invalid pointer …mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…of memory and there is very little load. I see that mysqld is using 10g of memory…out what MySQL…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…of 600 connections when every connection consumes X mb. If the answer to ‘b’ is 2mb then the total amount of memory…Aborted_clients’, ’267108′ ‘Aborted…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Comment: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…_size + sort_buffer_size)*max_threads = 9249947 K bytes of memory Hope …abort. Query (0x7fd1bccf90b8): is an invalid pointer Connection ID (thread ID): 495168 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out…
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_…read_buffer_size + sort_buffer_size)*max_threads = 329809 K bytes of memory Hope that’s …use the following information to find out where mysqld died. If you…] [0x8e8420] /lib/libc.so.6(abort+0×101)[0xb1a701] /usr/lib/libstdc…
Comment: Why MySQL could be slow with large tables ?
November 29, 2006 By 141 Comments
…extra_sort_file_size) or it could be just lack of optimization, if you’re having large (does not fit in memory) … 1.3G, 15.000.000 rows, 512MB memory one the box. MySQL 4.1.8 One could could call it …(128) as part of the schema. The load took some 3 hours before I aborted it finding out it was just …
