Skip to main content
Database Administrators

Return to Question

Post Timeline

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables.

#QUESTIONS

QUESTIONS

  • If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables?
  • Is this a good practice?

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables.

#QUESTIONS

  • If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables?
  • Is this a good practice?

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables.

QUESTIONS

  • If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables?
  • Is this a good practice?
edited tags
Source Link
RolandoMySQLDBA
RolandoMySQLDBA
  • 185.7k
  • 34
  • 329
  • 546

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables. If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables? Is this a good practice?

#QUESTIONS

  • If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables?
  • Is this a good practice?

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables. If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables? Is this a good practice?

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables.

#QUESTIONS

  • If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables?
  • Is this a good practice?
Post Migrated Here from serverfault.com (revisions)
Source Link
Boolean
Boolean
  • 641
  • 1
  • 9
  • 10

How does mysql deal with queries that touches myisam and innodb tables?

In our mysql database, we use both myisam and innodb tables, though there are more myisam tables. If a query involves both myisam and innodb tables, will the query use table lock or row lock on innodb tables? Is this a good practice?