> How do I Create a Database with Userid and Passwords. Eg.
> CREATE DATABASE USER. Such that I am able to login and access the
> database using this userid and password.
Check out the manual. Search for MYSQLADMIN and GRANT.
Much other info can be found at www.devshed.com
Bye,
Hi, we are testing out MySQL, too se if it might meet our needs.
We are currently having problems returning Text fields from the database through ODBC.
System:
Win NT 4.0
Visual Basic 6.0 Ent.
RDO (Remote data objekts, must use!)
MySQL servers both on W32 and Linux
The first record in the result
> In this particular case it doesn't. I need to ensure that each URL
> exists only once. And it is entirely possible to have a URL with 300
> characters in it.
Ok, how about encoding it? Come up with a simple compression algo that
uses 6 bits for every 8 bits, allowing for a-z, A-Z, slashes, do
On Tue, Jan 30, 2001 at 01:09:14AM +0100, [EMAIL PROTECTED] wrote:
> >Description:
> Can't start mysqld. In /var/mysql/.err, there is
> a line saying "getpwnam: Undefined error: 0"
> >How-To-Repeat:
> /usr/local/bin/safe_mysqld
Hm.
What user have you configured MySQL to run as
On Tue, Jan 30, 2001 at 03:20:27PM +0800, Sam Wong wrote:
> Personally speaking, if the index > 256, it will lost the meaning of
> indexing...
Perhaps.
In this particular case it doesn't. I need to ensure that each URL
exists only once. And it is entirely possible to have a URL with 300
characte
On Sun, Jan 28, 2001 at 10:47:21PM -0800, Bob Cottrell wrote:
>
> Hello there,
>
> We have a number of Sun sparcs connected to 2 NetApp file servers,
> and are currently using 1 sparc running mysql with the databases
> residing on one of the NetApps. I would like to run a 2nd sparc
> mysql serv
Personally speaking, if the index > 256, it will lost the meaning of
indexing...
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:06 PM
Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without
On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote:
>
> ---snip---
>
> mysql> alter table Headlines modify Url TINYTEXT NOT NULL;
>
> ERROR 1170: BLOB column 'Url' used in key specification without a key length
Oh, okay. Now I understand.
The max key length is 256, so I'd need
from the MySQL site is MySQLGUI.
will this run on OS X pb?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
>Description:
Can't start mysqld. In /var/mysql/.err, there is
a line saying "getpwnam: Undefined error: 0"
>How-To-Repeat:
/usr/local/bin/safe_mysqld
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis: Can't start mysqld
>Severity:
I have no idea what this error is trying to tell me...
I have a table called "Headlines" which contains a VARCHAR(255) field
called "Url". I need to store larger values in the "Url" column, so I
want to convert it to TINYTEXT.
---snip---
mysql> alter table Headlines modify Url TINYTEXT NOT NULL
Hi,
How do I Create a Database with Userid and Passwords. Eg. CREATE DATABASE
USER. Such that I am able to login and access the database using this userid and
password.
Thanks
Richard
On Mon, Jan 29, 2001 at 04:40:53PM -0800, Ricardo Kleemann wrote:
> Hi everyone,
>
> I have twice posted a problem with replication and have since seen 2
> or 3 others post with similar replication questions and problems.
You've certainly been on the list long enough to witness the volume of
mai
Hi,
A friend has told me that there is port on which mysql allows anyone to
access mysql without authentication, is that right?
If yes, what is the port number ?
Regards,
--
Aftab Rashid
Manager Systems
Beaconet
164 P, Gulberg II,
Lahore, Pakistan
+92-42-11122
http://www.beaconet.net
Aftab Rashid wrote:
>
> Hi,
>
> A friend has told me that there is port on which mysql allows anyone to
> access mysql without authentication, is that right?
> If yes, what is the port number ?
>
> Regards,
>
> --
> Aftab Rashid
> Manager Systems
> Beaconet
> 164 P, Gulberg II,
> Lahore, Pakis
This is hopefully a simple problem.
I have just upgraded my server from RH 6.2 to RH 7.0 and have upgraded the
MySql as well. Having sorted out the missing Perl modules I have finally
arrived at the point where the following error is returned by Perl to the
browser:
Can't connect to local MySQL
Hmmm... Looks like you over did the query to me. This should work.
SELECT o.OrderID, c.CustomerFirst, c.CustomerLast, s.SalesRepFirst,
s.SalesRepLast
FROM Orders as o, Customers as C, SalesReps as s
WHERE O.CustomerPhone=c.CustomerPhone AND o.SalesRepID=s.SalesRepID
of course you don't need the
Don't know much about the licensing but I would say you would need to at
least purchase basic support, which you can then charge to your customer.
However, the customer 50 to 100 times cheaper than Oracle, depending on the
support you purchase.
If you are going to be using a unix based system wit
Hi all. I'm having a little trouble with this query.
**Table 1 (Orders) **
OrderID SmallInt
OrderStatus VarChar(20)
CustomerPhone VarChar(10)
SalesRepIDSmallInt(11)
**Table 2 (Customers)**
CustomerFirst VarChar(20)
CustomerLastVarCha
If you've upgraded the perl to 5.6.0, you've to reinstall the modules
- Original Message -
From: "Don Hargroves" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:15 AM
Subject: MySQL Perl DBI/DBD
> I have followed the instructions at
> http://
I have followed the instructions at
http://www.symbolstone.org/cgi/dbi/moduledump?module=Msql-Mysql-modules
to install MySQL Perl DBI/DBD which are:
First of all you need to fetch the
archives from any CPAN mirror, for
example
ftp://ftp.funet.fi/pub/languages/per
nope sorry
On Mon, 29 Jan 2001, Ricardo Kleemann wrote:
> Hi everyone,
>
> I have twice posted a problem with replication and have since seen 2 or 3
> others post with similar replication questions and problems.
>
> However I have yet to see ANYONE respond to any of those posts.
>
> I dont u
This site provide the JDBC driver and all the tutorial :
http://www.worldserver.com/mm.mysql/
--Andy--
-Original Message-
From: Vijay Chandra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 4:55 AM
To: '[EMAIL PROTECTED]'
Subject: mysql jdbc drivers
hi
i am trying to use m
Hi everyone,
I have twice posted a problem with replication and have since seen 2 or 3
others post with similar replication questions and problems.
However I have yet to see ANYONE respond to any of those posts.
I dont understand, it feels like we're being totally ignored. Can no one
offer any
I am an independent web developer working on a web based application that I
plan on giving to companies to use to track certain activities. I am
currently developing this application using ASP and VB and integrating it
into an MS SQL server. I have some companies using MS SQL, some using ORACLE
On Sun, Jan 28, 2001 at 11:26:29AM -0500, Lee Jenkins wrote:
>
>
> Very, very cool. What will happen to the licensing and/or price for
> this version?
According to the Press Release, Spring 2001.
And I believe it will be GPL'd. But I could be mistaken.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL P
I'm going to have to answer Yes, and No.
Yes, they can access it.
No, it won't be the best situation. The internet is not very trustworthy,
and having DB's seperated over such large distances accessing instantly is
probably not the best choice. Not to mention that if you have large record
sets
maybe root password is not set...
check root password or login as root without password..
>From: "Artem Koutchine" <[EMAIL PROTECTED]>
>To: "Velamarthy Murthy" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: How to avoid ERROR :1045
>Date: Sun, 28 Jan 2001 15:13:23 +0300
>
>i don't know
Where can we find more information about gemini and when it will be done
exactly (date)?
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
hi:
Do you know where to get the class and their methods documentation of
Mysql++ API,
Regards
Hensen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hello,
I just want to make sure that I can do this but would this scenario work
properly.
I build an sql database and perl interface at site www.siteX.com.
A person on www.siteY.com is going to utilize this tool
The perl interface running on www.siteY.com makes a call to the database
from www.si
Sorry if this is a little late- but at Abriasoft we are currently developing a tool
that can be used for automated backup of your MySQL databases from one or more servers
with the ability to restore from the backups in the event that you need to.
Our tool uses a C daemon and a php web interface
On Mon, 29 Jan 2001, Brian Reichert wrote:
> In pawing though the source for mysql-3.22.32 (our current version
> in production), I noticed in acconfig.h, a macro 'USE_RAID', which
> in term seems to set up the use of .
>
> But, I can't find any documentation for this, and the configure
> progra
I'm wondering if anyone has any experience in setting up MySQL as a backend
to a website with multi-lingual support?
What I'm trying to do is have a web site with a main "gateway" page that
allows a user to choose their language. This will bring them to the actual
content, but in the language of
In the create table documenttation, it explains the USE_RAID, and a few
other options pertaining to it.
Gregg
- Original Message -
From: Brian Reichert <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 4:22 PM
Subject: 'USE_RAID' in mysql-3.22.32?
In pawing tho
On Sat, Jan 27, 2001 at 09:32:56PM +0300, Artem Koutchine wrote:
> Hmm.. So ID is not PRIMARY KEY (not UNIQUE index).. That makes it
> harder. A lot harder. A lot depends now on how many records per ID
> you have there on average. If you you have only, say, 50 ids then
> you'll be slower. Basi
In pawing though the source for mysql-3.22.32 (our current version
in production), I noticed in acconfig.h, a macro 'USE_RAID', which
in term seems to set up the use of .
But, I can't find any documentation for this, and the configure
program doesn't seem to set it one way or another.
What is th
DELETE FROM news WHERE newsdate=DATE_ADD(CURRENT_DATE, INTERVAL -14 DAY)
Above is the code that I would use to do that job. Hope this helps.
-Angela
Thomas Katsampes wrote:
>
> Hello,
>
> I'm trying to figure out the correct syntax for requesting
> the database to
> remove all records older
I have a 6000user DB that has just moved to a new machine. The database
starts up and runs fine for about 2 minutes.
mysqld starts to hit heavy on the CPU bringing IDLE CPU usage down to 0.0
continuesly.
Is there any way to find out what exactly is dragging the database down. I
am sure there i
Hi,
I managed to install the database but where can i find "mysql" in which directory. I
am not being able to find this executable. Did I mess on the installation process.
An early reply will highly appreciated.
Thanks.
Sanjeev Kabra.
hi
i am trying to use mysql database for my application , which is being
developed in java. where can i find jdbc drivers for mysql , and how to
install them, i am using win nt as developement platform. Its not for any
commercial application.
thanks
Vijay
-
create table newtable select * from oldtable where 1<0;
This will solve your problem.
Best regards,
Fábio Ottolini
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 7:06 PM
Subject: How can I create one more table with existing table
am trying to run insert.c script from client directory of mysql source
code. I am using vc++ on windows 2000.
I am getting a list of error message. Please can you help in getting the
script working
Some of the errors are
:\source\include\mysql_com.h(115) : error C2061: syntax error : identifier
did you edit /etc/resolv.conf?
dyu wrote:
> Dear all,
>
> i m running mysql on freebsd webserver and using our own DNS server.
> Everything run fine with database and web serving. However, i m trying to
> change the DNS ip addresses to our isp's DNS server instead of ours on this
> webserver.
--- Forwarded message follows ---
Send reply to: "Bjarne Jensen" <[EMAIL PROTECTED]>
From: "Bjarne Jensen" <[EMAIL PROTECTED]>
To: "John Jensen" <[EMAIL PROTECTED]>
Subject:
Date sent: Mon, 29 Jan 2001 13:17:29 -0
SessionID would do just fine. I suggested UserID simply because then if it
fails to unlock, you know who locked it.
Cal
http://www.calevans.com
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 2:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Do
From: Liu Danyu
Date: Thu, 18 Jan 2001 18:08:37 +0800
I would do the query as
select maker, pc.id
from table1
where pc.id > 2
order by maker;
dear all:
I need some help from you.
The dataset is as follo
Does Mysql can be used in client server envorinment.
Hammad Nasim
New Core Networks
1032 Castro Street
Mountain View, CA 94040
P 650-691-1400
F 650-938-1730
http://www.newcorenet.com
-
Before posting, please check:
http:
Dear all,
i m running mysql on freebsd webserver and using our own DNS server.
Everything run fine with database and web serving. However, i m trying to
change the DNS ip addresses to our isp's DNS server instead of ours on this
webserver. Then i got the following error:
===
Very nice. Recommend to go there, could come a awfull lot of tricks & things
to know there, in a entertaining way.
- Original Message -
From: "Jeff Cordova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 6:54 PM
Subject: New way to learn Mysql?
> I've spent t
Hello,
I'm student in Thailand. I learning about MySQL.
I have questions to ask to you.
I use MySQL version 3.22 have not SHOW TABLE
STATUS Syntax . How I know when table was created
(date and time).
Please contract to me, Thank you.
Mr.
From: Subba Reddy M
Date: Fri, 26 Jan 2001 14:52:29 +0530
Hello MySQL guru,
Please advise me,
on creating new table with existing table structure.
I have tried, how MySQL documentation referred, but unable to get success.
create table newtable select * from oldtable;
This works on 3.23.x
> From: NELSON, GLEN
> Sent: Monday, January 29, 2001 11:19 AM
> To: Mysql2 (E-mail)
> Subject: Install of mysql on AIX fails due to missing module libz.a
>
>
>
> From: t199k01
> To: [EMAIL PROTECTED]
> Subject: [50 character or so descriptive subject here (for reference)]
>
I have decided to implement the "soft-lock" schema below. I cannot use the
userID as the value for the lock. Is there any other unique number that can
be generated that I could use. I am thinking about using a session_ID in
PHP? Any suggestions/Comments??
Randy
-Original Message-
Fro
Hi,
MySQL supports transaction since 3.23, but we have to create BDB table
to benefit transaction. My question is,
Can we start up MySQL in transaction mode for a while rather than all of
time?
Because we're concerned about performance about BDB, do you guys
experiment any positive or negative
Greetings List Dwellers-
A quick question for you. I'm having problems with mysql's large file
support(I think). I'm using kernel 2.4-XFS with my database disk set up
with the XFS journaled file-system. Works fine with large files. Anyway,
I'm using mysql-3.23.32, compiled from source, and i
I am trying to bring up my third mysql server. This one is
MySQL-3.23.32-1.i386.rpm..rpm on a redhat 6.2 base. I was successful in
installing both the server and the host. Look around and every thing
looked cool! Piece of Cake! Then I decided to set up the mysqladmin user
and setup privelidge
Hello,
We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were
able to run configure without a problem but have problem once make is run,
we receive the following errors:
"net.c", line 109.9: 1506-045 (S) Undeclared Identifier net.
"net.c", line 114.18: 1506-045 (S) Undeclare
Hi,
Depending on your platform, there will be a set of directories somewhere
that contain a number of scripts that are run at various times during
reboot.
On Solaris, the main repository for the scripts is /etc/init.d, and scripts
in /etc/rc1.d are run when entering run level 1, /etc/rc2.d for l
Hello All:
I have developed a MySQL/PHP web application that is hosted on a shared
server. I have noticed that when the server is re-started, mysqld is not
automatically re-started.
I have been informed that I need to write a program to be executed by cron
when the server is re-started that run
> > I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I
> > searched the documentation on the site, but it doesn't seem to pertain to this
> > version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can
> > figure out what it might break. Does anyone hav
Nevermind. I see that the manual online has this information. Sigh. It
doesn't do what I want unfortunately.
Best,
Kyle
On Monday 29 January 2001 09:32, Kyle Hayes wrote:
> The manual section on BACKUP does not state what locking behavior the
> command has. Does it lock all the tables at
> > > > [1 ]
> > > > I don't know if any of you people have ever had this trouble, but
> > > > it's been a messy one here.
> > >
> > > > Whenever a website of ours get lots of traffic, MySQL gets too
> > > > slow to connect. Whenever it connects, the queries are fast. Since
> > > > lots of our sc
I have tried that with no avail. The GUI asks for my password when I
connect, and I am able to run select queries from the GUI, but all of the
things on the Commands menu that involve changing data don't work. Thanks,
Dave W.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL
I've spent the last couple of years building well-known e-commerce sites
using Open Source code. Turns out that a fair amount of my time was spent
teaching the "Open Source way" to jr. programmers. Well, I got so tired of
going through the training ritual with each new engineer, that I put
togethe
[EMAIL PROTECTED] wrote:
>
> I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I
> searched the documentation on the site, but it doesn't seem to pertain to this
> version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can
> figure out what it might bre
Hi All,
Summary: sockets opened by mysql-clients are not closed properly after
the client process has been terminated.
I'm using mysql-3.23.8-alpha (server running on irix 6.5), the clients
run on RadHat Linux 7.
When I establish a connection from the client (linux) to the server via
the stand
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I
searched the documentation on the site, but it doesn't seem to pertain to this
version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can
figure out what it might break. Does anyone have the steps that
The manual section on BACKUP does not state what locking behavior the command
has. Does it lock all the tables at once that you backup in one statement or
does it lock them one at a time?
I.e. if I run:
BACKUP foo.bar, foo.baz, foo.blah TO '/tmp/mysqlbackups/'
Will it lock all three tables
You don't seem to have mentioned how much memory you have.
On 29 Jan 2001, at 14:52, Leonardo Dias wrote:
> > > [1 ]
> > > I don't know if any of you people have ever had this trouble, but
> > > it's been a messy one here.
> >
> > > Whenever a website of ours get lots of traffic, MySQL gets to
> From: NELSON, GLEN
> Sent: Monday, January 29, 2001 11:15 AM
> To: Mysql (E-mail)
> Subject: Install of mysql on AIX fails due to missing module libz.a
>
>
> -Original Message-
> From: NELSON, GLEN
> Sent: Monday, January 29, 2001 10:28 AM
> To: '[EMAIL
> Concurrent updates and mysql aren't the best of friends, yet. (Perhaps DBD
> and/or that new geminii stuff can fix some of your problems? Although
> geminii will probably cost you...)
>
> A lot of the slow queries can be solved by making better tables, sometimes
> even de-normalizing them if th
> "GLC" == Gerald L Clark <[EMAIL PROTECTED]> writes:
GLC> You do not say what version you are running.
GLC> Older versions did not allow updating the primary key field in that
GLC> manner.
he's not updating the primary key field.
>
> > > [1 ]
> > > I don't know if any of you people have ever had this trouble, but it's
> > > been a messy one here.
> >
> > > Whenever a website of ours get lots of traffic, MySQL gets too slow to
> > > connect. Whenever it connects, the queries are fast. Since lots of our
> > > scripts relie
-Mensaje original-
De: Gerald L. Clark [mailto:[EMAIL PROTECTED]]
Enviado el: lunes 29 de enero de 2001 12:53
Para: Guridi, Tomas
Cc: '[EMAIL PROTECTED]'
Asunto: Re: Problem with the UPDATE
"Guridi, Tomas" wrote:
>
> Hi , i´m having a strange problem with the update in mysql
> i have
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2
19991024 (release) got error message :
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\"
-DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK
-I./../include -I../include -I ./.. -I.. -I.. -O6 -DDBUG_O
"Guridi, Tomas" wrote:
>
> Hi , i´m having a strange problem with the update in mysql
> i have a table named "notices" with the following fields:
>
> id :prymary, int, auto_increment.
> title :varchar (255).
> priority:int.
>
> inside this table i have 5 registers like this :
>
> > [1 ]
> > I don't know if any of you people have ever had this trouble, but it's
> > been a messy one here.
>
> > Whenever a website of ours get lots of traffic, MySQL gets too slow to
> > connect. Whenever it connects, the queries are fast. Since lots of our
> > scripts relies on database co
> "JN" == Jeff Neuffer <[EMAIL PROTECTED]> writes:
JN> I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2.
Use /usr/ports on FreeBSD, and make sure you have the C++ compiler fixes
from mid-january (ie, update FreeBSD to 4.2-STABLE).
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Hi , i´m having a strange problem with the update in mysql
i have a table named "notices" with the following fields:
id :prymary, int, auto_increment.
title :varchar (255).
priority:int.
inside this table i have 5 registers like this :
id title priority
1 a 1
2
I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2.
I understand the name resolution issue, however I don't believe this has
anything to do with the grant tables failing. This is a binary install
from ftp.freebsd.org. Should I consider "rolling my own" from a
tar-ball?
> "jds" == j d stumbles <[EMAIL PROTECTED]> writes:
jds> I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
jds> updating the tables concerned continuously, via REPLACE INTO, INSERT INTO
jds> or UPDATE statements.
I've never had table corruption on a Solaris box, even
Leonardo Dias wrote:
>
> > I bet your webserver and database server are seperate machine.
> > Make sure the hostname of web and db are in the /etc/hosts on both machine,
> > it's very slow to use DNS to resolve everything
>
> That doesn't matter. We use IP to connect, not hostnames.
>
But if y
Hi,
Does anyone have an idea of the date when the developments of Gemini project
will be integrated into MySQL ?
Will it be integrated in the MySQL 4.0 version ?
Will it be integrated in the standard MySQL sources without changing the
license agreement ?
I read that this project resulted in the
> I bet your webserver and database server are seperate machine.
> Make sure the hostname of web and db are in the /etc/hosts on both machine,
> it's very slow to use DNS to resolve everything
That doesn't matter. We use IP to connect, not hostnames.
It might be a problem with the slow pthread_c
There's been some problems with the list. Testing if it works...
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
Marcelo wrote:
>
> Can someone tell me how i can get(or
> can someone send me) the strip command
> for SCO Open Server 5.0.5?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>
Is this perhaps related to the 'slow thread creation' 'feature' of some
linux kernels?
http://lists.mysql.com/php/search.php?ps=10&q=fast+thread+creation+&ps=20&m=
and
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias
> Sent: 29 Januar
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
- Original Message -
From: "Leonardo Dias" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, J
Aha! Many files you say. Well, the try:
-noatime, -async options for filesystem
(it quadrupled perfomance for me) or
use SoftUpdates (when on FreeBSD 4.2-stable only,
before than SoftUpdates were unstable).
- Original Message -
From: "Sam Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi, everybody,
I have trouble, installing mysql on a Linux-machine running SuSE-Linux 6.3.
I managed to compile it from source (3.23.32) and I managed to install
everything, but I am unable to create the initial databases and to start the
mysqld. Here is, what I did, and what happened:
I configu
[EMAIL PROTECTED] wrote:
>
> >Description:
>
> if a column is defined as float(3,1) and your sql query
> uses where in that particular column and the value has
> decimals on it then you got empty set.
>
> >How-To-Repeat:
>
> ($:~) mysql stuff
> Reading table information
increase the number of connections allowed, that might be it
On Mon, 29 Jan 2001, Leonardo Dias wrote:
> I don't know if any of you people have ever had this trouble, but it's
> been a messy one here.
>
> Whenever a website of ours get lots of traffic, MySQL gets too slow to
> connect. Whenever
On Fri, Jan 26, 2001 at 12:42:51PM +1300, Quentin Bennett wrote:
> Hi,
>
> how about
>
> select fname, c1.cname, c2.cname, c3.cname from
> firms,
> cityname as c1,
> cityname as c2,
> cityname as c3
> where
> first.city0 = c1.id and
> first.city1 = c2.id and
> first.city2 = c3.id;
>
> CC'ing
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
scripts relies on database connections, it has become a big p
Hi there!
Macromedia Generator needs a cloumn as query result to create a chart
from given data (e.g. temperature lows).
My data is stored in records (rows).
Does anybody know a SQL syntax to return one column as query result
containing the information from one row.
Any help is greatly appreciate
1) It's on a RAID, the seq test (just using a perl script to write files
coninuously) reach >50MBytes/sec
2) Sorry I don't understand
3) I've no idea. I've tried on UFS (on FreeBSD 3.2 3.4 3.5 4.1.1 and 4.2)
and ext2 (on newest Debian release)
4) It's on Dual xeon P2 400 1MB Cache, with 1G ram on
This is totally weird!
Untar should be faster then tar on a any normal
computer under normal os with normal hdds.
So, your problem could be:
1) Your hdds are way too slow
2) Incorrect HDD interface setup
3) Your FS setup is terrible (like no write chaching at all)
4) The machine which you are unta
If mysql were master then suppose you could use mysqlbackup to dump the mysql
db regularly. Then you could do something like a diff on the previous dump and
the recent dump to create an imcremetal update for the s7 box.
You can mysqlbackup here: http://www.ocsny.com/main/index.ocs?url=mysqlbackup
It's quite fast for tar, just around 10-20 minutes. But it's unacceptable
slow when untar, more than 3 hours! I just want to know if there's any
efficient way to do that...
- Original Message -
From: "Lars Schioler" <[EMAIL PROTECTED]>
To: "Sam Wong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED
1 - 100 of 115 matches
Mail list logo
