Question regarding innodb tables

I have a question regarding the innodb_file_per_table configuration option. We currently do not have this enabled, so our ibdata1 file is huge. Is it recommended that we have this configured to store the tables in their own files? What are the performance implications of doing this,

Assistance with query and joins

Hi all, I have a query that is not quite producing what I expected: select n.nid, n.title, DATE_FORMAT(FROM_UNIXTIME(n.created), '%c/%e/%Y') as created, c.field_product_price_value as price, d.name, t.tid, v.value AS vote_average from node n left join

High Traffic Sites

A colleague and I are having a discussion about the best way to handle high traffic sites. For example, take a social networking site with 1 million users. I think it would be better to have multiple web servers with multiple database servers in a master/slave scenario with replication. My

Re: High Traffic Sites

, Erich C. Beyrent [EMAIL PROTECTED] wrote: A colleague and I are having a discussion about the best way to handle high traffic sites. For example, take a social networking site with 1 million users. I think it would be better to have multiple web servers with multiple database servers in a master

Re: need advice on how to design tables for recurring events

I've been working with Drupal for some time, and there is a module that allows you to create event-based content with a repeating schedule. The schema that it uses may be of some help to you. CREATE TABLE IF NOT EXISTS event_repeat ( rid int(10) unsigned NOT NULL default '0', repeat_data

Select question

I have three tables, all of which have a 'name' column. If I do: select table1.*, table2.*, table3.* from I'll end up with a result set that has three 'name' fields, but no way to distinguish which table the field belongs to. I know I can select individual columns like: select

Temp tables

Hi all, I am running into a brick wall with a query that is running against a MySQL 3x database, and the temp tables are filling up before the query can run. Here is the query: SELECT Avails.ResortID, Inventory.ID as InventoryID, Avails.ID as AvailabilityID,

Re: Query dies silently

Gleb Paharenko wrote: Hello. I get 142k rows back in just over 4 seconds. It means that on the server side query works, so the problem probably is in PHP. Good call. I did some testing, and sure enough, the mysql_query() is successful. The failure comes in trying to retrieve the rows

Query dies silently

Hi all, I have a rather strange problem that I cannot seem to figure out. When I run the following query from the MySQL console: SELECT Inventory.ID as InventoryID, Inventory.Name, Inventory.Capacity, Inventory.Beds, Avails.ID as AvailabilityID,

Creating backups

Hi there, Does anyone have some tips or advice for creating backups of all the tables and data contained therein? Do you use custom solutions or perhaps open-source projects? -Erich- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Insert happens twice

Hey folks, I am having a dreadful problem here, and I cannot get to the root of it. It appears that every time I do an INSERT, the insert happens twice. I have spent several days on Google, but with no luck. Some background - I am using PHP and Smarty on a site. Here is one of the tables in my