63,623 reputation
1064148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 1 hour 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
3
answered Small Cloud Database
Jan
3
revised What is the best and most performant MySQL cloud solution?
added 4 characters in body
Jan
3
revised What is the best and most performant MySQL cloud solution?
added 4 characters in body
Jan
3
answered What is the best and most performant MySQL cloud solution?
Jan
3
reviewed Approve suggested edit on How do I change the DEFINER of a VIEW in Mysql?
Jan
3
reviewed Approve suggested edit on SQL Server 2000 export database to csv
Jan
3
revised Query Regarding Database Instance not proper
Removed all tags, Added sql-server tag
Jan
2
reviewed Approve suggested edit on Guid vs INT - Which is better as a primary key?
Jan
2
revised mysql_install_db: How to set the root password
added 325 characters in body
Jan
2
comment What is the best and most performant MySQL cloud solution?
What storage engine are you using ??? Let me be more specific: Is all your data InnoDB, MyISAM, or a mixture of both ???
Jan
2
reviewed Approve suggested edit on Query not using index when it should
Jan
2
reviewed No Action Needed What is the best and most performant MySQL cloud solution?
Jan
2
revised Mysql slowly uses memory until it starts to use swap
added 93 characters in body
Jan
2
comment Mysql slowly uses memory until it starts to use swap
You are definitely going to need more RAM in your VM. MySQL is currently configured to handle 1.6G, your VM is 1G (1024M), and you are using 1193MB (> 1024M). There are no settings you can decently reduce in this instance. Please upgrade the RAM to 4G. Please click on Percona actually tested this out awhile ago and see how MySQL 5.0 outperforms MySQL 5.5 in a single-threaded environment (which a VM essentially behaves as).
Jan
2
reviewed Approve suggested edit on Color syntax printing in SSMS 2012
Jan
2
comment Mysql slowly uses memory until it starts to use swap
Try running mysqltuner.pl on the DB Server and let it tell you what is the maximum memory usage based on current settings.
Jan
2
revised mysql_install_db: How to set the root password
added 3 characters in body
Jan
2
answered mysql_install_db: How to set the root password
Jan
2
reviewed Approve suggested edit on Delete and archive old data from several related tables
Jan
2
comment Query not using index when it should
Wow, that leads table needs mad normailzation.