MySQL Performance, and Availibility Questions

2003-02-27 Thread Jeff Bearer
ize each machine to it's fullest capacity. I anxiously await your responses. -- Jeff Bearer, RHCE Webmaster, PittsburghLIVE.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

Is there anything equivalent to Oracle9i's list partitioning?

2003-02-12 Thread Jeff Bearer
I've recently learned that Oracle has the ability to partition table data, Oracle9i's list partitioning feature. http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html I'm trying to find out if MySQL or any open source database has something equivalent to this. ---

will this alter table lock selects?

2002-03-20 Thread Jeff Bearer
it is done, I know that it will lock inserts and updates while the alter is running, that's fine with me. query sql -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com 2002 EPpy Award, Best Online U.S. Newspaper - B

Re: setup 1 user to connect from 2 hosts.

2002-01-11 Thread Jeff Bearer
> localhost phphelpdesk phphdadmin > localhost phphelpdesk helpdesk > > > So it seems that, you can INPUT multiple HOSTs, multiple, USERs and multiple > DBs... > > Have a nice day... > > > ---Original Message---

setup 1 user to connect from 2 hosts.

2002-01-11 Thread Jeff Bearer
What is the correct way of having 1 user connect from only 2 hosts to the same database? Since user,host, and db fields are all primary keys in the all of the user, host, db tables. I can't enter a user twice with diffrent hosts as I had planned on doing it. I'd prefer to explicitly state the tw

Re: Problems with sum() in a query.

2001-05-23 Thread Jeff Bearer
t; school='myschool' >> GROUP BY school >> >> If I query for a few schools (school_id>3) sometimes I get unusual >> numbers, 17.24 for one example. I'm not sure what's happening with >> these queries so I have to ask. >> >> Am I do

Problems with sum() in a query.

2001-05-22 Thread Jeff Bearer
e to handle this query? Or did I find a bug in mySQL? -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

Using myismchk to sort by an index

2001-03-27 Thread Jeff Bearer
| story|1 |story_date|1 |story_date |A|244 |NULL|NULL | | any help would be greatly appricaited. -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com - Before posting, please check: http://ww