Re: Master/Slave Replication Question

> from what i've read and seen geographical load balancer > works as: multiple DNS A records routes to multiple > Apache Servers(mod_php tucks in as a module under Apache) > each web servers would connect to MySQL on their own > localhost 1.2.3.4-WebServer would communicate directly to > 1.2.3.4-M

Is It Possible to create a Join with Multiple Tables

:Newbie: Short Question: Is it possible to create an inner join (or another join) with multiple tables? something like $query_list1 = "SELECT table1.id,table1.status, table2.id, table3.id (more here - etc.) FROM table1 INNER JOIN table2 ON table1.id = table2.id INNER JOIN table3 ON table2.

Re: Master/Slave Replication Question

> Do you want geographic redundancy or do you want to scale reads? > In this case you're talking about scaling reads for a bunch of > apps all running together. If you want performance in that case, > then first you'd want to isolate the apps from each other. Geographic redundancy is my primary g

RE: Master/Slave Replication Question

Cluster is not supposed to be a universal solution, for a reason. Universal solutions tend not to be very performant. "If each application handles this sort of thing differently, then when I run all these applications on my server (and I do - we host about 175 web sites altogether) I have to c

Re: Master/Slave Replication Question

> Moreover, it works today as opposed to waiting until the end > of time for the database developers to add features like that > (which mysql cluster is already a distributed database, and > the devs have said they're not interested in trying to turn > the regular mysql into a distributed product,

RE: Master/Slave Replication Question

You'd be surprised how many places uses this as an actual solution. All arguments aside about what level of the architecture should be doing what, it simply works well. Moreover, it works today as opposed to waiting until the end of time for the database developers to add features like that (wh

Re: Master/Slave Replication Question

> Another thought would be at the application layer, sending > all the updates (insert,delete, update, etc) to server A, > and the selects to the local slave servers. This has been suggested before, and I'm totally against it. Applications like PHPBB, Drupal, WordPress, etc can't be easily confi

Re: Correct way to start new .MYD & .MYI files

Run mysqldump on the table ApplicationLog and save that somewhere where there's space, then truncate the table. If you would really like to keep the tables but only have a disk space issue, then there is one thing you can do if you have disk space on another file system. Move the 3 files for Appl

Re: Correct way to start new .MYD & .MYI files

Eugene, Right you are. I don't know why I thought he had corrupted tables to start with but that was the assumption I was under. A simple TRUNCATE is the easiest way to deal with this.. - michael On Fri, Sep 25, 2009 at 4:16 PM, Eugene Mah wrote: > TRUNCATE? > > http://dev.mysql.com/doc/ref

RE: Stupid GROUP BY question

Commonly refered to as a "groupwise max" http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html http://jan.kneschke.de/projects/mysql/groupwise-max/ Regards, Gavin Towey -Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: Friday, Septem

Re: Stupid GROUP BY question

Jerry, I want to find the newest note (if any) for each customer. See "Within-group aggregates" at http://www.artfulsoftware.com/infotree/queries.php PB - Jerry Schwartz wrote: It must be too late in the week... Suppose table Cust has

Stupid GROUP BY question

It must be too late in the week… Suppose table Cust has one field, CustID. Suppose table Notes has four fields: NoteID (unique), CustID, NoteTime, and NoteText. A customer can have zero or more notes. Now here’s the seemingly simple problem that I’m trying to solve: I want to find the new

Re: Correct way to start new .MYD & .MYI files

TRUNCATE? http://dev.mysql.com/doc/refman/5.0/en/truncate.html DELETE? http://dev.mysql.com/doc/refman/5.0/en/delete.html eugene - Eugene Mah, M.Sc., DABR euge...@ix.netcom.com Medical Physicist/Misplaced Canuck

Re: Correct way to start new .MYD & .MYI files

Alas, none that I am aware of, but if you can successfully run 'SHOW CREATE TABLE `ApplicationLog`' before you drop the table, it will give you the DDL you need to recreate that table *exactly*. - michael On Fri, Sep 25, 2009 at 3:47 PM, Jones, Keven wrote: > I don't want to lose the table stru

Correct way to start new .MYD & .MYI files

Hello, I am new to MySQL.I have a disk space issue and I have found that 3 files are the cause. The files are ApplicationLog.MYD and ApplicationLog.MYI I would like to purge these files and basically get rid of the data that is in them. What is the proper Way to accomplish this? Does anyone h

Re: many-inserts go faster the second time

At 08:24 AM 9/25/2009, Dan Nelson wrote: In the last episode (Sep 25), Bennett Haselton said: > I have a script that runs several times in the evening, and on each run it > adds several thousand entries to a table. > > On the first run, it adds the entries rather slowly. But then on all > subs

Re: 4.1 in production

Victoria Reznichenko writes: > "Holly Chamberlain" wrote: > >> >> Does anyone have a good site that contains the current SQL standard? Or >> does anyone know is ISNULL() and IFNULL(), and similar null testing >> functions, standard SQL or extensions to SQL? > > No, there are no such functions in

Re: many-inserts go faster the second time

In the last episode (Sep 25), Bennett Haselton said: > I have a script that runs several times in the evening, and on each run it > adds several thousand entries to a table. > > On the first run, it adds the entries rather slowly. But then on all > subsequent runs (usually about a minute or two l

Free SMS Gateway

Hi All , If any one know free sms gateway server, Please share the details , Thanks

many-inserts go faster the second time

I have a script that runs several times in the evening, and on each run it adds several thousand entries to a table. On the first run, it adds the entries rather slowly. But then on all subsequent runs (usually about a minute or two later), the many inserts go a lot faster. This is true rega

Re: Excluding records that don't match condition

Mike Spreitzer wrote: I'm not sure whether the following will meet your needs. Have you considered SELECT title FROM Title WHERE NOT EXISTS (SELECT * FROM Keyword, TitleKeyword WHERE Keyword.kw='A' AND Keyword.id=TitleKeyword.keyword_id AND TitleKeyword.title_id=Title.id) I believe you are r