… (0.02 sec) Records: 0Â Duplicates: 0Â Warnings: 0 mysql> SHOW CREATE TABLE `t1`\G *************************** 1. row *************************** Table: t1 …text to mediumtext. This approach can result in modified data types and silent data truncation, which makes it unacceptable for our purposes. …
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
… active transaction) – this is also I used DELETE instead of TRUNCATE to clean out the table. In the applications which are… having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children allowed….01 sec) mysql> create table rep_new like rep_maint; Query OK, 0 rows affected (0.00 sec) mysql> load data infile ‘/tmp…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’410680831′ ‘Com_stmt_reset’, ’0′ ‘Com_stmt_send_long_data‘, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, ’102′ ‘Com_update’, ’15146253′ ‘Com… 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/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…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… as floating-point numerics to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf… prior releases of MySQL, when writing slow query information to the log table, query times and lock times are truncated to to… Data,Close stmt,Reset stmt,Set option,Fetch,Daemon,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… you have a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance… large deadlock dump may easily exhaust the limit. MySQL in such situation truncates the output so it fits the required size and… full status output into innodb_status.
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… given object information now you do not only fetch the data but also update the view counter. For smaller single system… you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to… – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can be used to…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.18, including all the bug …Import was improved not to hold the InnoDB data dictionary mutex for the full duration of … Bug fixed: #878022 (Laurynas Biveinis) An output buffer truncation check in Response Time Distribution was fixed. Bug…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
… merge table auto_increment values are by truncating the table we just inserted data to: mysql> truncate table a2; ERROR 1105 (HY000): MyISAM table ‘a2′ is in use (most likely by a MERGE table). Try FLUSH TABLES. mysql> flush tables; Query OK, 0 rows affected (0.01 sec) mysql> truncate table a2; Query OK, 0 rows affected (0.00 sec) mysql…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… includes a MySQL slave. After the above setup completes, I am going to change data on the slave by truncating t1. After truncation: select… read_only = true on your MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL 5.1 default binary logging format changed back to STATEMENT in MySQL 5.1…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… other thread, the data file(s) removal by the storage engine and of course in the end MySQL has to destroy the… alternative approaches to trick MySQL into removing smaller files with DROP TABLE to minimize the effect, such as: TRUNCATE TABLE large_table…) A better solution through MySQL internals could be to simulate the table drop by renaming the corresponding data file or files and…
