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, l
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
T
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',
D
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 (0
* NOT Innodb * 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. wrote:
>
> > H
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.
http://dev.mysql.com/doc/refm
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 G
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 15
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 :
> Hi All.
>
> I have a production setup of four databases connected with
> replication. I would like to log every comman
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 :
> Hi,
>
> I have a Multi Master Mysql setup between two mysql servers running 5.1.66-
> version. Bu
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 :
> Hi all,
>
> I am
hello,
`323030382d30322d3032' is hexadecimal expression of `2008-02-02'.
but i don't know why your MySQL returns a result in hexadecimal.
don't you have any idea about hexadecimal in your program?
yoku ts.
2012/8/1 Willy Mularto :
> Hi,
> I just tried this query &
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
> I have a table that joins on itself through a second table:
>
> table
15 matches
Mail list logo
