68,888 reputation
1070160
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 9 months
seen 3 hours 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


1d
revised Backup & recovery strategies for Partitioned Database in Sybase ASE
added 1 character in body
1d
revised Build a three table join with a recusive table in the middle?
added 1 character in body
1d
revised MySQL Recursive query
edited title
1d
revised Remove ORA-01100:DATABASE ALREADY MOUNTED
added 1 character in body
1d
revised Managing constants changes to database
edited body
1d
revised Managing constants changes to database
added 2 characters in body
1d
revised Managing constants changes to database
edited body
1d
reviewed Approve suggested edit on How to connect to an Amazon PostgreSQL database using SSL
1d
reviewed No Action Needed SQL Server 2008: how much RAM memory should SQL Server use in a 8GB RAM server?
1d
comment Increase performance WITHOUT adding indexes
@BillKarwin you are right. It's just really band-aid to get around not rewriting queries and creating supporting indexes for them. I have had past clients that wanted this and were satisfied with some performance improvements. Of course, those clients had like 192GB RAM and more. RAM disks are not really for small to midsize DB Servers.
1d
reviewed Reviewed dbcc memorystatus - buffer pool target on VM higher than max memory
1d
revised dbcc memorystatus - buffer pool target on VM higher than max memory
edited tags
1d
reviewed Reviewed Problems with migration from Amazon RDS MySQL to MariaDB
1d
comment Problems with migration from Amazon RDS MySQL to MariaDB
Your question is unclear. Is MariaDB in a bare metal server, EC2, or another VM environment ? Did you tune my.cnf in the new server to match the settings you had in MySQL RDS ?
1d
reviewed Looks OK Mysql innoDB write operations are extremely slow
1d
reviewed Close date wise report and order by date
1d
reviewed Close Best way to profile SQL Server
1d
reviewed Leave Open Duplicate values
1d
reviewed Close New To SQL and looking for some advice
1d
revised Increase performance WITHOUT adding indexes
added 61 characters in body