Comments on: Drupal and MySQL Performance: Register now for Nov. 13 webinar https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/ Thu, 11 May 2023 18:35:22 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: mikeytown2 https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3448749 Wed, 27 Nov 2013 00:00:44 +0000 https://www.percona.com/blog/?p=19196#comment-3448749 Trying to using the Memory table for the Drupal cache* tables is only supported if your using the Percona flavor of MySQL. Also noted that you might need to move the data column to be at the end.
http://www.mysqlperformanceblog.com/2011/09/06/dynamic-row-format-for-memory-tables/

]]> By: Narayan Newton https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3398515 Tue, 19 Nov 2013 23:22:05 +0000 https://www.percona.com/blog/?p=19196#comment-3398515 Excellent presentation. One thing to mention that is sometimes missed in the transition to Drupal7 is tx isolation. D7 benefits quite a bit from switching to READ-COMMITTED and in particular some contrib modules (views_content_cache) semi-require it for large scale deployments. If your having locking issues on D7, this is something to keep in mind.

-N

]]> By: Miklos Szel https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3365478 Thu, 14 Nov 2013 12:32:21 +0000 https://www.percona.com/blog/?p=19196#comment-3365478 Thanks Mike 🙂
Unfortunately I wasn’t able to attend on the webinar but I’m going to watch it as soon as it’ll be available!

Another thing worth mentioning that the Drupal 7 default DB has multiple duplicated indexes (8 IIRC)
I guess it’s the ‘heritage’ of converting the MyISAM to InnoDB blindly without considering that the primary key is stored with the secondary indexes in InnoDB anyway.

]]> By: Merrick https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3361747 Wed, 13 Nov 2013 21:47:40 +0000 https://www.percona.com/blog/?p=19196#comment-3361747 Thanks Mike!

Great overview. I look forward to more Drupal & AWS topics! (overview & in-depth)

]]> By: Mike Benshoof https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3360195 Wed, 13 Nov 2013 15:59:47 +0000 https://www.percona.com/blog/?p=19196#comment-3360195 Congrats Ferenc and Miklos!

Both are very big changes between versions – and @Miklos, shipping with InnoDB is a big plus!

Our community manager will contact you via email to arrange for sending out your t-shirts.

]]> By: Miklos Szel https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3359609 Wed, 13 Nov 2013 13:51:11 +0000 https://www.percona.com/blog/?p=19196#comment-3359609 splitting the read/write operations->support master-slave config without hacking.
(and finally it arrives with InnoDB by default, but that’s not code-related :))

]]> By: Ferenc Nemeth https://www.percona.com/blog/drupal-and-mysql-performance-register-now-for-nov-13-webinar/#comment-3350223 Tue, 12 Nov 2013 08:55:59 +0000 https://www.percona.com/blog/?p=19196#comment-3350223 Drupal 6 uses either mysql or mysqli PHP extension (mysqli is the default if it is enabled)
Drupal 7 uses the PDO_MYSQL driver via PHP Data Objects (PDO) extension.

]]>