…but here’s mine: cat <<'GO' | mysql –raw –skip-column-names –quick –silent –no-auto-rehash –…’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I … running reports on them? Register to join me February 25-28, 9AM-11AM Pacific…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…show_collations’, ’176788′ ‘Com_show_column_types’, ’0′ ‘Com_…’, ‘NULL’ ‘Select_full_join‘, ’0′ ‘Select_full_range_join‘, ’0′ ‘Select_…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/slow… alot of text. Could someone …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…Q17: How InnoBD handles blobs/text fields (needs more info) According… seek on disk which slows down throughput. If we ….cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv… be used if the columns are the first columns in an index… ORDER and ORDERLINE tables are joined to form a single table…
Post: Missing Data - rows used to generate result set
July 20, 2008 By 15 Comments
…example as another slow query log record) is the number of rows which MySQL used to generate …MYSQL%” you may instead use Full Text Search indexes. If you have WHERE ID%100=0 you can have extra column… basic “single level” queries keeping in account JOINs, GROUP BY, LIMIT would already be helpful …
