… Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server operations …in the manual which will help you identify the cause of the crash. 130528 09:53:56 mysqld_safe Number of processes…from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment …MySQL on the same files in the data directory, and refusing to shut down MySQL so that it is killed… and has to be power cycled. In addition, other processes can be runaways, too, such as …
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you…/var/lib/mysql (datadir) on my system (Ubuntu). You might be lucky and it might work in your…you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL…processing). Of course you will see these tables going away if you close connection. In…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… in MySQL design, thinking little about users isolations and resource quotas and interesting enough I have not seen significant changes in fresh our MySQL…. In my test I got OOM though it kept the box stalled for few minutes before that: Out of memory: Killed process 1081 (mysqld). automount invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 Out of memory: Killed process 1081 (mysqld…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero. It looks… type to the tables is “const” MySQL does not count it as access to two tables. In case of “real” access to… in the query: # Time: 120911 17:31:48 # User@Host: root[root] @ localhost [] # Thread_id: 65144 Schema: sbtest Last_errno: 0 Killed…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… slave, I just stopped the replication processes. This is safe to do even … break replication on the slave by killing the slave after event 98 executes …in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… instance) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW… to MySQL using xinetd redirect type of services. The update_xinetd.sh script just updates the xinetd and send a kill -HUP to the process. Another equally valid option would be to change the IP address in a php configuration…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…processing (and extra trip) involved. This in particular hurts log writes which are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…had. MySQL Also was very slow running some queries so we changed scripts a bit to kill … in particular those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL…only half of system CPU resources for query processing was not too bad, however with 16,32…
