#mysql

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
atop8918's picture

Drupal 7 Job -- Seattle-Everett, WA.

I hope it is okay to post job offers here. If not then I apologize.
We're a small, Renewable Energy company based out of Washington State looking for some Drupal 7 help. Women and women-led teams are strongly encouraged to apply for this role. We'd prefer someone in the Seattle-Everett area but remote may be fine too.

Read more
Anonymous's picture

Fine-grained MySQL tables privileges

Regarding Drupal site security, I am really surprised to see that MySQL settings do not keep an important place in Securing your site discussion.

Yet a very simple MySQL policy would have prevented Drupageddon to your site.

According to INSTALL.mysql.txt, MySQL user used by Drupal, must have the following minimal privileges on Drupal database:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES.

Read more
rmjackson's picture

Drupal Database Development

The percona-query-digest tool is excellent at tracking down queries that kill performance. The queries can be re-written on modified schemas with better indexes and you're golden. Once that's done you need to institure some healthy happy ways to avoid the problem continuing to recur through a little education and some development routines.

Read more
lsiden's picture

Seeking part-time developer to help finish site

You are a talented and dedicated software developer proficient with Drupal (not a firm), and competent with mySQL databases, and willing to learn a bit about Ubercart. You are also available to work on a part-time basis.

We are a small company about to roll out a website with over 19 million business listings that allows homeowners to search for local businesses and service providers.

Read more
Lloyd's picture

MySQL table_cache: Is lower better?

In the past, using MySQL tuning scripts like mysqltuner.pl and tuning-primer.sh have always suggested increasing table_cache to fairly high levels. I've now been reading a few articles about benchmarks that have suggested a lower table_cache can often result in better performance (one such blog post at http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scal...).

So I was wondering what experiences people have had running Drupal sites in terms of tweaking table_cache.

Read more
Lloyd's picture

MySQL Tuning: tmp_table_size and max_heap_table_size

I'm switching over to a new server for my Drupal sites and am starting to tweak MySQL using tuning-primer and mysqltuner. I'm hosting on a VE server at Media Temple with (currently) 1GB of dedicated RAM. The database is currently MyISAM with no INNODB.

Read more
Subscribe with RSS Syndicate content