…a very basic audit, whose scope I‘ll keep within just a MySQL…config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL is probably a…I make. The next thing to do is grab ‘mysqladmin variables’ and put it in the text file. I don’t spend a…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…how Shard-Query will perform on each database. To do the size comparison, I used the du utility: InnoDB file… */; CREATE TABLE `dim_…mysql> use ontime1; Database changed mysql…a script provided to generate the shards.ini file for testing an cluster of 1 to 20 nodes. cd shard-query #generate a config…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
…how the script performs this task. #wait until the old instance is terminated it takes a…a search and replace operation in the local ha.cf file…config MYSQL…creating the new instance” else done=”false” while [ $done == "false" ] do…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 Comments
… option 1,189 1,84 0,03% I have a gallery with select query with ORDER BY, …4,483 M Created_tmp_disk_tables 5,270 Created_tmp_tables 5,274 Created_tmp_files 37 k Key…mysql applied, and my.cnf are not modified. Why? Where are written this configs? – do i switch table from MyISAM to InnoDB (if yes, how…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 16 Comments
… tables created in memory where possible, do to … to get attention. I understand it could …how this issue was fixed (patch pending): ChangeSet@1.2311, 2006-11-16 04:11:16+03:00, ted@ted.mysql…do. tmp_table_size retains to (give a hint about a… documented in the manual, config files, tons of books and …
