Hi.
My system is Slackware 9.1.
MySQL is the default version installed on Slackware cdrom while system
installation, so I hope all the path are ok :)
Then launched mysqld_install_db... but when I try to startup the server
an error occured wrote in /usr/local/mysql/ginlemon.err
like this: 3:49:08
Anyone any idea how I could rewrite this as a join - all the indexes are in
place and each of the components of this work fine - its only when the
combined subqueries are passed to the root query does it appear to go wrong
(Takes around 1.5 mins to complete and causes 100% processor utilisation
whi
Lorenzo Rossi <[EMAIL PROTECTED]> wrote:
> Hi.
> My system is Slackware 9.1.
> MySQL is the default version installed on Slackware cdrom while system
> installation, so I hope all the path are ok :)
> Then launched mysqld_install_db... but when I try to startup the server
> an error occured wrote
Hi Ken,
you might try:
SELECT s.PROJID,s.PROJECTNAME
FROM S_PROJECTREGISTER s
INNER JOIN SL_PROGPROJ l ON s.PROJID = l.PROJID AND l.SNAPSHOTID = 56
INNER JOIN SL_PORTPROG p ON l.PROGID = p.PROGID AND p.SNAPSHOTID = 56
AND p.PORTID IN (100994,100996)
WHERE s.SNAPSHOTID = 56
AND s.PROJECTS
Lianghwa Jou <[EMAIL PROTECTED]> wrote:
>
> Mysql seems to insists that all tables must be locked if one table is
> locked in a select statement. Why ?
>
> For example-
>
> lock tables A WRITE, B WRITE;
> select * from A, B, C where A.id=B.id and A.id=C.id;
>
> Mysql will complain that table C
Hello All!
After we converted our tables from MyISAM to InnoDB the database
became very slow!
The same database on another machine on MySQL 3.23.58 works very good.
The machines are identical, my.cnf files are the same.
What can be the reason of such slow performance?
Thank you!
Best regards, An
I'm running:
mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686)
ps says I'm running mysql-max
mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00
/usr/sbin/mysqld-max
that *should* support stored procedures, shouldn't it?
but this fail
create procedure pippo
begin
select 1
Hi,
I would like to save a binary file into a mysql database, for later being
able to use the file. I am using a perl interafce. Is this at all
possible???
And would it be possible to then read that file from a c++ interface?
would be greatful for any help/advices!
Isa
__
Hi,
> I'm running:
> mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686)
> ps says I'm running mysql-max
> mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00
> /usr/sbin/mysqld-max
>
> that *should* support stored procedures, shouldn't it?
As far as I know, MySQL 5 support st
Hi,
I have a perhaps simple problem, but it's a problem for me:
I have made the following GRANT statement:
mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED];
Query OK, 0 rows affected (0.01 sec)
But when I want to REVOKE the GRANT I get the following syntax error:
mysql> REVOKE ALL ON ser.* TO [EM
On Tue, 9 Mar 2004 10:52:38 +0100
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> > I'm running:
> > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686)
> > ps says I'm running mysql-max
> > mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00
> > /usr/sbin/mysqld-max
> >
> > that
* Franz Edler
> I have a perhaps simple problem, but it's a problem for me:
>
> I have made the following GRANT statement:
> mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED];
> Query OK, 0 rows affected (0.01 sec)
>
> But when I want to REVOKE the GRANT I get the following syntax error:
>
> mysql
In order to get the max performance from our servers we're reading every bit
we can lay our hands on about performance tuning.
In this document:
http://www.phpconference.de/2003/slides/business_track/kneschke_webserver-performance-tuning.pdf
(it's in German), it says on page 9 that MySQL 4.1.x on 3
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> On Tue, 9 Mar 2004 10:52:38 +0100
> "Martijn Tonies" <[EMAIL PROTECTED]> wrote:
>
>> > I'm running:
>> > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686)
>> > ps says I'm running mysql-max
>> > mysql21397 0.0 1.7 71216 16064 pts/8 S
Yes, it's possible. Just make sure you quote it (see the Perl DBI docs for
the quote method) before you insert it.
j- k-
On Tuesday 09 March 2004 12:49 am, Isa Wolt wrote:
> Hi,
>
> I would like to save a binary file into a mysql database, for later being
> able to use the file. I am us
Hello,
I am building a web page using Windows 2000 Server, IIS 5.0, ASP (with
vbscript) and MySQL database with MySQL Connector/ODBC. The content of this
web page is in Spanish thus the database will contain letters with Spanish
accents. My problem is that the Spanish characters are not displ
On Tue, 09 Mar 2004 12:36:30 +0200
Victoria Reznichenko <[EMAIL PROTECTED]> wrote:
> 5 is a number of version. MySQL-Max is a name of MySQL server, where
> Max means that this MySQL server supports InnoDB and BDB storage
> engines.
So this make MaxDB another product
> > Could anyone post a corre
hi listers
how would i determine the association between the id from mysqladmin processlist to a
pid?
what i'm after is that i notice some of the mysql threads have a high cpu utilization.
i see this using top (on a linux box). i would like to know which user/program is
responsible for tuning
Hola,
special characters contained on a web page should be replaced by
special tags for a correct display,
for example, the ó in the word Supervisión should be replaced by
Ó ( You should send SupervisiÓn to the browser )
I don't know ASP, I use PHP, and PHP has a funcion, called
htmlspecial
> correctly on my web page. Querying the database with the mysql client I
see
> that the character ó in the word Supervisión is ok but when my web app
> queries the database the web page displays Supervisi¢n. The ó character
> seems to be switched for the ¢ character. Does anyone know why this i
I've got a server with 24 gigs in it and it works just fine. About 3 with 8
gigs and a few with 2 gigs. All running 4.1.1. And all of them run without
any problems on Xeon's with Hyperthreading.
Donny
> -Original Message-
> From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
> Sent: Tuesd
Can you supply us with an example? Some explain plans to corroborate your
reported slowness.
-Original Message-
From: Andrey Chernyh
To: [EMAIL PROTECTED]
Sent: 3/9/04 3:35 AM
Subject: Performance problem with 4.0.18
Hello All!
After we converted our tables from MyISAM to InnoDB the data
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
SELECT ...
FROM positionReports p
Yes. There's a limit.
Start mysql with --big-tables. I think there's a finer way of doing it,
just don't remember what it was ;)
P
"Donny Simonton" <[EMAIL PROTECTED]>
03/09/2004 08:00 AM
To: "'Jigal van Hemert'" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
cc:
S
Hello,
I only have one server available to be set up to handle a lot of data. I
have looked through some documentation, and am a little confused. So I
thought I would get the opinion of someone who has used this stuff.
First will I see a performance different on a 2 GHz Intel w/ 500 MB Ram,
r
Peter,
I have never heard of such a limit and I have been using it for a while.
And --big-tables, which BTW, you can't easily search for on mysql.com,
because of the minimum 4 characters in full text indexing, says this:
--big-tables
Allow large result sets by saving all temporary sets on file.
filter: select, mysql
Solaris 3.23.40 connections using perl, jdbc, odbc.
Yesterday, we experienced a rare mysqld failure where all connections
where in the state="Opening table". Normally our 200+ connections
are in state="sleep". The Time field from command
"show processlist"
showed each co
Mark Swanson <[EMAIL PROTECTED]> wrote:
>
> I am having replication troubles with 4.0.15. Some info:
>
> mysql> show slave status;
> | www.x.com | replicon| 3306| 60| ns1-bin.001 |
> 16958428| linux-relay-bin.011 | 623915| ns1-bin.001
>
I'm not sure if this is a bug or a user failure, so I'm going to ask here
before doing anything rash.
I'm trying to classify a single field using the IN() expression into two
groups:
IF(t2.status IN(2,3,4), "open", "closed")
I'd like to GROUP those together so I can COUNT them.
When I try
Donny-
While I appreciate your bluntness, I did have this issue a time back with
4.1.x.
In your email, the reference to big-tables stated that it prevents table
fulls. This would dictate
that it does affect limits, or working around them , likely a limit set
forth by temporary tables (in memo
Hi all
Is it possible to span a database transaction across
multiple CGI scripts? That is, start transaction and
lock some records in one CGI script and update and
commit in another CGI script.
Here is an example: I have a accounts database. Only
one user should edit a given account at any given
Peter,
There is no 1 gig limit that I am aware of. I have been using MySQL 4.1
since the day it was released. And when 4.1.1 came out I switched about
half of our machines to using it, and when 4.1.2 comes out in the next week
or so, I will switch our stuff that is using 4.1.x to that as well. W
Andy,
Your first suggestion hit the nail right on the head. Using the column
number does the trick.
Your second entry was incomprehensible to me, and to mysql as well. It
reports an error. (Frankly, if that worked it would be so much magic I'd
have to uninstall MySQL for being smarter than me. :-
"Austin Hastings" <[EMAIL PROTECTED]> wrote:
> I'm not sure if this is a bug or a user failure, so I'm going to ask here
> before doing anything rash.
>
> I'm trying to classify a single field using the IN() expression into two
> groups:
>
>IF(t2.status IN(2,3,4), "open", "closed")
>
> I'd l
Check this article:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Port code/design to perl or whatever client language you want.. mysql
could care less once it's got the data (correctly)
On Tue, 9 Mar 2004, Isa Wolt wrote:
> Hi,
>
> I would like to save a binary file into a mysql databas
"Bluemel, Marco" <[EMAIL PROTECTED]> wrote:
> I have a problem with mysql 4.0.18 on WindowsXP
> I set the lower_case_table_names=2 as it is mentioned for windows
> t the mysql website.
>
> (before I'm using version 4.0.15 and had set it to 0)
> so the tablenames should be stored in this case as I w
Hi,
I'm new to mysql and I just installed 4.1.1 and ran into trouble combining a
subquery and 'order by'. I guess the 3 queries below show my problem
mysql> SELECT host,facility,priority,date,time FROM logs WHERE host=(select
ip from hostip where host='ams602.avctr.gxs.com');
+---+---
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> What error message did you receive? Your query worked fine for me:
When I say:
SELECT IF(t2.status IN(2,3,4), "open", "closed") t2st, COUNT(t2st)
FROM tasks t2
GROUP BY t2st;
I get:
#1054 - Unknown column 't2st' in 'field list
I'd never actually tried that before, it definitely seems like a bug to me.
SELECT *
FROM WordScoreTemp
WHERE word = (
SELECT word
FROM Word
WHERE word = 'mysql' )
The above works fine.
SELECT *
FROM WordScoreTemp
WHERE word = (
SELECT word
FROM Word
WHERE word = 'mysql' ) order by score;
Hello,
I'm trying to determine the best way to optimize the query below. Right now
it is taking around 9mins and we need it to take no more than 30 seconds (we
can get it under 30s on MS SQL):
explain select count(distinct(phone)) as TOTAL
FROM speedlink
WHERE
county in('247','085','145','285',
"van der Scheun, Willem (GXS)" <[EMAIL PROTECTED]> wrote:
> I'm new to mysql and I just installed 4.1.1 and ran into trouble combining a
> subquery and 'order by'. I guess the 3 queries below show my problem
>
> mysql> SELECT host,facility,priority,date,time FROM logs WHERE host=(select
> ip from h
Chris,
Is it faster if you remove the 'IS NOT NULL'? I know that's not the results
you want, but we have found that is NOT NULL will do a full scan. But we
normally use it with a join. Since you are using one table, I'm not sure
how it would affect it.
Donny
> -Original Message-
> From
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF> I'm trying to determine the best way to optimize the query below. Right now
CF> it is taking around 9mins and we need it to take no more than 30 seconds (we
CF> can get it under 30s on MS SQL):
CF> | 1 | SIMPLE | speedlink |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
The docs aren't clear on this. Is mysql_close needed on a MYSQL struct
previously initilized with mysql_init after a failed mysql_real_connect ?
(which returned NULL)
- --
Mihai RUSUEmail: [EMAIL PROTECTED]
G
Using v4.0.15 on WinNT under Apache.
For my sins, the client has insisted on creating a page counter!
The fields are to be CounterCode (Varchar 10), CounterValue (Int 10) and
CounterStartDateTime (DateTime).
Setting up the table is no problem. However, client wants to have the
CounterStartDat
> UPDATE Table SET CounterValue = CounterValue+1, CounterStartDateTime =
> (IF CounterStartDateTime IS NULL, Now())
>
> without success.
It looks like you just have the syntax wrong. Try:
UPDATE Table SET CounterValue = CounterValue+1, CounterStartDateTime =
IF(CounterStartDateTime IS NULL, N
> Chris,
> Is it faster if you remove the 'IS NOT NULL'? I know that's not the >
> results
> you want, but we have found that is NOT NULL will do a full scan. But
we
> normally use it with a join. Since you are using one table, I'm not
sure
> how it would affect it.
>
> Donny
This is an intere
If it was me writing the code, I'd use two different update statements:
a) an UPDATE to initialize the DateTime to Now() and set the counter to 1
when the page is first hit
b) another UPDATE to increment the counter on all of the remaining hits
Something like this (assuming Java is your programmi
Thanks, Jeremy
What I actually needed was:
UPDATE Table
SET CounterValue = CounterValue+1,
CounterStartDateTime =
IF(CounterStartDateTime IS NULL, Now(), CounterStartDateTime)
This prevents it going back to NULL if the value is already not NULL.
Thanks again.
Terry
--Original Messa
Hi,
I've recently upgraded from 4.0.8a to 4.0.18, and am running into a strange
error in the JDBC connector. If the DB connection is unused for a period of
time (don't konw the minimum amount of time, but 8-12 hours defintiely
triggers the problem), I get the following error msg in my stack:
**
Hello Terry,
Tuesday, March 9, 2004, 5:11:00 PM, you wrote:
I know you have some solutions to the original problem already, but I
just wanted to make one small observation:
TR> The fields are to be CounterCode (Varchar 10), CounterValue (Int 10) and
TR> CounterStartDateTime (DateTime).
Using a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eric B. wrote:
> Hi,
>
> I've recently upgraded from 4.0.8a to 4.0.18, and am running into a
strange
> error in the JDBC connector. If the DB connection is unused for a
period of
> time (don't konw the minimum amount of time, but 8-12 hours defintiel
See below:
--Original Message-
> If it was me writing the code, I'd use two different update statements:
>
> a) an UPDATE to initialize the DateTime to Now() and set the counter to
> 1
> when the page is first hit
> b) another UPDATE to increment the counter on all of the rema
Why does it only use the one index?
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 11:00 AM
To: [EMAIL PROTECTED]
Subject: Re: Optimizing Queries
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF> I'm trying to deter
See below:
--Original Message-
> Hello Terry,
>
> Tuesday, March 9, 2004, 5:11:00 PM, you wrote:
>
> I know you have some solutions to the original problem already, but I
> just wanted to make one small observation:
>
> TR> The fields are to be CounterCode (Varchar 10), Count
Hello Chris,
Tuesday, March 9, 2004, 6:15:56 PM, you wrote:
CF> Why does it only use the one index?
It will evaluate the best index to use for the query and if all you
have are single-field indexes, it can only select one of those.
From the MySQL manual:
"If a multiple-column index exists on c
Hello Terry,
Tuesday, March 9, 2004, 6:25:00 PM, you wrote:
TR> Good point, Richard. I was perhaps in a little bit too much of a hurry
TR> putting that together, and didn't even consider that!
No worries. One other thought that occurred to me that might help with
the original problem is as follo
> Hello Terry,
>
> Tuesday, March 9, 2004, 6:25:00 PM, you wrote:
>
> TR> Good point, Richard. I was perhaps in a little bit too much of a
> > hurry
> TR> putting that together, and didn't even consider that!
>
> No worries. One other thought that occurred to me that might help with
> the o
Hi Donny,
What server hardware do you use to support 24G RAM over 32-bits limit?
Please advise your choice of hardware and software configuration
and how long and reliable it works for you on hyperthreaded Xeons?
Best regards,
Igor
ua3qrz
-Original Message-
From: Donny Simonton [mailt
I am new to mysql and am converting an existing program. I have
encountered what appears to be a problem with bigints
I have a large integer number (milliseconds since 1970) which is 13
digits. So I tried to store it in a table as a bigint type. Storing
works fine. When I try to retrieve it
I am a user of Microsoft Sql Server and use very much the function Datediff
(interval, fecha1, fecha2) to extract differences between two dates, in
years, days, months, hours, etc
I am a beginner with MySql and i can't see the way to do this function ..
How can I extract for example difference of
I am new to mysql so this may be an obvious mistake on my part...
I am using JDBC to acess some mysql data tables. I am having trouble
with the following code:
Statement s;
ResultSet rset;
longcorrectedclock;
s = conn.createStatement();
rset = s.executeQuery("Sel
If you turn on highmem support you can easily get 24gigs of memory. I think
with 2.6, it's up to 64 gigs. But there are even patches for 512gigs. Not
sure if those patches work, but the highmem support works just fine.
Donny
> -Original Message-
> From: Igor Dorovskoy [mailto:[EMAIL
Hello,
Can you give an estimate of when 5.0 will be released for production?
Thanks,
Matthew Son
VBMySQL.com is pleased to announce the launch of a new projects page at
http://projects.vbmysql.com.
The first (and flagship) project is VBMySQLDirect. VBMySQLDirect is a
new MySQL C API wrapper written by longtime site contributor Robert Rowe.
VBMySQLDirect is a fork of the MyVbQl API and is a
Look it through
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Gabriel Alessandria wrote:
I am a user of Microsoft Sql Server and use very much the function Datediff
(interval, fecha1, fecha2) to extract differences between two dates, in
years, days, months, hours, etc
I am a beginner with MySql and i can't see the way to do this function ..
How can I extract
Hi guys,
I'm new to MySQL, it's been just few days since I've installed it and started playing
with it.
I'm migrating web application from another database which gives us too many problems.
So far I've
successfully moved the structure and data across and running field tests.
What surprised me a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Randall Cayford wrote:
> JDBC driver: mysql-connector-java-3.0.11-stable-bin.jar
>
>
> Randall Cayford wrote:
>
I am new to mysql so this may be an obvious mistake on my part...
I am using JDBC to acess some mysql data tables. I am h
[EMAIL PROTECTED] wrote:
>> Look it through
Can the list administrator figure out who this moron is and remove him from
the list?
Jon
--
--
FutureSoft, Inc.
12012 Wickchester Lane, Suite 600
Houston, TX 77079
If you no longer
The query is running dramatically slower than the MyISAM query, sometimes
even causing mysql to freeze for a while. I searched this list and found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else I would get this exact problem. Has
th
Thanks for the reply
What I need to know is if there is a way to prevent the server from geting
stuck after a missbehave query like the example is sent?
The problem is all other clients go so slow that no work can be done and
no new connections can be made.
The server is a DUAL XEON 3GH 1GB RAM,
Hello!
I was just wondering if I am the only one that's having problem
extracting maxdb .tgz file or there is someone else out there facing
similar problem.
tar zxvf filename.tgz or
gunzip filename.tgz , tar xvr filename.tar or
zcat filename.tgz | tar xvf -
should work, but i tried all and i
Matthew,
- Original Message -
From: ""Matthew Son""
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 09, 2004 10:26 PM
Subject: mysql 5.0 production release
> Hello,
>
> Can you give an estimate of when 5.0 will be released for production?
my guess is that 4.1 will be declared '
Here is a log of query times I made when a certain page is loaded that uses
php and mysql, does mysql 4 do some sort of scheduled maintenance I am not
aware of?
2004/03/08 16:11:27OK, 77569 bytes0 seconds
2004/03/08 16:11:37OK, 77575 bytes0 seconds
2004/03/08 16:13:31OK, 77569
Michael Stassen said:
>
> Gabriel Alessandria wrote:
>
>> I am a user of Microsoft Sql Server and use very much the function
>> Datediff (interval, fecha1, fecha2) to extract differences between two
>> dates, in years, days, months, hours, etc
>>
>> I am a beginner with MySql and i can't see the wa
I would like to do the following:
mysqldump -w "users.user_id=enews.user_id" sotx users
> c:/enews_users.sql
Ideally this would dump all records in table users
where the user_id field value is also present in the
enews table. Is this possible?
TIA,
Dan
--
MySQL General Mailing List
For list a
We have a table with a Date Time field and we need to update only the date
portion of that field.
We have table a with field Foo with value '2004-01-01 12:15:00' and a date
'2004-03-01' and we need to change the date portion of Foo to the date and
leave the time part alone.
So Foo would change
Hello Eric,
Tuesday, March 9, 2004, 11:46:23 PM, you wrote:
ES> We have a table with a Date Time field and we need to update only the date
ES> portion of that field.
ES> We have table a with field Foo with value '2004-01-01 12:15:00' and a date
ES> '2004-03-01' and we need to change the date por
Hello MYSQL Genii,
I am trying to run a query that returns results to a .csv file using mysql's 'INTO
OUTFILE'.
The problem is whenever I write the file I lose my the field names for each
column. For example, when I run the query at command line mysql:
mysql> SELECT distinct count(*), Product FRO
Richard Davey wrote:
Hello Eric,
Tuesday, March 9, 2004, 11:46:23 PM, you wrote:
ES> We have a table with a Date Time field and we need to update only the date
ES> portion of that field.
ES> We have table a with field Foo with value '2004-01-01 12:15:00' and a date
ES> '2004-03-01' and we need t
Hello Peter,
Wednesday, March 10, 2004, 12:16:51 AM, you wrote:
PB> But that is adding two days, the original query was to add two
PB> months, so presumably it should be "INTERVAL 2 MONTH" - but beware
PB> that MySQL does some
It should, sorry, I'm too used to the UK date format (even though I
k
Ian Pushee wrote:
I am running mysql version 3.23.49 on a Debian Linux box.
Recently (about a month ago) I noticed that alot of my databse access
scripts were failing intermitently. It was anoying, but I have only now
gotten the time to look into the problem. It turns out that my mysql
server p
Rich,
Thanks for the email. I created a multi-field index using the fields that
are in the query and the query only took 0.91 seconds. That's better than 9
minutes and definitely under 30 seconds.
Thanks.
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Tue
And Chris, maybe now you can get rid of some of those single indexes and
drop the entire size down quite a bit.
Donny
> -Original Message-
> From: Chris Fossenier [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 6:48 PM
> To: 'Richard Davey'; [EMAIL PROTECTED]
> Subject: RE: Opti
Hello Chris,
Wednesday, March 10, 2004, 12:48:02 AM, you wrote:
CF> Thanks for the email. I created a multi-field index using the fields that
CF> are in the query and the query only took 0.91 seconds. That's better than 9
CF> minutes and definitely under 30 seconds.
Glad to hear it.
Farewell MSS
I've tried about 20 different variations with no luck
except when i modify the where statement to use only
one table. Then it works fine but it's not the results
i want. I was suspecting exactly what you said: you
can only refer to one table, and the first one you
specify at that. I was trying to a
Michael Bacarella wrote:
We recently started getting "Can't create thread" errors since
switching to Debian.
On Red Hat 8.0 we were able to spawn more than 400 mysql threads
and never encountered this error. mysql 3.23.56 compiled from
source, stock kernel. (2GB of RAM)
Now we get it all the time
Heya,
Check the permission on that directory.
Paul
At 12:36 AM 3/9/2004, Lorenzo Rossi wrote:
Hi.
My system is Slackware 9.1.
MySQL is the default version installed on Slackware cdrom while system
installation, so I hope all the path are ok :)
Then launched mysqld_install_db... but when I try t
I have used access in the past and now I have started using MySQL. I have customer
table, customer order table, customer order detail table. How would I make sure that
when a particular customer log-in he/she sees only the account that is set-up for
them. What confused me is that MySQL has a dat
Heya,
Those are the default databases that comes with the setup. the "mysql"
database holds info on mysql accounts. the "test" is an empty
database. You should create a new database "CREATE DATABASE customers"
then "use customers"... after that... you can setup the tables you mentioned.
Goo
Donny Simonton wrote:
Peter,
There is no 1 gig limit that I am aware of. I have been using MySQL 4.1
since the day it was released. And when 4.1.1 came out I switched about
half of our machines to using it, and when 4.1.2 comes out in the next week
or so, I will switch our stuff that is using 4.1
Thank you for the kind response. May be I did not clearly ask the question.
The user table in mysql database is used to set-up a user and password. Once
I set-up my tables (customer, customer orders, customer order details, etc)
in say abc database what will I have to do to make sure when customer
Hi Tom,
You can't. MySQL's own thread ids are sequential. The OS pids are
random. There's no connection between them. Besides, mysqld is really
only running in a single "real" process, it's just that LinuxThreads
shows each thread as a "process."
Matt
- Original Message -
From: "To
Hi,
Is there any function for MySQL database to do automatic backup?
Let say, i can set the time, that MySQL will automatic backup between
7.00pm-8.00pm everyday.
Thank you very much.
regards,
florence
Thank you very much.
regards,
florence
Y! Asia presents Lava
cron schedule it ?
> Hi,
>
> Is there any function for MySQL database to do automatic backup?
> Let say, i can set the time, that MySQL will automatic backup
> between 7.00pm-8.00pm everyday.
>
> Thank you very much.
>
>
> regards,
>
> florence
>
>
> Thank you very much.
>
Cliff wrote:
The query is running dramatically slower than the MyISAM query, sometimes
even causing mysql to freeze for a while. I searched this list and found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else I would get this exact pr
Sturgeon, Jon wrote:
[EMAIL PROTECTED] wrote:
Look it through
Can the list administrator figure out who this moron is and remove him from
the list?
Jon:
This so-called "moron" is Miguel Soloranzo - the guy in charge of MySQL Windows
builds. So blocking his posts to the list would be a bad ide
Sasha Pachev wrote:
Cliff wrote:
The query is running dramatically slower than the MyISAM query,
sometimes
even causing mysql to freeze for a while. I searched this list and
found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else I
They most probably got it from this list, i too have had virus emails
sending emails with my email and name in the header !! but i dont have a
virus !!
> Sturgeon, Jon wrote:
>> [EMAIL PROTECTED] wrote:
>>
>>
Look it through
>>
>>
>> Can the list administrator figure out who this moron is and
1 - 100 of 110 matches
Mail list logo
