… on server and Com_stmt_send_long_data to see whenever sending long data feature is used as …Server you can do better as you can query temporary tables too: mysql> select sum(data_length+index_length) … as good tools to detect memory leaks like valgrind are too slow to run in production. So the …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…production. The pmp-check-mysql-deadlocks plugin can help you detect such problems, …mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB is getting stuck, has long-running…a variable such as Queries and alert on a queries-per-second threshold. (…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to MySQL and run FLUSH TABLES WITH READ LOCK Note – this command may take a while to complete if you have long running queries. The… complete, even selects. So be careful if you have any long running queries. If you’re using only Innodb tables and do not… resently seen is: snapshot: Required device-mapper target(s) not detected in your kernel – This means snapshot module is not loaded…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… data for each of them using mysql_stmt_send_long_data call – Server buffers such data … variables for unprivileged user which allows to run queries with uncontrolled resource usage. Host Block You … using MySQL lightly and not trying to crash/overtake it. Others constantly have to detect and restrict…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…final group-by reduction is run over the coordination node,…your database administrator. As long as all of the…, but right now only MySQL storage nodes are supported…. access layer. Shard-Query can provide query execution plans based…#74082863` * IN list optimization enabled * Detected an IN list with 2…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…long ago Solid released solidDB for MySQL Beta 3 so I decided now is … detection: Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> update test2 set names=’mysql‘ where id = 1; Query…; try restarting transaction So we can’t run SysBench benchmark with current version. Hopefully next …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…running spin locks and doing unneeded context switches. The next section is about deadlock errors: ———————— LATEST DETECTED…mysql tables in use 1, locked 0 MySQL thread id 8079, query…from query executions are executed by threads running queries… were not accessed long time, flush list …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… users trying it out. In the long run, this will determine to what extent…deleted because the MVCC system can detect that a row has been changed …MySQL to make the engine work. This means that PBXT runs with the standard MySQL…function returns quickly, but the first queries that access PBXT tables may …
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… specified. It takes a good look at queries actually being run and data selectivity to come up with…MySQL still will not be able to use it as Optimizer is not smart enough yet to detect such cases: mysql…position (as long as it is indexed) Force index if needed In some cases MySQL Optimizer may prefer…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…query(“Select email from user where name=%s”,$name) – > wrapper will detect query…(s) as long as you …MySQL you might be > better of using several queries…run EXPLAIN for your queries, especially > if you see them in slow query log. If you have trouble understanding > EXPLAIN or optimizing your queries…
