First time here? Check out the FAQ!
Ask Your Question
0

Is there any potential problem if use MyISAM engine in production environment?
 
   
  
 
 
As the subject. By using MyISAM is safe for production environment? And does it affect future upgrade?
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 tkdchen's avatar

      1
    
 
 
 
 tkdchen 
 
 
    asked 11 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
  
 
 
 
 
0
 
 
  
 
 
 
 
 
 
Yes, the potential problem is due to lack of transactions in that engine and the database may end up in inconsistent state.
 
We have a number of users we support who are on MySQL, so far no major problems, however I plan to migrate them to Postgres and definitely would not recommend MySQL for the new deployments.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    answered 11 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
  see more comments