465 reputation
211
bio website noneatthemoment.de
location Germany
age 33
visits member for 2 years, 6 months
seen 5 mins ago

6h
comment How to change table with innodb/myisam engine to federated
@Michael-sqlbot Interesting, thanks for your comment.
8h
answered How to group by on two fields and count
12h
revised How to change table with innodb/myisam engine to federated
improved english
12h
comment How to change table with innodb/myisam engine to federated
Don't think so, haven't investigated it much. For writing it may not be so serious.
13h
comment How to change table with innodb/myisam engine to federated
I haven't used the federated engine much, cause from my experience it's painfully slow. But maybe just for my use case.
13h
comment How to change table with innodb/myisam engine to federated
Oh, yes, that's actually a fancy trick. But you have to create the table the other way round than I described in my answer. The federated table on the localhost, and the real table on the remote host, where you want to write data to. Nice.
13h
suggested suggested edit on How to change table with innodb/myisam engine to federated
13h
comment How to change table with innodb/myisam engine to federated
@GeoVIP No, you can't. The concept behind federated is still not clear, isn't it? The federated engine is like a link to another table. You select something from the local federated table, the data comes from the remote whatever-engine-table. You can't use triggers to write data to a remote server.
13h
answered How to change table with innodb/myisam engine to federated
13h
comment How to change table with innodb/myisam engine to federated
Do you want to do this for all tables in a database? If yes, what you actually want is called replication.
13h
comment How to change table with innodb/myisam engine to federated
No offense in asking this, but do you actually know what the federated engine is? I recommend you read the MySQL manual about it. You don't convert a table to federated, you just create it.
13h
comment Migrate database from server old to new server with centos
Feel free to do so. Do you have any questions about it?
1d
awarded  Yearling
1d
comment Large MySQL table, inserts with primary key check
Yes it is better, you just save yourself a select statement on a 12 million rows table. Bulk inserts are much better yes. Not sure though, if we're talking about the same. If you're talking about LOAD DATA INFILE.., it too has the possibility to specify IGNORE. If you mean to specify multiple rows in one insert statement, yes, that's better. After every insert statement the indexes on your table get rebuilt. If you insert multiple rows in one statement, the rebuilding index step has to be done only once. That's significant for good performance.
1d
answered Large MySQL table, inserts with primary key check
1d
answered Workaround to avoid read-only table locking during execution of MySql OPTIMIZE command
1d
comment Query where there are only two rows with specific data
Thank you very much :)
1d
revised How to allow remote connections to mysql from specific IPs only?
code formatting and removing signature
1d
suggested suggested edit on How to allow remote connections to mysql from specific IPs only?
1d
answered Query where there are only two rows with specific data