573 reputation
310
bio website myxplain.net
location Paris, France
age 24
visits member for 1 year, 3 months
seen 22 hours ago

Apr
8
asked Why MongoDB starts to split before 64MB
Mar
31
revised MySQL database freezing after 'use'
edited body
Mar
30
answered MySQL database freezing after 'use'
Jan
31
comment How to set up multiple fields as primary key in MySQL?
No, no it was just for the example, you talked about "recordmonth" field so i thought it was DATE field but don't pay attention :)
Jan
28
revised Copy On Write Transparent database for MySQL
added 25 characters in body
Jan
28
answered Copy On Write Transparent database for MySQL
Jan
26
answered How to set up multiple fields as primary key in MySQL?
Jan
24
comment Is it possible to index a computed column used in ORDER BY?
mysqlperformanceblog.com/2006/09/01/…
Jan
24
answered Is it possible to index a computed column used in ORDER BY?
Jan
24
comment Is it possible to index a computed column used in ORDER BY?
HI, can you paste the two SHOW CREATE TABLE commands in the post?
Jan
23
answered How to determine MySQL queries per day?
Dec
20
comment Massive MySQL delete from CSV file
He talks about millions rows, in both solution he will locks his table for a while...
Dec
20
awarded  Yearling
Dec
20
comment Massive MySQL delete from CSV file
Note than the important is that do not overload your servers or block your slaves. If you run well designed DELETEs (with WHERE on PK and LIMIT by 1) you will probably not have load issue, but if you work with high volumetry i'm not shocking than this traetment will take "hours", you can split it by lot of few millions DELETEs.
Dec
20
revised Massive MySQL delete from CSV file
added 82 characters in body
Dec
20
comment Massive MySQL delete from CSV file
You're right :) usually my IDs are in MySQL so I don't import it. You don't have an other choice except TRUNCATE table (more effecient than DELETE without WHERE) and reinsert missing IDs but it depends of the percentage of datas you want to remove from your table
Dec
20
revised Massive MySQL delete from CSV file
added 110 characters in body
Dec
20
answered Massive MySQL delete from CSV file
Dec
19
comment Connection refused when trying to set up replication
You can add the option skip-slave-start on your my.cnf instead of start with option explicitly
Dec
19
comment Connection refused when trying to set up replication
F... the "mysql" database is MyISAM so you can copy the folder "mysql" from master to slave to have your users on slave