Tom Geee

57 reputation

bio	website
	location
	age
visits	member for	6 months
	seen	Feb 10 at 5:42
stats	profile views	4

	57 reputation	bio	website		visits	member for	6 months
4 badges		location			seen	Feb 10 at 5:42

summary answers questions tags badges favorites bounties reputation activity

27 Actions

suggestions reviews revisions comments badges posts accepts all

Jan 23	asked	consequences of using “innodb_flush_method = O_DIRECT” without having a battery backed write cache? or on a KVM guest?
Jan 19	revised	MySQL 5.5 - determining correct write[read]_io_threads on high-end system? fixed qps . too many 0's.
Jan 19	comment	MySQL 5.5 - determining correct write[read]_io_threads on high-end system? Thanks some good info there. So how do I know whether I should use write_io_threads of 4 or 32 or 64 ? What determines (hardware wise I would guess?)this variable besides the obvious benchmarking trial and error? Could I totally bog down the production DB server with an incorrect setting?
Jan 18	accepted	MySQL 5.5 - Innodb - innodb_log_file_size higher than 4GB combined?
Jan 17	asked	MySQL 5.5 - determining correct write[read]_io_threads on high-end system?
Jan 17	comment	MySQL 5.5 - Innodb - innodb_log_file_size higher than 4GB combined? sorry I meant to say "innodb_log_file_size" not "Innodb_os_log_written" in the above comment.
Jan 17	comment	MySQL 5.5 - Innodb - innodb_log_file_size higher than 4GB combined? Thanks, what is the downside of having Innodb_os_log_written too low for the load - less than 1 hours worth?
Jan 17	asked	MySQL 5.5 - Innodb - innodb_log_file_size higher than 4GB combined?
Jan 17	accepted	Mysql 5.5: Optimizing all tables with mysqlcheck - is it useful to run the -check option along with -optimize?
Jan 16	revised	Mysql 5.5: Optimizing all tables with mysqlcheck - is it useful to run the -check option along with -optimize? added 3 characters in body
Jan 15	revised	Mysql 5.5: Optimizing all tables with mysqlcheck - is it useful to run the -check option along with -optimize? edited title
Jan 15	asked	Mysql 5.5: Optimizing all tables with mysqlcheck - is it useful to run the -check option along with -optimize?
Nov 30	accepted	InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”
Nov 30	awarded	Supporter
Nov 29	asked	InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”
Nov 29	awarded	Scholar
Nov 29	accepted	Innodb, MySQL 5.5.28 - Segmentation Signal 11 faults, on high load. .. my.cnf file included
Nov 26	revised	Innodb, MySQL 5.5.28 - Segmentation Signal 11 faults, on high load. .. my.cnf file included edited body
Nov 23	revised	MySQL 5.5 : (InnoDB) - Manually edited an .ibd file to test recovery, now entire MySQL installation is broken! added 99 characters in body
Nov 23	comment	Innodb, MySQL 5.5.28 - Segmentation Signal 11 faults, on high load. .. my.cnf file included Thanks for the help. If the problem continues - I'll be debating between doing a memory check (a good few hours of downtime, IF the host agree's to do this for us) - or a complete dump (6-10 hours of downtime), then probably compile a 'generic" mysql version.