62,978 reputation
1062147
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 21 mins 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


Aug
14
answered MySQL After Update Trigger apparently not running
Aug
14
revised MySQL After Update Trigger apparently not running
edited tags
Aug
14
reviewed Reviewed SOLVED:MySql: how do I insert a large data set into existing rows automatically?
Aug
14
revised Can I change max_allowed_packet for a MySQL database, but not others in the same instance?
added 294 characters in body
Aug
14
answered Can I change max_allowed_packet for a MySQL database, but not others in the same instance?
Aug
14
comment What is real job of a MySQL DBA?
I would recommend the following posts : 1) dba.stackexchange.com/a/19758/877, 2) dba.stackexchange.com/a/2913/877, 3) dba.stackexchange.com/a/9070/877, 4) dba.stackexchange.com/a/6260/877. Please read all the posts, not just my posts. There are other great answers that can gear you for having the right attitude to be a DBA. In reality, it's not all about a specific database. People skills and communications skills also play a major part in the life of a DBA.
Aug
14
comment What is real job of a MySQL DBA?
Over the years, I have seen job postings for MySQL DBA with many other RDBMSs. One example: One job was advertised as MySQL DBA. When I interviewed, the job included Oracle, SQL Server, Vertica, MongoDB. (Some of you out there might be saying "Is that all ?" If so, more power to you !!!) MySQL has always been dreadfully underrated for years. This is why there is a major shortage of MySQL DBAs worldwide. No two companies view a MySQL DBA the same way.
Aug
14
answered mysql - is it possible to create a partition expression based on two keys / indexes?
Aug
14
comment MySQL 5.6.17 running out of memory when opening table with many partitions
Ever considered installing 1TB of RAM ??? HA HA
Aug
14
comment MySQL 5.6.17 running out of memory when opening table with many partitions
+1 for finding this out yourself. CAVEAT: You should experiment with MyISAM for table partitioning and see if you have the same issues. For my former employer, I have a daily MyISAM table with 4179 partitions, holding past data and empty partitions for future days. Never had an issue. Of course, I raised the machine's ULIMIT to 102400. I have a separate post on raising innodb_open_files, open_files_limit, and the OS file limit (dba.stackexchange.com/a/60194/877) BTW Welcome to the DBA StackExchange !!!
Aug
14
answered MySQL Replication - Master Master - Single Master write
Aug
13
reviewed No Action Needed Conditional value lists in MySQL
Aug
13
reviewed Leave Closed is there any way to retrieve last error message
Aug
13
reviewed Close Is it a good idea to store image data URIs in a Mongo database?
Aug
13
reviewed Close SQL query to update columns in the same row
Aug
13
comment Restoring Mysql Table From ibdata1, ib_logfile0, ib_logfile1 (without frm)
Do you have backups of the .frm files ?
Aug
13
reviewed No Action Needed Can I install SQL Server Management Studio locally?
Aug
13
reviewed No Action Needed Check constraint references another column in same table
Aug
13
reviewed No Action Needed Text comparison select query needed that finds most whole word matches within larger string
Aug
12
revised Wordpress blog where pages are almost-always served from cache: SSD or more RAM?
added 46 characters in body