mysql

SingleMind is looking for a few talented senior Drupal 8 developers to join our team. More info can be found at https://jobs.drupal.org/singlemind/job/14174. Thanks!

We are running about 50 Drupal 7 Multisites + 1 Domainaccess Site with 10 Domains on a 2x 64GB 16 Core Cluster Nodes with Apache mod_php with apc and mysql stack.

The multisites are utilizing all the same codebase and just differ in usage of content and node types.
At the moment there are 3 mysqld running on the host.
We are thinking about splitting the 50 multisites in 2 halfs and run another mysqld for that.

One of our main problems is, that deployments with changes to many features could take several hours at the moment.

Hi,

The Creative Works (formerly PublicityWorks) is currently in need of an experienced Drupal 7 developer to help us out on a number of sophisticated web projects.

Estoy buscando posibles colaboradores para el desarrollo de aplicaciones web con Drupal. Se trataría de colaborar en proyectos puntuales para picos de trabajo.

Not sure where is the most appropriate post for this, let me know if anybody has suggestion.

I am having performance issues with INNODB. My major issue is that with INNODB I am getting approximately 20 times slower performance than with MyISAM. For the purpose of testing I have used Drupal 7 with devel module installed. Further more I used 2 bare bone servers with default installations so I can do parallel comparisons.

Not sure where is the most appropriate post for this, let me know if anybody has suggestion.

I am having performance issues with INNODB. My major issue is that with INNODB I am getting approximately 20 times slower performance than with MyISAM. For the purpose of testing I have used Drupal 7 with devel module installed. Further more I used 2 bare bone servers with default installations so I can do parallel comparisons.

Just a heads up that the beta 1 of the Asynchronous Prefetch Database Query Cache module https://www.drupal.org/project/apdqc is now available.

From my testing this will eliminate all deadlocks & metadata locks for all cache tables.

おそらく私のところでは解決したのですが、情報として投稿しておきます。

先週ウチで運用していたWindows+XAMPP環境で運用していたDrupalのサーバがシステム障害を起こし、新サーバへの引越し復旧を進めていました。

Drupal7です

そして元サーバと同じく最新版のXAMPPを新サーバにインストールし、
毎晩mysqldumpでバックアップしていた全データのダンプsqlをmysqlで復元しようとしたところ、
途中の特定の行で以下のエラーが出て進まなくなりました。

http://dba.stackexchange.com/questions/75328/row-size-error-with-mysql

ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

Hi,

We have a current Drupal 7 site using SQL Server 2012 but need to export the database and import into MySQL.

SQL server has worked ok but due to the lack of module support we need to change the database to MySQL.

Are there any steps to do this online specifically for a Drupal website?

Can anyone recommend a MySQL data recovery service? One of my servers has corrupted the /var/lib/mysql files and the host claims they don't have a backup. (I'm skeptical of that. I think we're mis-communicating.)

In the meantime, they've suggested I look for a MySQL data recovery service to repair /var/lib/mysql. Can anyone in the group recommend such a service?

TIA !