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


38m
revised InnoDB inserts 100 times slower than SQL Server inserts
added 419 characters in body
45m
revised InnoDB inserts 100 times slower than SQL Server inserts
edited tags
49m
answered InnoDB inserts 100 times slower than SQL Server inserts
1h
reviewed Leave Closed How to find what is causing large transaction log backups in MS SQL Server?
1h
reviewed Leave Closed Stock table Database Design
1h
reviewed No Action Needed Report Server: (rsInternalError) Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
1h
reviewed Approve suggested edit on How to convert html entities in Oracle?
1h
reviewed Close Why is casting a string to DATETIME not accurate to the ms?
1h
reviewed Close How to calculate total amount of time to load CSV file in SSIS
1h
reviewed Close Error while running a job
1h
reviewed Close SQLIO and its Flags
1h
reviewed Close Inline edit SQL Server database rows from Visual Studio
1h
reviewed Close how to compare time slots?
1h
reviewed Close insert multiple authors only if it exists in MySQL
1h
reviewed Close select on table slows done during update on same table
1h
reviewed Close Storing Page View Statistics
1h
reviewed Close creating cache tables in database
1h
comment Strange MySQL replication error 1146 (Table doesn't exist)
I have four(4) questions : Q1) Do you only run backups on Slave B ? Q2) What is the storage engine of the table course_location_tracks ? Q3) Did you create that table with CREATE TABLE course_location_tracks or CREATE TEMPORARY TABLE course_location_tracks ? Q4) Did you stop replication with STOP SLAVE; or STOP SLAVE IO_THREAD; ?
2h
revised Implement a Parent-Level Count in Binary Search Tree
added 147 characters in body
2h
revised Implement a Parent-Level Count in Binary Search Tree
edited title