a problem with the java connection to it for
now. Unless what I've sent above raises any concerns for anyone on the
list.
Tauren
> On Mon, Feb 25, 2002 at 03:24:25PM -0800, Tauren Mills wrote:
> > I am hosting websites that use the mysql database. One of my
> customers has
&
I am hosting websites that use the mysql database. One of my customers has
a query that they run occasionally that really bogs down the entire server.
The load sometimes jumps up into the double digits (on a Red Hat 6.2
server).
Here is their query:
select count(*) from aptreviews, aptcomplexes
I have been using MySQL for approximately 6 months now on Solaris 2.6/2.7
and have never had a problem installing from source and compiling, but have
never been successful in installing a binary distribution.
In particular, after untarring the files using (GNUtar), after changing
permissions, etc
ny help on this one.
Thank you in advance.
Additional question: In the archives there was mention of a log for MySQL,
where would one find this on a RedHat 7.1 system when MySQL was installed
via rpm.
Wallace Mills
DISCLAIMER
The in
ny help on this one.
Thank you in advance.
Additional question: In the archives there was mention of a log for MySQL,
where would one find this on a RedHat 7.1 system when MySQL was installed
via rpm.
Wallace Mills
DISCLAIMER
The in
Perhaps I wasn't clear enough... MSSQL is a reference to Microsoft SQL
Server, NOT MySQL. MySQL support is far superior to M$'s offerings... And
I've only had experience with free MySQL support as compared to Pay Per
Incident M$ Support... I'm sure the paid MySQL support is an order of
magnitude b
In my previous job supporting MSSQL at hospitals all across North America,
Europe and Australia, Critical Incident support from M$, ranged from 36
hours to 4 days for a resolution. Often we solved it ourselves long before
we had an answer from M$... Sad really... MySQL support is far superior, but
Sounds like you could be a reference site for Microsoft!! Only 2 corruptions
using Access multi-user. That's incredibly good. I've supported systems with
only 3 concurrent users who suffered corruption on a nearly daily basis.
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To
Drop the semi-colon off the end of the SQL Statement you wish to run. You
don't need them in the phpMyAdmin SQL Window.
Enjoy,
Tyrone
- Original Message -
From: "Tommy Beavitt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 8:31 AM
Subject: Re: phpMyAdmin newbi
Try this:
SELECT * FROM content, address WHERE content.msg_id = address.msg_id
If I understand what your asking for, you want a JOIN. If I don't
understand, forgive me, it's late... :)
Tyrone
-Original Message-
From: matteo [mailto:matt@web]On Behalf Of Matthieu Paindavoine
Sent: Thurs
On the internet specifically I'd say try http://www.mysql.com/manual.php ,
it's one of the better manuals I've come across (Free Software or
Commercial). If you want an excellent book, get MySQL by Paul DuBois. Also
'The Practical SQL Handbook' is good, although not MySQL specific.
Best of luck!
SQL, QUERY
I posted a little while back with a problem on several tables where the
autoincrement column reverted to zero for no apparent reason. Now I know the
reason, I just don't understand it, or know what to do differently.
I find myself in the all too common situation where I can developing
Can you post some code?
- Original Message -
From: "Harry Bakken" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 8:09 AM
Subject: Newbie with PHP
I apologize if this seems simple, or stupid, or if there is an answer in
the archives. I am under an extreme deadl
al Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 11:24 AM
To: Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
Here's the CREATE TABLE syntax I used on the latest table to do this to
me...
CREATE TABLE site_users (
user_
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 9:06 AM
To: Tyrone Mills; Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
What's your datatype?
Cal
http://www.calevans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Su
Why is it that a seemingly random intervals anyone of the tables in my
database will decide to start auto incrementing back to 0? More importantly
how to I stop this? I've tried not inserting a value for the auto increment
column, I've tried inserting NULL, or '', nothing works!!
I think I have a corrupt table and my most recent backup is too old to use.
Here's the scenario:
I started getting duplicate key errors for no apparent reason. The column is
a medium int, the highest value was 260 (or there abouts) and it was trying
to insert a 0. So I whipped out my MySQL Manua
High Availabilty
-Original Message-
From: Billy Passauer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:00 PM
To: carlos ospina; [EMAIL PROTECTED]
Subject: RE: MySQL HA
> -Original Message-
> From: carlos ospina [mailto:[EMAIL PROTECTED]]
>
> I wanna know if someone
in log 'master-bin.197' at position 0
Should this be necessary? Is there a bug someplace?
--
-Gary Mills--Unix Support--U of M Academic Computing and Networking-
-
Before posting, please check:
My apologies if this is an easy question. I've looked at the docs in the
privilege section and haven't found a mention of the max length of password
for MySQL. I want to set a fairly long one for each of my web servers that
will be hitting my database server. Incase it is important, I'm running
3.
The .sh designates that the file is a shell script. Linux doesn't do file
associations like windows does. You could call it anything, and as long as
it's an executable file, it'll run. CHMOD the files you need to run.
-Original Message-
From: Mac Martine [mailto:[EMAIL PROTECTED]]
Sent: T
Within the last few days we've started having serious problems with our
database. We have no problems connecting to it using "mysql" and
"mysqladmin". For instance, this command lets us into the database just
fine:
mysql -ucustomer -p customer_database
The database seems to be working correctly
Unix system administrators should attempt to use Midas.
Look in the `doc' directory of the source distribution
for the rest of the documentation. Source can be downloaded at:
http://mail.cc.umanitoba.ca/source/
--
-Gary Mills--Unix Support--U of M Academic Computing and
table netgroup' and `load table common.netgroup
from master'. Why did this happen? There should have been no updates
to that table overnight. I don't want it to happen every night! Is
there a better fix for this problem?
--
-Gary Mills--Unix Support--U of
where. Should it be?
--
-Gary Mills--Unix Support--U of M Academic Computing and Networking-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
25 matches
Mail list logo
