MySQL

This group mission is to address MySQL related issues in Drupal modules development process or discuss efficient use of MySQL within Drupal based projects.

deja711's picture

Performance issues with INNODB vs MyISAM

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.

Read more
samstamport's picture

Database tutorial for a beginner

I am a newbie to Drupal.

I am trying to wrap my brain around how Drupal uses MySQL. I am pretty familiar with relational databases especially Microsoft Access. Can you give me a reference to a free ebook, tutorial, or YouTube video that explains exactly where the database(s) is stored on my local Win 7 PC? I am using Acquia Dev Desktop.

Thanks!

Read more
suzannewang's picture

Replacing old user tables causes drupal site to crash

Hi,

I have both a live website and a testing site.

I am trying to replace the user and related tables on my testing site with the tables EXPORTED FROM the live site. My testing site doesn't take them well and encounters unexpected errors.

Has anyone met the the same issues before?

Thanks a lot for reading.

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
nerdcore's picture

MySQL Config Optimizations?

I am curious to know if anyone has advice on tweaking the out-of-the-box my.cnf specifically for Drupal?

The organization I work for typically hosts multisite installations, and may have numerous disparate sites running on a single web server using a single MySQL server... Given that there is a wide range of sites with varying purposes (some more anonymous viewing, some more authenticated content generation), are there any Drupal-specific changes to my.cnf which might be appropriate?

Read more
thermalmusic's picture

migrating users and content from D6 to D7

Hi all,

I am in the process of developing a site in Drupal 7 to replace a site in Drupal 6 on the same server. We decided to create the new site instead of upgrading the old one for various reasons. I realize there are pitfalls migrating users, nodes, and other data from D6 to D7.

My questions are: has anyone had experience doing this, and what kinds of snags have you encountered? Did you use the migrate V2 module, SQL scripts, drush, or combination of the three?

Any comments, suggestions will be appreciated.

Thanks,
Steven

Read more
thermalmusic's picture

Select query for Users/Profiles on single rows

Hi,

I'm trying to write an SQL query on a D6 database to return users and their profile values. My problem is getting profile values to return as separate fields (columns) in the resulting rows. Profile data is only saved in the values field in the profile_values table, as children, identified by fid.

I've tried Group_Concat but it is not a solution. Profile csv module is not sufficient either. I'd like to have an output like this:

User | Firstname | Lastname | Address | City | State | Zip | etc |

If anyone has done this as a query, please let me know.

Thanks,
Thermal

Read more
LinuxRecruit's picture

Drupal Developer, 6 month contract, UK | LinuxRecruit

Employment type: 
Contract
Telecommute: 
Allowed

LinuxRecruit are looking for a Drupal Developer for a Drupal consultancy in the UK. Possibility of remote working (must be UK based)

Call 020 8432 2232 or email tony.chapman@linuxrecruit.co.uk for full details.

Referrals very welcome and we have a very generous referral scheme

Read more
stevengm7's picture

Custom search results

Hi everyone

I have been messing with Drupal and other CMSs for a while (3+ years). But I chose Drupal and stack with it since then no matter how hard the learning curve was.
So far whenever I had issues either I figure it out or search Drupal.org site for any possible solutions time being sacrificed. But now I want to save time and be efficient expediting my projects getting direct help from all my groups. Most issues being discussed here are grabbing my attentions because they are very important that's why I joined so many groups.

Read more
LinuxRecruit's picture

Senior Drupal Developer | LinuxRecruit

Employment type: 
Contract
Telecommute: 
Not allowed

Drupal Developer - Senior, London

Creative Digital organisation in London are looking for a Drupal Developer on a 6 month contract.

You will be an experienced Drupal Developer and have been working with for a number of years.

We're looking for someone who has extensive PHP, Drupal, MySQL Experience.

If you're interested in discussing further please contact Tony Chapman on tony.chapman@linuxrecruit.co.uk or 020 8432 2232

Read more
digodrupal's picture

How to seach text from .txt file

i need this help on drupal.

i have a text file and file name is C:\wamp\www\mysite\sites\default\files\abc.txt. in this file is;

aaaaa bbb
ccccc ddd
eeeee fffff

if i type aaaa in the search box and hits enter means the output should come with the node containing the word aaaa and this this text document also.

This will be shown in search output

is there any module available for that?

thanks.

Read more
lana_cmp's picture

PHP Developer | Capital Markets Placement

