On 2015/04/12 08:52, Pothanaboyina Trimurthy wrote:
The problem is , as mentioned the load data is taking around 2 hours, I
have 2 timestamp columns for one column I am passing the input through load
data, and for the column "DB_MODIFIED_DATETIME" no input is provided, At
the end of the load data
Hi All,
I am facing an issue with timestamp columns while working with MySQL load
data in file, I am loading around a million records which is taking around
2 hours to complete the load data.
Before get into more details about the problem, first let me share the
table structure.
CREATE TABLE
Miguel,
On Fri, Dec 25, 2009 at 4:56 PM, Miguel Angel Nieto
wrote:
>> Load balancing, or high availability?
>>
>> I do not think there is anything good and simple AND generic out of
>> the box. As previous posters have noted, you generally have to build
>> something on top of other tools.
>
> Hi
Baron:
> Load balancing, or high availability?
> I do not think there is anything good and simple
We use MySQL master-master replication to keep
geographically separated databases in sync.
It works very well.
We built a management layer on top of it to allow
the endpoints (Web servers) to talk
> Load balancing, or high availability?
>
> I do not think there is anything good and simple AND generic out of
> the box. As previous posters have noted, you generally have to build
> something on top of other tools.
Hi,
I have the HA solved with MMM. Now, I want load balacing, sending read
que
Miguel,
On Sun, Dec 20, 2009 at 6:21 PM, Miguel Angel Nieto
wrote:
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
Load balancing, or high availability?
I do not think there is anything good and simple AND generic out of
Hi,
I've had quite a bit of success deploying mysql-proxy in my clients
infrastructure.
The standard read/write splitting is quite easy to achieve - but I
also add some custom code to match with specific case (connection
pooling, x second to the same master after a write/update, specific
command
El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto
escribió:
>> It depends a lot on how you plan to coordinate the db servers
>> (sharding, replication, ndb), the kind of applications you are going
>> to deploy and how much scability you need.
>
> Thank you. I have read about LVS and keepali
Hi,
El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón
escribió:
> 2009/12/21 Miguel Angel Nieto :
>> Hi,
>>
>> I am searching fot a Mysql Load Balacing tool. I read about mysql
>> proxy, sqlrelay, haproxy...
>>
>> What do you prefer?
>
> Hi,
2009/12/21 Miguel Angel Nieto :
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
>
> What do you prefer?
Hi,
The solutions I have heard most from our customers (in production) are
not mysql-specific:
1) Simple, n
Hi,
I am searching fot a Mysql Load Balacing tool. I read about mysql
proxy, sqlrelay, haproxy...
What do you prefer?
What are the benefits and bugs?
:)
Thank you.
--
Lo que haría sería hacerme pasar por sordomudo y así no tendría que
hablar. Si querían decirme algo, tendrían que escribirlo
can u please show use the content of the test.csv file. Also is "comapny
name" a single column or two different columns
If its two different columns than try this
load data file '/foo/test.csv' into table abc.test fields terminated by ','
(company,name)";
On 6/28/08, bruce <[EMAIL PROTECTED]> w
Hi..
I've got an issue with doing a Load data file" cmd..
my test text tbl has a column named "company name" i'm trying to figure out
how to use the load data file cmd, to be able to extract the "company name"
col...
when i do:
load data file '/foo/test.csv' into table abc.test (company name)";
Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Renato Golin wrote:
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in the replication (2-way
to make switching back and forth easy) chain.
Why do you need a ba
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain.
Why do you need a backup site to write th
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN. We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain. I
am thinking of a master, slave setup at each location where
Peter Zaitsev wrote:
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
I am looking into a scale-out solution for MySQL. I have read white
papers and searched the web but I can't find a load balancer that claims
to work well for MySQL. MySQL's white paper shows NetScaler in the
scale-
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
> I am looking into a scale-out solution for MySQL. I have read white
> papers and searched the web but I can't find a load balancer that claims
> to work well for MySQL. MySQL's white paper shows NetScaler in the
> scale-out stack but noth
I should mention that the below concerns read-only daemons, Dan's post
reminded me of that. Having multiple masters in a load balanced
environment is extremely difficult to do right.
I would wager that for most applications, at least internet related,
you'll have a much higher read-to-write ratio
Ed, in Jeremy Zawodny's (excellent) book "High Performance MySQL",
there is a chapter on load balancing - though it's a bit more of a
theoretical discussion than a how-to.
There are a couple of commercial products mentioned briefly - Veritas
and EMIC Networks.
One idea he presents might work for
You can have a simple LVS setup running with a plugin from Nagios,
check_mysql, which will connect to the mysql daemon and run a status
query. If you want anything more than that you most likely will have to
write a custom check plugin (shouldn't be that hard). LVS works nicely as
a mysql loadbalan
I am looking into a scale-out solution for MySQL. I have read white
papers and searched the web but I can't find a load balancer that claims
to work well for MySQL. MySQL's white paper shows NetScaler in the
scale-out stack but nothing on Citrix.com mentions MySQL. I also read
that friendster
Hi!
Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL
ver. 4.0.15a, PHP 4.2.3, all of them on same machine.
After "restart server" command the MySQL server is loading and
unloading immediately.
The "error file : MYSQL:/data/WEB.err" contain the following
text:
sys:/my
Ian Sales (DBA) wrote:
Kevin A. Burton wrote:
Define DoS?
- Denial of Service...
ug... Thats not what I meant... I mean what type of behavior were you
noticing? Just all connections being occupied on the server?
Kevin
--
Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an
Kevin A. Burton wrote:
Jason J. W. Williams wrote:
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any
Jason J. W. Williams wrote:
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any help is greatly apprec
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any help is greatly appreciated!
Best Regards,
Jason
eries.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Sheni R. Meledath
Sent: Wednesday, January 05, 2005 12:18 AM
To: Tom Crimmins
Cc: mysql@lists.mysql.com
Subject: RE: MySQL Load on server
Dear Tom,
Thank you very much. Is there a way to log al
Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:40 PM
To: MySQL Masters
Subject: MySQL Load on server
Hello:
We have multiple web sites hosted on a virtual web server. Many of the web
sites are using MySQL databases. Recently we are having problems
If I understand correctly, this is what you want:
SHOW PROCESSLIST
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:40 PM
To: MySQL Masters
Subject: MySQL Load on
Hello:
We have multiple web sites hosted on a virtual web server. Many of the web
sites are using MySQL databases. Recently we are having problems with the
CPU load due to mysql processes. We are not able to track the corrupted
database or script (PHP). There are many databases on the server.
C
re on MySQL load balancing
we're using an Alteon 2424 load balancer. we have 5 mysql slave
machines behind it. it works very well, except for the normal problems
with mysql replication.
-jsd-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
load balancing..
there are a number of techniques here but it would be interesting if
people could share some real-world experiences
HTTP load balancing is pretty well understood but there's not a bunch
out there on MySQL load balancing
Kevin
--
MySQL General Mailing List
For
t there's not a bunch
out there on MySQL load balancing
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Was curious what people on the list are using for load balancing.. there
are a number of techniques here but it would be interesting if people
could share some real-world experiences
HTTP load balancing is pretty well understood but there's not a bunch
out there on MySQL load bala
Problem: all the mod_perl pages run a few write queries, so they will require a
connection to the main database server. Since around
80% of our queries are reads, would you recommend that each script has two
connections: one for read queries, and one for write
queries? We can determine which quer
At 02:06 PM 2/25/2004, you wrote:
Hi,
Currently our web infrastructure has one main MySQL server, to which
connections are made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application
servers on other servers (which have persistant connecti
Hi,
Currently our web infrastructure has one main MySQL server, to which connections are
made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application servers on other
servers (which have persistant connections,
and do both reads and writes
On Fri, Jan 16, 2004 at 10:14:08AM -0800, Andrew Kwiczola wrote:
> I was wondering how many records A mysql table can comfortably handle.. and
> which table type supports the greatest amount of record capacity. Can I
> have a few million records in 1 table? Over 10 million? Thanks !
>
Hi, Andrew
I was wondering how many records A mysql table can comfortably handle.. and
which table type supports the greatest amount of record capacity. Can I
have a few million records in 1 table? Over 10 million? Thanks !
[snip]
It's a little messy but that's the only other way I can think of doing
it.
Sorry.
[/snip]
If he has the file locally to himself he can do this via phpMyAdmin
through the load text file option. Depending on the version there is
always a way to load files ... even to remote servers
For i
is_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
>
> I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version
> remedy the issue?
>
> Thanks,
>
> -Mike
>
>
>
>> -Original Message-
>> From: Donald Tyler
[snip]
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'
[/snip]
Mike, could we see just a bit of the php9GOwvw file...just out of
curiosity
--
MySQL General Mailing List
Fo
iday, August 08, 2003 3:24 PM
To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Ah. No wonder it dinna work. Neither did specifying the columns as Jay
suggested.
I also have no choice but to do it through the browser - I don't have
command line
nks,
-Mike
> -Original Message-
> From: Donald Tyler [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:42 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just re
When I come across this error:
The used command is not allowed with this MySQL version
Does this mean that I need a whole different verison of MySQL, or just a
different compile? The command was 'LOAD DATA INFILE' and I was doing it
through phpMyAdmin.
Thanks,
-Mike
--
MySQL General Maili
.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw'
[snip]
70050;451
70322;451
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
> [/snip]
[/snip]
I am going to recommend that you specify which columns the data goes
into
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_
o: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> [snip]
> 70050;451
> 70322;451
>
> > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> > TERMINATED BY ';' LINES TERMINATED BY
; Sent: Friday, August 08, 2003 4:08 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> Oh and just a note. This solution won't work if you are uploading the file
> to the server through the browser. You will need to put the file on the
> server
[snip]
I see you still have the word LOCAL in there. Did you try and remove it?
To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It
should
wor
hanks,
-Mike
> -Original Message-
> From: Donald Tyler [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 4:30 PM
> To: [EMAIL PROTECTED]
> Subject: FW: mysql LOAD DATA INFILE
>
>
> Then the only way you can do it that I can think of is to write a
> PHP script
&
over 15,000 of them. :)
-Mike
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:58 PM
> To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> [snip]
> Sorry, that
st 08, 2003 3:07 PM
To: '[EMAIL PROTECTED]'
Subject: FW: mysql LOAD DATA INFILE
I see you still have the word LOCAL in there. Did you try and remove it?
To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of
PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove the word
LOCAL and it should work fine.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE
When I come a
Hi!
On Aug 01, Dan Muey wrote:
>
> > Dear Ladies and Sirs,
> >
> > can anyone give me a hint please, if it is possible toimport
> > data data from a zipped File, without unzipping it before.
> > I'm using MySQL 3.23 on a LINUX System. I guess it is
> > possible using a 'named pipe' and 'funzi
> Dear Ladies and Sirs,
>
> can anyone give me a hint please, if it is possible toimport
> data data from a zipped File, without unzipping it before.
> I'm using MySQL 3.23 on a LINUX System. I guess it is
> possible using a 'named pipe' and 'funzip' , but I don't lnow how.
I've used Perl and
Dear Ladies and Sirs,
can anyone give me a hint please, if it is possible toimport data data from
a zipped File,
without unzipping it before.
I'm using MySQL 3.23 on a LINUX System.
I guess it is possible using a 'named pipe' and 'funzip' , but I don't lnow
how.
Thank you
Klaus
--
MyS
Sarah,
Wednesday, December 04, 2002, 12:48:15 AM, you wrote:
SK> We updated mysql yesterday to 3.23max and have just discovered that "load
SK> data local infile ." no longer works unless you enable it somewhere
SK> specifically. I've tried starting mysql with the option -local-infile=1 in
SK>
We updated mysql yesterday to 3.23max and have just discovered that "load
data local infile ." no longer works unless you enable it somewhere
specifically. I've tried starting mysql with the option -local-infile=1 in
several different files and on the command line. I can make it work with a
f
Tim,
[returned the conversation to the list, so that others may benefit]
> Right now in the config.inc.php file i have it set as:
>
> ### MySQL data
> $mysql_host = "localhost"; // localhost name
> (usually:localhost)
> $mysql_user = "mine"; // MySQL username
> $mysql_pass = "mine2"; // MySQL pass
Tim,
Normally PHP/MySQL doesn't run as "mine", even if that is your Windows login
name - but it is possible...
Use command line.
Log on as root.
Check localhost privileges for user "mine".
(good coverage in the manual)
Regards,
=dn
> I have been trying to get mysql db to run but keep
> getting acc
I have been trying to get mysql db to run but keep
getting access denied.
The error is: Warning: Access denied for user:
'mine@localhost' (Using password: YES) in
/home/gulf/public_html/SiTeS_1/pUbS9_A/test/config.inc.php
on line 106
Warning: MySQL Connection Failed: Access denied for
user: 'mine
Hi Maximo,
> How should I set my memory usage in my.cnf I have a hard time
> understanding how MySQL works with memory, how it manages it, etc. What
> should I consider when setting my memory settings??? I have included a
> paste of my.cnf
>
> # The MySQL server
> [mysqld]
> port
Maximo,
- Original Message -
From: "Maximo Migliari" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 11:31 PM
Subject: MySQL load problems.
> Hello all,
>
> I've been having some problems with MySQL crashing. I
Hello all,
I've been having some problems with MySQL crashing. I use a mixture of
MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My
web applications all do relatively complex join queries. Almost all fields
in the WHERE clauses of queries are indexed.
I'm running Red
Almost forgot to say,
I'm running mysql with the following command:
./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello all,
I've been having some problems with MySQL crashing. I use a mixture of
MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My
web applications all do relatively complex join queries. Almost all fields
in the WHERE clauses of queries are indexed.
I'm running Red
Almost forgot to say,
I'm running mysql with the following command:
./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
MYSQL: I have problems with importing data including characters like 'äöü'.
These characters where translated to some other unusable characters.
In the command line with a single insert statement the 'äöü' characters are
accepted!
Can help someone ?
Thanks
Enrico Kratter
Alpenblickstrasse 30
CH-8
Taylor,
Thursday, May 23, 2002, 11:46:16 PM, you wrote:
TL> What priviledge does a user need in order to be able to execute the load data
infile command in mysql..? is it FILE?
Yes, you are right. Your user must have file privilege.
Note: MySQL must have permissions on that file in your OS.
T
Yes it is ...
See: http://www.mysql.com/doc/P/r/Privileges_provided.html
Gurhan
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:46 PM
To: [EMAIL PROTECTED]
Subject: mysql load data question
What priviledge does a user need in order to
What priviledge does a user need in order to be able to execute the load data infile
command in mysql..? is it FILE?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
_for_row';
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: Mysql Load Data question
I read in the Mysql manual where you can change the default column
seperator, but it didnt specify how to do this.
So, how can I tell the LOAD DATA command
I read in the Mysql manual where you can change the default column seperator, but it
didnt specify how to do this.
So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go
to find out about mysql command syntax...?
Thanks,.
Taylor Lewick
Unix System Administrator
[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes:
> FWIW, reproducible testcases are good... all complex software products
> have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in
> interaction with oneanother (e.g. timing/locking issues), so
> reproducible testcases are a necessity
"Mike Robinson" <[EMAIL PROTECTED]> writes:
> Thanks for your note.
>
> You wrote:
>
> >
> > There are known problems with gcc-2.96 which comes with RH 7.2
> > distribution. There is disclaimer about it at
> > www.mysql.com/downloads/mysql-3.23.html as you noticed.
>
> There is much reading
Mike,
BTW, have you been able to build Mysql 4.0 under RH7.x from the development
tree lately?
I keep getting some missing definitions messages as of last week, when I
performed a regular 'bk resync'. Prior to that, all had been just fine.
TIA,
Vadim P.
Mike Robinson wrote:
>
> Hello to all,
Vadim P. writes:
> Mike, what kind of problem? What exactly goes wrong with PHP4?
>
> Thanks,
> Vadim
>
> Mike Robinson wrote:
> >
>
> > I am able to reproduce this problem very easily, including on
> > Redhat-7.2. Basically, any app using the libmysqlclient.so
> > compiled with gcc-2.96 connecti
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
>
> I am able to reproduce this problem very easily, including on
> Redhat-7.2. Basically, any app using the libmysqlclient.so
> compiled with gcc-2.96 connecting to a server compiled with
> gcc-2
Thanks for your note.
You wrote:
>
> There are known problems with gcc-2.96 which comes with RH 7.2
> distribution. There is disclaimer about it at
> www.mysql.com/downloads/mysql-3.23.html as you noticed.
There is much reading on the GCC 2.96 issue.
There seems to be two paths of dicussion.
Hello,
Mike Robinson wrote:
> Hello to all,
>
> I've had some severe issues on redhat-7.x boxes and
> mysql compiled from source with gcc-2.96 much like
> the warning states on the download page. On these boxes,
> more than say 20-25 concurrent or near-concurrent connects
> produced unexpected re
On Sun, May 12, 2002 at 12:06:33PM -0400, Mike Robinson wrote:
> Hello to all,
>
> I've had some severe issues on redhat-7.x boxes and mysql compiled
> from source with gcc-2.96 much like the warning states on the
> download page. On these boxes, more than say 20-25 concurrent or
> near-concurren
Hello to all,
I've had some severe issues on redhat-7.x boxes and
mysql compiled from source with gcc-2.96 much like
the warning states on the download page. On these boxes,
more than say 20-25 concurrent or near-concurrent connects
produced unexpected results with PHP4.
Replacing the binaries c
At 13:13 -0600 2/22/02, Craig Westerman wrote:
>I have a table that has following fields
>
>id (auto increment)
>date
>appleprice
>orangeprice
>pearprice
>
>When I try to LOAD DATA INFILE with this file using comma as field delimiter
>and newline as end of row
You need to add the column list:
.
You need to specify the columns you're loading, if they aren't all the
columns in the table in the same order. So, you need to add
(date, appleprice, orangeprice,pearprice)
at the end of your LOAD DATA INFILE statement.
As for only loading one row, I'd guess your input file line endings don'
I have a table that has following fields
id (auto increment)
date
appleprice
orangeprice
pearprice
When I try to LOAD DATA INFILE with this file using comma as field delimiter
and newline as end of row
"2000-01-04","281.08","5.27","430.05"
"2000-01-05","280.06","5.14","421.98"
"2000-01-06","279
Those of you using MRTG to monitor your servers,
routers, etc. may be interested in knowing that a
MySQL extension for MRTG is now available.
This extension will allow you to monitor the number
of questions and the number of slow queries
the server is handling over time.
Links to the extension
92 matches
Mail list logo
