63,758 reputation
1064148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 4 hours ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


Jan
4
revised How to run a cold backup with Linux/tar without shutting down MySQL slave?
added 10 characters in body
Jan
4
reviewed Approve suggested edit on Determining the optimal Column Widths from a .csv File
Jan
4
reviewed Edit suggested edit on How to run a cold backup with Linux/tar without shutting down MySQL slave?
Jan
4
revised How to run a cold backup with Linux/tar without shutting down MySQL slave?
improved tag
Jan
4
comment How can I find out the last time a MySQL table was analyzed?
My conjecture: The table information_schema.STATISTICS could possibly be more stabilized by ` innodb_stats_on_metadata`.
Jan
4
reviewed Edit suggested edit on mysql server is not sending result set back after query execution to client and staying in sending data state
Jan
4
revised mysql server is not sending result set back after query execution to client and staying in sending data state
improved tag
Jan
4
reviewed Close How to create unique index for month and year column?
Jan
4
revised How can I find out the last time a MySQL table was analyzed?
added 902 characters in body
Jan
4
reviewed Reject suggested edit on Can I normalize my experimental data table further?
Jan
4
answered How can I find out the last time a MySQL table was analyzed?
Jan
4
revised How can I set a default session sql_mode for a given user?
added 24 characters in body; edited tags
Jan
4
answered mysqlbackup mysql enterprise utility issue
Jan
4
revised mysqlbackup mysql enterprise utility issue
added 33 characters in body; edited tags
Jan
4
revised which mysql version to use - 5.1 or 5.5?
added 1447 characters in body
Jan
4
answered which mysql version to use - 5.1 or 5.5?
Jan
4
comment How do you remove fragmentation from InnoDB tables?
@CrackerJack9 I have an additional post discussing the additional activity around ibdata1: dba.stackexchange.com/a/23367/877
Jan
4
comment How do you remove fragmentation from InnoDB tables?
@CrackerJack9 ibdata1 is incredibly superbusy because of what goes into it: 1) Double write buffer info, 2) Insert Buffer for Secondary Indexes, 3) Data dictionary, 4) Rollback Segments, 5) Undo Tablespace. Please goto scribd.com/doc/31337494/XtraDB-InnoDB-internals-in-drawing for a pictorial representation of these things. Even with the removal of data and index pages for InnoDB tables, ibdata1 can still grow significantly in a high transactional environment.
Jan
4
revised Is there a MySQL engine or trick to avoid writing so many temp tables to disk?
added 1180 characters in body
Jan
4
answered Is there a MySQL engine or trick to avoid writing so many temp tables to disk?