56 reputation
4
bio website
location Florida
age
visits member for 1 years, 6 months
seen Apr 10 at 20:04

Mar
13
awarded  Student
Mar
12
comment How to determine why a MySQL server has become slow and requests sometimes time out?
- Just wondering, are you network connections stable?
Mar
11
comment Extremely slow mySql restores
okay, I'll try this. Thanks.
Mar
11
comment Extremely slow mySql restores
Both of my databases are running on the same mysql instance. The actual prod transactions won't be very large. Should I still increase the innodb_log_file_size and innodb_log_buffer_size?
Mar
11
comment Extremely slow mySql restores
@RolandoMySQLDBA I have added the sample script which is restored. I don't have the exact mysqldump command as the dump is generated by the hosting providers and I don't have access to that script right now.
Mar
11
revised Extremely slow mySql restores
Added sample mysql dump that is used for the restoration on Stagin db
Mar
10
comment Extremely slow mySql restores
1) It's a mixture of both. 60 % of the tables but (approx) 85 % of the data is on InnoDB. 2) Both the DBs are on the same MySQL Instance (as I see only one instance of mysqld on the server) and a single my.cnf. Please let me know if my understanding is incorrect.
Mar
10
comment How to print the information of all tables using Oracle?
If you have Oracle SQLDeveloper, you can get the pictorial representation of your schema/tables/columns. oracle.com/technetwork/developer-tools/datamodeler/overview/… Even better?
Mar
10
awarded  Promoter
Mar
10
revised Extremely slow mySql restores
added 50 characters in body
Mar
8
revised Extremely slow mySql restores
added 115 characters in body
Mar
8
awarded  Editor
Mar
8
revised Extremely slow mySql restores
added 62 characters in body
Mar
8
asked Extremely slow mySql restores
Oct
6
awarded  Supporter