…let us load with many transactions instead of one huge transaction. The smaller file is 4.1GB and …million rows each. (InnoDB internally does operations such as ALTER TABLE in 10k row chunks, by the way; I …other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… latest versions) adding new ndbd nodes and of course doing alter tables. For alter tables, only replication can reduce the downtime. I agree that… handling insanely huge loads. 2.8 What the point here, do you use SSL between your application servers and your MySQL servers…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
… needed as traffic growths as well as makes ALTER TABLE much less painful. The other technique which I … use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with… data, for example searching Britney Divorce will show huge spike then news came out and quick calm…
