70,731 reputation
1170161
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 10 months
seen 22 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


22m
answered MySQL InnoDB Deadlock For 2 simple insert queries
8h
reviewed Close how to Write a SQL Statement to display EmployeeID from Table1 and EmployeeName from Table2 a
18h
revised getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench
edited tags
18h
answered getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench
23h
reviewed Close MySQL 2008 create database problem
23h
comment Hierarcy Query Mysql
That code is not from me. That code is SQL Server's TSQL, which I don't know. This one (dba.stackexchange.com/a/7161/877) is my post.
23h
reviewed Reject Changing mysql root password on Windows after removing mysqld-nt.exe
23h
reviewed Edit Does it make sense to use full recovery if the data and log files are on the same HD?
23h
revised Does it make sense to use full recovery if the data and log files are on the same HD?
Fixed grammatical error, clarified type of backup
23h
reviewed Close The sum of the distances of all employees and select the top 3
23h
reviewed Close MYSQL PHP slow response from server
23h
reviewed Close How to empty a column in mysql
1d
comment Hyperthreading & MySQL InnoDB Thread Concurrency Performance
@kommradHomer Never mind. You do not have to restart mysqld. Just run SET GLOBAL innodb_thread_concurrency = 0;. Then, add that setting to my.cnf so it is available after restarting mysqld. Again, you do not have to restart mysqld.
1d
comment Hyperthreading & MySQL InnoDB Thread Concurrency Performance
@kommradHomer What version of MySQL are you using ?
1d
comment Hierarcy Query Mysql
dba.stackexchange.com/questions/57934/…
1d
comment Hierarcy Query Mysql
dba.stackexchange.com/questions/7147/…
1d
reviewed Reviewed Make a field in a form that count values
1d
reviewed No Action Needed pg_upgrade unrecognized configuration parameter “unix_socket_directory”
1d
reviewed Close The value could not be converted because of a potential loss of data
1d
reviewed Close Oracle Enterprise Manager - Where do I find the error logs?