seenugadu Posted May 3, 2017 Report Posted May 3, 2017 evaraina answer chesi pettara pls.. im prepaing for interviews.. andukani =========================================================== How would find out the size of the table in MySQL? How would you run multiple mysql instances on the same box? How do you find your whether the database is fragmented are not? How do you fix it? What kind of backup tool you have used to backup? How would you schedule daily backup using xtrabackup? Let us assume that customer calls you and says the database response is very slow? What would be your approach in debugging this issue? How do you make Schema changes on on 200GB table with foreign key? How would you find out list of indexes on the table? Have you ever done replication? Replication – Cloning – Streaming. Row-based and statement based. How do you make sure Master and Slave database is in sync? If not in sync How would you fix it? Are you familiar with different Isolation levels? What happens when the auto increment value reached the maximum value? How do you check the query performance? What would you do if the index is not being used? Someone had an access to server, he/she dropped a database. How would you recover to the point in time? How can you drop the Primary key from the table? Quote
Vendeta Posted May 3, 2017 Report Posted May 3, 2017 1 minute ago, seenugadu said: evaraina answer chesi pettara pls.. im prepaing for interviews.. andukani =========================================================== How would find out the size of the table in MySQL? How would you run multiple mysql instances on the same box? How do you find your whether the database is fragmented are not? How do you fix it? What kind of backup tool you have used to backup? How would you schedule daily backup using xtrabackup? Let us assume that customer calls you and says the database response is very slow? What would be your approach in debugging this issue? How do you make Schema changes on on 200GB table with foreign key? How would you find out list of indexes on the table? Have you ever done replication? Replication – Cloning – Streaming. Row-based and statement based. How do you make sure Master and Slave database is in sync? If not in sync How would you fix it? Are you familiar with different Isolation levels? What happens when the auto increment value reached the maximum value? How do you check the query performance? What would you do if the index is not being used? Someone had an access to server, he/she dropped a database. How would you recover to the point in time? How can you drop the Primary key from the table? Y don't u do some homework, u can find answers to these in google . get some life dude!!! Quote
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.