Tagged Questions
1
vote
1answer
38 views
How do I get a new database connection with a new setting?
I want to set the GLOBAL variable innodb_flush_log_at_trx_commit, and then run a migration after getting a new connection since changes to a global variable does not affect the current session.
So ...
1
vote
0answers
50 views
My queue table is huge, is it safe to empty it?
I have launched some batch jobs that I didn't finish. Now I notice my queue table is almost 1 GB. Is it safe to empty it?
1
vote
1answer
738 views
PDOException: SQLSTATE[42000]: Syntax error or access violation
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118
Row size too large. The maximum row size for the used table type, not
counting BLOBs, is 8126. You have to change some ...
11
votes
2answers
269 views
What tables should or could be migrated to InnoDB, and which should remain MyISAM?
As per title: Is there a quick list of candidates for tables to migrate to InnoDB? And what should remain MyISAM.
Some additional information
The site has a fairly heavy read-load, but inserts ...
6
votes
3answers
2k views
How do I convert a database from MyISAM to InnoDB?
I am going to convert all the tables of 500MB database from MyISAM to InnoDB to see whether it will improve the overall performance of a busy Drupal 6 site. I am wondering what is the best (i.e. ...
