[snip]
From: "Jonas Larsson" <[EMAIL PROTECTED]>
> But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why
> isn't that implemented? Then it would be easy to transfer the hash...
>
Yes it definitly would be nice and would have been easier to impliment than
the current Password()
On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote:
>
> So what your saying is MySQL is supposed to fork a new processes for
> every connection? I don't think so...
No. MySQL will spawn a new thread to handle each incoming
connection. It's just that threads on a Linux bear a stri
Thanks for the idea - I had a look for mysql.sock, but it was already
gone (I think the startup script must have deleted it)
For the record, to get mysqld to start again we had to run the startup
command from the mysql user account. The linux startup script runs as
root, it calls safe_mysqld,
>>By looking in the documentation and the FAQ I can't find out how one
>>should do to share passwords (in e.g. MD5 format) between UNIX (e.g.
>>Linux) and MySQL.
>>
>>I like to setup a MySQL database for 20 of my users on a Linux box
>>and it would be nice if they could retain their UNIX passwords
At 11:05 PM -0400 9/16/01, <[EMAIL PROTECTED]> wrote:
>I manually entered into my database several rows with high values in the
>auto-increment column. I subsequently deleted the high value rows. I now
>am trying to reset the auto-increment. How do I reset it to the Max of
>the currently existi
At 10:21 PM -0700 9/16/01, Michael McConnell wrote:
>So what your saying is MySQL is supposed to fork a new processes for every
>connection? I don't think so...
... based on?
Lemme guess. Running Linux?
>
>> > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I
>> > > > conne
At 10:44 PM -0700 9/16/01, Robert Peters wrote:
>We developed a site using PHP and MYSQL on an online shared server.
>We used HEAP tables extensively and everything worked fine. When we
>moved the site to our dedicated server prior to launching the site,
>the queries that should create the HEAP
So what your saying is MySQL is supposed to fork a new processes for every
connection? I don't think so...
> > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I
> > > > connect 400 requests and and ask for something all at the same time,
> > > > MySQL spawns many child proccess
Can someone help me??
I have been trying out MySQL beginning in June of 2001.
I use Caldera Linux and have a 4 machine LAN.
The Lan includes 3 Linux and 1 WinNT install.
I compiled the Source and installed version: 3.22.32-log on
all machines. This runs fine but I was needing the newer
features o
We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
q
I manually entered into my database several rows with high values in the
auto-increment column. I subsequently deleted the high value rows. I now
am trying to reset the auto-increment. How do I reset it to the Max of
the currently existing values?
-matt
[EMAIL PROTECTED]
==
We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
q
I can´t start Mysql (I use Slack and compiled mysql). I´ve
followed all instructions in INSTALL text, and i´ve got this in the .err file:
010914 16:19:02 mysqld started
010914 16:19:02 /usr/local/mysql/libexec/mysqld: Can't create/write to
file '/usr/local/mysql/var/darkstar.pid' (
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
On Sun, Sep 16, 2001 at 06:58:05PM -0700, Michael McConnell wrote:
>
> > On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote:
> > >
> > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I
> > > connect 400 requests and and ask for something all at the same time,
> > >
> On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote:
> >
> > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I
> > connect 400 requests and and ask for something all at the same time,
> > MySQL spawns many child proccess (hundreds and hundreds). As a
> > result of al
I suggest:
select count(*)
from table your_table_name
group by team
;
The MySQL documentation at www.mysql.com certainly contains good
documentation regarding the "group by" clause within it. However,
it doesn't really provide a motivation for using it... nor should
it. It is d
Use the DISTINCT keyword and count the returned rows
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 9:08 AM
Subject: surely an easy quick one
> Hello again :o)
>
> This is surely an easy quick one but my brain wont wo
On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote:
>
> I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I
> connect 400 requests and and ask for something all at the same time,
> MySQL spawns many child proccess (hundreds and hundreds). As a
> result of all these proce
On Sun, Sep 16, 2001 at 05:59:48PM -0500, Deryck Henson wrote:
>
> > Using what programming language?
>
> ASP
That's a framework (or API), not a language.
(see Paul's answer anyway)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (40
something like this (assuming vbscript):
Dim pos = 1
Dim cnt = 0
Do
pos = InStr(field, "", pos)
If pos > 0 Then
cnt = cnt + 1
pos = pos + 3 'get past the current one
Else
break
End If
Loop
'at this point, cnt holds y
I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400
requests and and ask for something all at the same time, MySQL spawns many
child proccess (hundreds and hundreds). As a result of all these processes
the system essentailly hangs (Loadavg of 588 525 310)
Does anyone know
At 5:59 PM -0500 9/16/01, Deryck Henson wrote:
>ASP
You tell us, then. MySQL doesn't have a function to count the number
of instances of a substring within a string. At least I don't
think it does. Does ASP have some kind of function for that?
If so, you can run a SELECT that looks for records
Certainly I understand how the deadlock can occur, but the question is why
is this acceptable behaviour? Is the application developer expected to
handle this case? If so, how? and shouldnt this be included in the manual
under BDB problems? If Im supposed to wrap _every_ sql call I make to a BDB
ta
ASP
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, September 16, 2001 5:45 PM
Subject: Re: How to count the number of ,br>'s in multiple recor
On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote:
>
> How do I count the number 's in each record in a field?
Using what programming language?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
How do I count the number 's in each record in a field?
Like this situation:
Johnny has INSERTed data that looks like this:
'Hi mom,
How are you?'
Then he does it again
'Hi mom,
How are you?'
He now wants to count the number of 's in all of the records he has
inserted all together from one
In working with some non profit groups I need to be able to send a complete
program that is installed and ran fairly easy.
To me MySQL is easy in most cases but to someone not familiar with it it can
be a daughtening task. Is there a way to send a setup program using MySQL?
Most of the time it's j
Does anyone have an opinion about the following? Are people using decimal
type fields? Is it important for the database to allow only allowed data?
>From http://www.mysql.com/doc/N/u/Numeric_types.html
The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as
permitted by the
At 7:21 PM + 9/16/01, Jonas Larsson wrote:
>Hi,
>
>By looking in the documentation and the FAQ I can't find out how one
>should do to share passwords (in e.g. MD5 format) between UNIX (e.g.
>Linux) and MySQL.
>
>I like to setup a MySQL database for 20 of my users on a Linux box
>and it woul
Hello, Miguel!
I have Paradox and copy Paradox tables to mySQL all the time. Just use the "copy
table"
function. This is assuming you have installed the MySQLODBC and have created an ODBC
mySQL DSN. Most all data types will copy correctly. You will have to alter the tables
to recreate the ke
Hi,
By looking in the documentation and the FAQ I can't find out how one should
do to share passwords (in e.g. MD5 format) between UNIX (e.g. Linux) and
MySQL.
I like to setup a MySQL database for 20 of my users on a Linux box and it
would be nice if they could retain their UNIX passwords. Is
Cancel this, I spotted the problem, forgot the format(..,2);
This query works as expected:
select format(sum(p.badcheck)+ (count(p.badcheck)*-15),2) as Badcheck
from payout p,payhistory ph
where ph.paydate between '2001-09-20' and '2001-09-30'
and (p.payid = ph.payid and p.badcheck != '0.
I've been trying to figure out where I might be going wrong with this SQL
syntax:
select format(sum(p.badcheck)+ (count(p.badcheck)*-15)) as Badcheck
from payout p,payhistory ph
where ph.paydate between '2001-09-20' and '2001-09-30'
and (p.payid = ph.payid and p.badcheck != '0.00')
MySQL said:
Hi,
I've just downloaded and install mySQL on my server but only seem able to
connect to the server across my network if the server is connected to the
internet. Any ideas why and how to stop it. btw I'm running windows.
TIA
Alex
---
another oracle dba <[EMAIL PROTECTED]> wrote:
> Can someone recommend an intro MySQL book. I'm looking for a
> book with info on MySQL
Like you I too have come from an Oracle background to Mysql. Two main
sources of information as far as I'm concerned:
1. The MySQL manual that comes with the
Hi,
> Is their another gui I could use to populate a mySQL database?
my personal opinion - the best MySQL GUI by far I've seen
is the EMS MyManager: http://ems-hitech.com/mymanager/
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/
Hi all,
Can anyone point me to a good Macromedia Ultradev Extension for live
connection to MySQL?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
Greetings
I teach beginning programming to High School students at Pasco High in
Pasco, WA.
I recently went to receive some training at the Oracle Internet Academy
in California and
found Oracle to be a big stretch for me and my students.
We've downloaded MySQL and the MySQL client.
We would
Hi,
I encounter a problem with a new freshly installed server : it seems
MySQL-4.0 doesn't want to create more than 254 threads.
Once I have reached this number, MySQL displays this error :
ERROR 1135: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult
Hello everybody.
Excuse my english, please.
I have several computers in my network.
Every minit I give from 2 to 10 commands "INSERT INTO ..." from each host
to mysql server. From time to time (1 or 3 ones per month) i give errror
from clients. This error is "Can't connect to host...". Why I give
Dana,
if you have page level locking, you can easily
get a deadlock from an atomic insert done as
a single transaction, and another user doing
an atomic select in another single transaction.
It happens this way:
User A User B
insert recordselect record from second
42 matches
Mail list logo
