70,531 reputation
1170161
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 10 months
seen 5 mins ago

One of JEHOVAH's Witnesses (TV)

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

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


2d
reviewed Close Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
2d
comment which mysql version to use - 5.1 or 5.5?
@Pacerier please keep in mind that I wrote this answer on January 4, 2013. I wrote this answer comparing 5.1 to 5.5. If you look at the question's very first comment, someone commented that 5.6 was not GA. Therefore, the latest 5.5 was stable on January 4, 2013. Today, that would be MySQL 5.6.22.
2d
comment which mysql version to use - 5.1 or 5.5?
@Pacerier yes the most recent GA version. For MySQL 5.6, use 5.6.21 and higher. For MySQL 5.5, 5.5.40 and higher.
2d
reviewed Approve Is MySql's LAST_INSERT_ID() function guaranteed to be correct?
2d
reviewed No Action Needed Results for every hour of the day even data if not present
2d
comment After mysql server restarts I cannot see my own database
If everything is normal again, please mark my answer accepted by clicking on the checkmark on my answer.
2d
comment After mysql server restarts I cannot see my own database
You can log in to mysql normally ???
2d
reviewed Close How to Shift a column up in a ring buffer?
2d
reviewed Close Backup Database Task - What's the number at the end of the filename?
2d
reviewed Close A way to clear/restart virtual memory creep automatically?
2d
comment After mysql server restarts I cannot see my own database
Run the following: service mysql restart --skip-grant-tables. You can login to mysql without a password. Please do that right now
2d
answered Is it possible: MySQL semisync and async replication on same master-slave pair?
Dec
17
reviewed No Action Needed JDBC pooling Oracle driver Socket read timed out
Dec
17
revised What does “as anonymous on” means in mysql's general log?
added 1850 characters in body
Dec
17
reviewed Close What could be resons for slow performing application
Dec
17
revised xenforo vulnerability, limit max open connections by ip address
added 219 characters in body
Dec
17
answered xenforo vulnerability, limit max open connections by ip address
Dec
17
comment What does “as anonymous on” means in mysql's general log?
Have I answered the question ?
Dec
17
reviewed No Action Needed Deploying Grails app to iPlanet server
Dec
17
reviewed No Action Needed What is the purpose of having a table NOT LOGGED INITIALLY