Hi,
Your INSEERquery status is Copying to tmp table,
this means fetching rows which has to be inserted is slow.
You should tune SELECT statement in your insert query.
Adding indexes and/or simplifying query and/or .. so on.
```
---TRANSACTION 31D6D74, ACTIVE 27107 sec
mysql tables in use 8,
Hi,
Your query have to access all rows in `myTable`, thus MySQL optimizer
guesses reading sequentially is faster than working through an
index.
http://dev.mysql.com/doc/refman/5.6/en/mysql-indexes.html
The case of not using index,
* Reading whole myTable.MYD sequentially
* Sorting 443k rows
Hi Stephan,
I've already tried syslog but it works fine in my environment.
$ /usr/mysql/5.7.6/bin/mysql --syslog -h 192.168.198.214 -u yoku
mysql show databases;
Mar 13 11:27:57 dev-personal-04 MysqlClient: SYSTEM_USER:'ttanaka',
MYSQL_USER:'yoku', CONNECTION_ID:9, DB_SERVER:'192.168.198.214',
Hi,
Christophe has already told,
The used MySQL version is 5.5.40 from Debian Wheezy package.
Maybe you missed *mysql command-line client's --local-infile option*
$ bin/mysql
mysql SELECT @@version;
++
| @@version |
++
| 5.5.40-log |
++
1 row in set
Hello,
If you use any *NOT InnoDB* storage engine, you're right.
mysqldump with --single-transaction doesn't have any consistent as you say.
If you use InnoDB all databases and tables, your dumping process is
protected by transaction isolation level REPEATABLE-READ.
* storage engine, say MyISAM, will this dump be
of any useful?
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Consultant and Database Security
Specialist
On Tue, Oct 7, 2014 at 11:55 AM, yoku ts. yoku0...@gmail.com wrote:
Hello,
If you use any *NOT InnoDB* storage
Would you try this?
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
SET @a = 0;
UPDATE
documents SET sort_id = (@a := @a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
2014-07-14 11:42
Hi,
Would you try STRAIGHT_JOIN?
mysql56 ALTER TABLE masik DROP KEY idx_test, ADD KEY idx_test(szam, id);
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql56 EXPLAIN SELECT e.id FROM masik m STRAIGHT_JOIN egyik e ON e.id=
m.id WHERE e.duma= 'aaa' ORDER BY m.szam
Hello,
I can see MyISAM stores BLOB column as same space as other data type
column,
but InnoDB doesn't. (If you mean same .ibd file it's true)
http://dev.mysql.com/doc/refman/5.6/en/innodb-row-format-overview.html
ROW_FORMAT= Compact holds first 768 bytes of BLOB column,
ROW_FORMAT= Dynamic or
Hello,
mysqladmin and mysql command-line client is included in MySQL-client
package.
mysql_secure_installation is included in MySQL-server but it's a perl
script which calls mysql command-line client internally.
Thus, you should install MySQL-client-*.rpm and try again.
Regards,
2014-05-04
Hello,
--syslog is option of mysql command line client and it works in my
environment.
Do you put [mysql] section in your my.cnf?
Regards,
yoku
2013/3/28 RafaĆ Radecki radecki.ra...@gmail.com:
Hi All.
I have a production setup of four databases connected with
replication. I would like to
Hello,
It's because of binlog_checksum = crc32 setted default at 5.6.5.
If you use 5.6's master and 5.5(or earlier)'s slave, you need to set
binlog_checksum = none on 5.6.
2013/2/12 Adarsh Sharma eddy.ada...@gmail.com:
Hi,
I have a Multi Master Mysql setup between two mysql servers running
Hi
Because of that, those queries don't use index.
log-queries-not-using-indexes works even if query time less than
long-query-time.
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_log-queries-not-using-indexes
regards,
yoku
2012/9/1 Adarsh Sharma
Hello,
add index to expression1_id and expression2_id on expression_expression.
it doesn't use index,following,
WHERE
ee2.expression1_id = $ID
OR
ee1.expression2_id = $ID
regards,
2012/7/3 brian mysql-l...@logi.ca
I have a table that joins on itself through a second
14 matches
Mail list logo