Employment type: 
Full time
Telecommute: 
Not allowed

Client: Fortune 500
Location: Herndon, VA
US residents only (incl. H1B visa holders)

Candidate should have more than 8 years of professional and software design and development experience. The candidate should also have extensive experience in designing the architecture and managing future enhancements for an enterprise wide web based solutions. Further, the candidate should have proven track record of proposing system innovations and advancement in order to keep up with the new technology.

General Experience:
- Web development in LAMP architecture
- Fluent in PHP including 5.3.x

Read more
gayatri_ghoshal's picture

MySQL DBA | Brill Street + Company

Employment type: 
Full time
Telecommute: 
Not allowed

Requirements:
Responsible for the MySQL and other open source database servers, including production, test, and development.
Assist in support of all other databases and be part of a dynamic and fast paced team
Improve the performance and reliability of the databases and customer experiences.
This job is approximately 75percent database config & sysadmin responsibilities.
The other 25percent is understanding of the underlying data to ensure that the database and data are optimized for the best overall performance..

Qualifications:

Read more
worldtradegroup's picture

Lead Web Development Manager | World Trade Group

Employment type: 
Full time
Telecommute: 
Not allowed

Lead Web Development Manager (PHP) - You will be responsible for the development of new web & mobile applications using open source CMS platforms, leveraging an extensive CRM system. Reporting to our Global Head of Web Development in the planning of overall company strategy, you will manage and coach an expanding team of web developers.

Read more
aaron1948's picture

Database development prior to MySQL

I am seeking advice about what might be the best database program to use to create a large pre-MySQL database, from which I will select the content to export/import/enter into a Drupal MySQL database.

I am developing my first Drupal site -- a web portal where information will be organized by relevance to various generations. The site will launch with a Baby Boomer orientation, with information organized for various baby boomer niches, and then expand to serve more generational niches.

Read more
jamesclarke's picture

slow term_data and term_node queries

Hello,

I've been trying to figure out why our drupal site is going slow . . . this has ranged from disabling modules (update status and statistics) to looking into the slow queries log.

When I look into the log, the overwhelming majority of the entries are from term_data or term_node

E.g:

SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 169 ORDER BY v.weight, t.weight, t.name

and

Read more
showmanlkz's picture

Porting drupal's database to MySQL Cluster possible?

Hi guys, my organization is running a MySQL Cluster 7.x. I have been quite comfortable to port some of our MySIAM type tables to MySQL Cluster's NDB type.

I found that drupal uses innoDB, so I am wondering if it's possible to port it to NDB type?

FYI, MYSQL Cluster NDB doesn't support few things in innoDB include foreign key constraints.

http://dev.mysql.com/doc/refman/5.0/en/faqs-mysql-cluster.html

Any opinion will be welcomed.

Derrick

Read more
thermalmusic's picture

SQL select query for returning all roles and permissions

Hi everybody,

I want to create a select query to return a list of all roles and their related permissions directly from a MySQL database. Does anyone have a good one for that?

Thanks,
Thermal

Read more
Anonymous's picture

Move MySQL databse & Show the Ropes | The Ouverson Group, Inc.

Employment type: 
Contract
Telecommute: 
Allowed

I need help with 2 things:

  1. I need help moving MySQL database from one host to another. Maybe even clean-up the database after the move.
  2. I need person to "show me the ropes" so I can do 2nd, 3rd, etc.

I am savvy to LAMP stack and Drupal, but have never done a mysqldump, migration, etc. and am under time constraint so I'm willing to pay for help.

I need someone who is super-savvy to MySQL and Drupal.

Please feel free to call me on my cell: 239-249-2842 or email: doug@ouverson.com

Read more
lfolta's picture

SQL ICE Demo for Drupal Users - Webinar Tues, March 22

SQL ICE Demo - How to Use SQL ICE to Access Your Drupal Data

Join us for a Webinar on Tuesday, March 22, 10am Central

Reserve your Webinar seat now at:
https://www1.gotomeeting.com/register/882042968

Are you a Drupal user and do you know SQL? If you answered "yes", then SQL ICE could be a useful tool to have on your desktop.

In this session, we will demonstrate how you can use SQL ICE to access your Drupal data, using the same version of SQL ICE (v.1.1.1) that is available as a free download from our site, to run queries against the data from our live Drupal site.

Read more
Subscribe with RSS Syndicate content