Hi,
> The server where the db was located got hacked and I had to
> reinstall the whole thing. The old HD is preserved as was
> and the server got a new HD. I moved the old db to the new
> disk and when I try to access it, I get the following error:
>
> mysql> use thedb;
> Can't read dir of '
Hi,
> I have some tables in the ISAM format in the database. The tables
> have the data, but whenever I do a select * from table_name, it
> returns an empty set for most of the tables. Whenever I do a
> count(*) query I get the total no of records.
try running isamchk (c:\mysql\bin\isamchk
I have installed the binary version of mysql for
Windows NT. version = 3.23.37.
I have some tables in the ISAM format in the database. The tables have the data, but
whenever I do a select * from table_name, it returns an empty set for most of the
tables. Whenever I do a count(*) query I get
"Kay Aleksic" <[EMAIL PROTECTED]> wrote:
> I am dealing with my first MySQL server/db, and I ran into some trouble.
>
> The server where the db was located got hacked and I had to reinstall the
> whole thing. The old HD is preserved as was and the server got a new HD. I
> moved the old db to the n
At 9:11 AM -0400 5/9/01, Terry Shipclark wrote:
>database,sql,query
>
>Why does this statement not work
Because you're either not reading the manual or ignoring what it says?
>
>LOAD DATA INFILE 'intervext.txt' into table intvext
>(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes
At 9:53 AM -0400 5/9/01, Brian Cuttler wrote:
>Hello,
>
>We are installing MySQL 3.22.21 as pre-built for IRIX, installing
>on IRIX 6.5.7m.
>
>The developers that want to use the database would like ownership
>of the files and daemon so that they can modify and restart at will.
Tell them to pick
At 1:45 PM -0400 5/9/01, <[EMAIL PROTECTED]> wrote:
>I was wondering if anyone knows of a way i can strip bad characters out
>of a mysql database field namely the < > charators. These charactors are
>causing havok for
>me when I try and post data to the web. Thanks Alot.
Why not just encode your
At 11:00 PM +0200 5/9/01, Christian Jaeger wrote:
>Was the table inaccessible during these 4 days? Or is mysql able to
>still write to the table while it's being altered?
Those are not mutually exclusive possibilities. :-)
According to the manual, reads can be done on the original table while
t
Dear Sir,
I have a project which need to synch our mysql db with external
Oracle DB.
It requires that anytime DB admin modifies their Oracle DB, the
change should be synched remotely with our DB in mysql. To make thing
easy, we could use the same table structure on both end.
Does this seem to weird to anyone?
mysql> SELECT count('') FROM emailarchive where match (sendername) against
('shawn') group by '';
+---+
| count('') |
+---+
| 13286 |
+---+
1 row in set (3.29 sec)
mysql> SELECT count('') FROM emailarchive where sendername like '%sha
Hi,
I am unable to access myql database in linux using myodbc. The error it is giving is
"Data source name not found and no default driver specified. Driver could not be
laocated." If anyone could help or tell where i could find its documentation it would
be great.
Thanks in advance..
Regards
$dbh = DBI->connect($dsn, $user_name, $password, {RaiseError => 1}) ||
die ("Unable to establish connection to mysqld: " . $DBI::errstr);
tang jie wrote:
>
> the user "mysql" is given all priviliges,
> another user is given db table privileges (INSERT,
> SELECT, etc.),
> the database files are
the user "mysql" is given all priviliges,
another user is given db table privileges (INSERT,
SELECT, etc.),
the database files are owned by user "mysql",
in the same perl DBI script, at the very biginning,
the line:
$dbh = DBI->connect($dsn, $user_name, $password,
{RaiseError => 1});
works when
the user "mysql" is given all priviliges,
another user is given db table privileges (INSERT, SELECT, etc.),
the database files are owned by user mysql,
in the same perl DBI script, at the very biginning, the line:
$dbh = DBI->connect($dsn, $user_name, $password, {RaiseError => 1});
works only wh
Does anyone know how mysql behaves when a client CGI script quits? Does
the SQL query march on through? I wondering if anyone knows of ways to
protect against browser reloads and other forms of similar
abuseespecially if the the sql query is expensive?
BTW, I'm not allowed to use cookies t
errno 13 is 'permission denied'.
It looks like your permissions aren't set correctly.
-Jeff
- Original Message -
From: "Kay Aleksic" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 3:10 PM
Subject: database recovery (errcode 13)?
> Hi li
Was the table inaccessible during these 4 days? Or is mysql able to
still write to the table while it's being altered?
Christian.
At 12:08 Uhr -0700 9.5.2001, David J. Potter wrote:
>occur very fast. We use both Windows and Linux. Adding a column is the
>only action that is slow (it took 4 da
So those of us not in the world of HA, mission critical would be equivalent?
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:20 PM
To: Billy Passauer
Cc: carlos ospina; [EMAIL PROTECTED]
Subject: Re: MySQL HA
On Wed, May 09, 2001 at 03:
High Availability. No downtime, automatic fail-over, etc.
j- k-
On Wednesday 09 May 2001 11:59, Billy Passauer wrote:
> > -Original Message-
> > From: carlos ospina [mailto:[EMAIL PROTECTED]]
> >
> > I wanna know if someone has ever setup any kind o HA with MySQL.
>
> OK, I'll b
When you say you moved the data base I'm assumeing you are meaning you
reinstalled MySQL then moved the db files over to the new install? Each
data base goes into its own directory. So the database files for the
database named thedb would be in a subdirectory called thedb of the
directory data .
- Original Message -
From: "carlos ospina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 3:32 PM
Subject: Re: MySQL HA
just a litlle gramatical correction :)
> High Availability, that was what I meant,
>
> I already have LVS working for WEB with 2 servers , a
4 days! Perhaps it would be best to create a new table and transfer data to
it. When you have almost everything transferred, lock the old table, sync
the tables and then replace the old table with the new.
Just a thought...
--zak
- Original Message -
From: "Robert Henkel" <[EMAIL PROTE
High Availability.
- Original Message -
From: "Billy Passauer" <[EMAIL PROTECTED]>
To: "carlos ospina" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:59 PM
Subject: RE: MySQL HA
> > -Original Message-
> > From: carlos ospina [mailto:[EMAIL PROTECTED]]
>
Andre,
the strange behavior may have been due to the same bug Alex
Baumeister reported, and for which I posted a fix on the mailing
list a few minutes ago.
After you had reloaded the table, did you insert, update, or delete
any rows in the table? Or did you just do selects? Did you have any
othe
High Availability, that what meant,
I already have LVS working for WEB with 2 servers , and i was thinking in
put a round replication between them and use the virtaul IP address.
Is there any better way to do that?
TIA
Camoa
CArlos Mario Ospina Anzola
Certicamara, certification authority
Colomb
If you want to check ssh for use with mysql, check out
openssh.com.
La Rocca Network wrote:
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "La Rocca Network" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 09, 2001 2:06 PM
> Subject: Re: Re: ODBC for MySql with SSL
>
>
>
>> Your
On Wed, May 09, 2001 at 02:47:59PM -0500, carlos ospina wrote:
> Hello,
>
> I wanna know if someone has ever setup any kind o HA with MySQL.
>
> I need to do that and It'll be very helpful if I can get some
> advices or documentation on that subject.
There was some work/discussion on the mysql-
I was wondering the exact same thing...
Some possible meanings of HA:
- Chemical symbol for Hahnium
- High availability
- Home automation
- High Angle (Geometry)
I'm guessing meaning #2, or maybe #3...?
-Original Message-
From: Billy Passauer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Alex,
I found the bug. It was in the consistent read through a secondary
index when inserts or updates were present on the same database page.
Below is the patch: we should set rec = clust_rec only if
prebuilt->need_to_access_clustered is TRUE.
Regards,
Heikki
.
On Wed, May 09, 2001 at 03:59:45PM -0400, Billy Passauer wrote:
> > -Original Message-
> > From: carlos ospina [mailto:[EMAIL PROTECTED]]
> >
> > I wanna know if someone has ever setup any kind o HA with MySQL.
>
> OK, I'll bite. What is an "HA" ?
High Availability.
--
Jeremy D. Zawod
High Availabilty
-Original Message-
From: Billy Passauer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:00 PM
To: carlos ospina; [EMAIL PROTECTED]
Subject: RE: MySQL HA
> -Original Message-
> From: carlos ospina [mailto:[EMAIL PROTECTED]]
>
> I wanna know if someone
Can you put your my.cnf for windows and linux? Will be nice to compare you
setting again others.
TIA,
Ernesto Vargas
- Original Message -
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 3:49 PM
Subject: Re: Having success with 20 millio
Hi list,
I am dealing with my first MySQL server/db, and I ran into some trouble.
The server where the db was located got hacked and I had to reinstall the
whole thing. The old HD is preserved as was and the server got a new HD. I
moved the old db to the new disk and when I try to access it, I g
Hi all,
I'm resending this message with a different subject
line, in the hopes that someone who Knows (a MySQL team
member :-)? will be able to answer it.
I've successfully used 'mysqlshow db_name %'
under MySQL v3.23, but under 3.22.20a, it returns the
message:
"Cannot list fields i
I take that back the word not the best shouldnt be used. I should of said
in a perfect world we shouldnt have to add columns.
-Original Message-
From: Robert Henkel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:56 PM
To: 'Joshua J. Kugler'; [EMAIL PROTECTED]
Subject: RE: Hav
Hello,
I'm trying to change the location where mysql.sock is written on server startup from
/tmp to another location. I've discovered that, on machine (solaris 8; mysql
v.3.22.32) reboot, that the /tmp directory changes it's permissions to 755 (owned by
root). Since safe_mysqld runs as mysql
> -Original Message-
> From: carlos ospina [mailto:[EMAIL PROTECTED]]
>
> I wanna know if someone has ever setup any kind o HA with MySQL.
OK, I'll bite. What is an "HA" ?
-
Before posting, please check:
http://www
Well normally its not the best to add columns after the fact if the design
met the specs. But this is not always the case. As we all now the specs
change about every hour.
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:49 PM
To: [EMA
FOUR days!?!? THAT'S patience. But I'm glad to hear the success story.
j- k
On Wednesday 09 May 2001 11:08, David J. Potter wrote:
> Just wanted to say that we are having success using MySql. Even though our
> tables are large, over 20 million rows, selects, updates and inserts occur
Hello,
I wanna know if someone has ever setup any kind o HA with MySQL.
I need to do that and It'll be very helpful if I can get some advices or
documentation on that subject.
TIA
Carlos Ospina
-
Before posting, please chec
Just wanted to say that we are having success using MySql. Even though our tables are
large, over 20 million rows, selects, updates and inserts occur very fast. We use
both Windows and Linux. Adding a column is the only action that is slow (it took 4
days once to add a column), but that is O
Hello all, I have just finished installing Cold Fusion for Linux and I am
having problems getting CF to find the mysql.sock file. Turns out the CF
drivers have the location hard coded to a specific
directory. (/var/lib/mysql/) My mysql is putting the mysql.sock file in
the /tmp/ directory.
Thanks alot
I truely appreciated the help in this matter.
both you guys are life savers :^)
-Original Message-
From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:08 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Removing Bad Characters from Databas
You can also condense this into one statement if you nest the replace
statements:
UPDATE table_name SET
field_name1=replace(replace(field_name1, '>', ''), '<', '')
etc.
-Chris
At 01:49 PM 5/9/2001, Eric Fitzgerald wrote:
>http://www.mysql.com/doc/S/t/String_functions.html
>
>REPLACE(str,from_s
http://www.mysql.com/doc/S/t/String_functions.html
REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str
replaced by the string to_str:
mysql> select REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
This function is multi-byte safe
I was wondering if anyone knows of a way i can strip bad characters out
of a mysql database field namely the < > charators. These charactors are
causing havok for
me when I try and post data to the web. Thanks Alot.
-
Before po
On Wed, May 09, 2001 at 11:18:14AM -0600, Joseph Chow wrote:
> Hi, Jeremy,
>
> It is very nice to talk to you. Thanks for your information. It's
> working now, but I did nothing but going over the procedure again.
> I may make some mistakes during my operations. But it is really a
> good idea
As the site says:
mytop is a console-based (non-gui) tool for monitoring the threads
and overall performance of MySQL 3.22.x and 3.23.x servers. It
runs on most Unix systems which have Perl, DBI, and Term::ReadKey
installed. And with Term::ANSIColor installed you even get color.
Hi, Jeremy,
It is very nice to talk to you. Thanks for your information. It's working
now, but I did nothing but going over the procedure again. I may make some
mistakes during my operations. But it is really a good idea to keep an eye
on the err log for solutions.
By the way, I once first t
- Original Message -
From: <[EMAIL PROTECTED]>
To: "La Rocca Network" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:06 PM
Subject: Re: Re: ODBC for MySql with SSL
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass th
Im getting the next error message in the mysql error log.
010509 18:16:58 Aborted connection 2390 to db: 'zonareservada' user:
'usuarioZR' host: `localhost' (Got an error reading communication =
packets)
010509 18:17:01 Aborted connection 2405 to db: 'zonareservada' user:
'usuar
On Wed, May 09, 2001 at 09:43:59AM +0100, Eugénio Veiga wrote:
> Hi
>
> Does any body if is possible in windows 9x to implement odbc for
> MySql with ssl ? There exists any driver for this ?
Not sure about that. But if you don't get any good leads, you might
consider using an SSH tunnel between
On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote:
> Hi, there,
>
> This is my first try on this mailing list. I am a new user of mysql
> and need some help about "replication" on mysql 3.23.36. I had
> followed the manual to set up master/slave server. At the
> beginning, they are c
Hi, there,
This is my first try on this mailing list. I am a new user of mysql and
need some help about "replication" on mysql 3.23.36.
I had followed the manual to set up master/slave server. At the beginning,
they are connected perfectly. All the modifications (i.e. create databases,
insert
I am planning to use the --myisam-recover option on a master MySQL server.
I would like to know about your experiences on the matter: is it reliable?
What about the consequences on the slaves: should they use it as well?
Many thanks in advance to this great mailing list :-).
--
Jean-Luc Fontai
Warren,
Thanks for your quick reply and help and pointers.
I think that realistically it will take me a while to understand it as it is only part
time (evenings after work) when I can actually do it. Initially, I will try and store
BLOBs rather than use pathnames and separate binaries so my or
On Wed, May 09, 2001 at 10:51:44AM -0400, Bill Moran wrote:
> Peter Pentchev wrote:
> > So, MySQL 3.22.x does not have the capability to produce dumpfiles,
> > only outfiles.
> >
> > Ah. I just read the whole of your message. You are using a 3.22.32 server -
> > so, sorry, but you're out of luc
on linux what user do u instal mysql with ? root or a normal user ?
> Regards
> Khuram Khan
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query
Uuups...:))) What about some new on topic keywords like entity, atrribute,
relation,
Peter Pentchev wrote:
> So, MySQL 3.22.x does not have the capability to produce dumpfiles,
> only outfiles.
>
> Ah. I just read the whole of your message. You are using a 3.22.32 server -
> so, sorry, but you're out of luck :(
A Curses, I was hoping to avoid an upgrade (since we've ha
When you lock tables, you must lock ALL tables you intend to read
or write.
You previously locked tables, and then did a select from bookings.
You did not include bookings in the lock.
Don Pro wrote:
> Hi,
>
> As the subject states, I am getting an error in my Perl script telling
> me that a t
On Wed, May 09, 2001 at 09:43:54AM -0400, Bill Moran wrote:
> Thanks for the reply, unfortunately, this produces the same error as the
> command I tried. (ERROR 1064: near 'dumpfile '/data/test.doc' where
> appid=23')
>
> I can do a "INTO OUTFILE" just fine if I use this syntax:
> SELECT resume F
Hello,
We are installing MySQL 3.22.21 as pre-built for IRIX, installing
on IRIX 6.5.7m.
The developers that want to use the database would like ownership
of the files and daemon so that they can modify and restart at will.
I need to know if its safe to open access and if so, which files
shoul
Thanks for the reply, unfortunately, this produces the same error as the
command I tried. (ERROR 1064: near 'dumpfile '/data/test.doc' where
appid=23')
I can do a "INTO OUTFILE" just fine if I use this syntax:
SELECT resume FROM apps WHERE appid=23 INTO OUTFILE '/data/test.doc';
Using this:
SELE
I have a text file which is extracted from a non-sql
database each night and then a cron sql script runs to
insert the text data into the mysql database tables.
My problem is that the date data in the text file is
formatted incosistently (12/31/00 or 12-31-00) and so
the fields that hold date dat
If you are running RedHat, look at the files /etc/cron.daily,
/etc/cron.weekly etc.
Stephan Skusa wrote:
> The Cron-Jobs working on all tables of these database are
> all running between 2:00 and 4:00 ... none at 0:00!
>
>
>> -Ursprungliche Nachricht-
>> Von: Gerald Clark [mailto:[EMA
On Wed, May 09, 2001 at 09:20:52AM -0400, Bill Moran wrote:
> Thanks for the reply, but I need a binary transfer of the DATA in the
> field only. INTO OUTFILE does 2 things that corrupt the data:
> 1. Puts field data in the file
> 2. Escapes characters.
>
> As far as I can tell, I either have to
Sir,
I'm trying to install mysql-3.23.37-hp-hpux10.20-hppa1.1 (binary) on a hp-ux 10.20
system.
When I try to create the MYSQL grant tables with the command >
"scripts/mysql_install_db" I get the following errors:
SUPERUSER FAMKE :/usr/local/mysql # scripts/mysql_install_db
Preparing db tab
Thanks for the reply, but I need a binary transfer of the DATA in the
field only. INTO OUTFILE does 2 things that corrupt the data:
1. Puts field data in the file
2. Escapes characters.
As far as I can tell, I either have to use "INTO DUMPFILE" or I need to
write a C program to do what I need.
An
database,sql,query
Why does this statement not work
LOAD DATA INFILE 'intervext.txt' into table intvext
(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes)
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
I also tried it like this
LOA
Hi!
I'm new too, but here are some things I've picked up from others on the List
kind enough to advise:
Regarding blobs, putting even large amounts of material into them is the
same as using any other data type.
Some considerations: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:10632
http://li
Heikki,
HT> can you print the EXPLAIN SELECT ... for the count(*) and the other query?
mysql> explain select count(*) from mybuffer where bourse='NAS';
+--+--+---+---+-+---+--+-+
| table| type | possible_keys | key
Dear all,
Please excuse a newbie question. I am interested in storing articles (up to 300k) in a
database, and some may have formatting and contain graphics like a word document. Is
it possible to do this in mySql and if so e.g. in a TEXT or BLOB field, how do I store
an article and then retri
RESOLVED!
I just installed an older version of myODBC (2.50.19) and all computers (Win
95 with Access 97 & Win 98 with Access 2000) are able to export quite
happily to mySQL now. I noticed an old message from "Sam Giamber" in the
archive and he had the same problem after installing 2.50.37
Thank
Hello,
I first installed mysql in /usr/local ( just typed ./configure for
configuration). Everythind was fine.
Then I wanted to install mysql in /usr/local/mysql. I deleted all files
from the first installation manually, and typed ./configure
--with-prefix=/usr/local/mysql . Then make and make in
Why is myODBC so hard to get working on different computers?
I just had to reinstall Win 95 & Office 97 on one of our test computers AND
Win 98 with Office 2000 on another (due to virus hits on our network)...
Now, since then, we cannot update our mySQL database from either of them.
Fortunately,
SELECT something FROM users WHERE statement_ok = 1 ORDER BY RAND() LIMIT 0,
1
When I use the above SQL I mostly get the same result. How can I prevent
that ?
:) Jacob
--
[ www.eksperten.dk ] Scandinavias biggest IT forum.
-
Be
Alex,
can you print the EXPLAIN SELECT ... for the count(*) and the other query?
Regards,
Heikki
At 12:03 PM 5/9/01 +0200, you wrote:
>Bonjour,
>
> Mysql-3.23.37 with latest patch (patch of the patch from Heikki :)
> ) under Solaris 2.8 (SPARC 64bit).
>
> I have a table :
>
>CREATE TABLE
Hi Kris!
mysqldump is your command
Check this URL: http://www.faqts.com/knowledge_base/view.phtml/aid/1990
HTH
Regards
- Original Message -
From: "Kris Gonzalez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 10:19 AM
Subject: saving database during os change
Bonjour,
Mysql-3.23.37 with latest patch (patch of the patch from Heikki :)
) under Solaris 2.8 (SPARC 64bit).
I have a table :
CREATE TABLE mybuffer (
id int(10) unsigned NOT NULL auto_increment,
bourse char(3) NOT NULL default '',
service varchar(10) NOT NULL default '',
date
Kris Gonzalez wrote:
>
> I'm going to be switching from my OS from Linux to Solaris and was
> wondering what steps I would need to take to save my tables during the
> OS conversion and restore them once it is complete. Is it as simple as
> tarballing the /var/lib/mysql directory and extracting
I'm going to be switching from my OS from Linux to Solaris and was
wondering what steps I would need to take to save my tables during the
OS conversion and restore them once it is complete. Is it as simple as
tarballing the /var/lib/mysql directory and extracting it into the new
OS, or is the pro
Hi
Does any body if is possible in windows 9x to implement odbc for MySql
with ssl ?
There exists any driver for this ?
Thanks
Eugénio Veiga
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I was wondering if anyone has successfully implemented timeouts on mysql
queries using the C API in Linux... my initial thought was to use a
SIGALRM to interrupt the query. When trying this, however, it appears
that the read() call made within the query is restarted after the signal
handl
use
SELECT * INTO OUTFILE 'filename' .
-Original Message-
From: Bill Moran [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 00:44
To: [EMAIL PROTECTED]
Subject: Problem using "SELECT INTO DUMPFILE"
I get an error stating: "you have an error in your SQL syntax near
'dumpfile '/data/file
I'm from Latvia. Currently my database contain words, which contain Latvian specific
characters.
MySQL works under RedHat6.2.
Is anybody now how is possible to teach MySQL correctly sort textual strings with
Latvian characters?
Andis
200 connections & table locks a second is good performance, isn't it?
what you also can do is insert bunches of data, so instead of inserting each record
seperately, you just collect them and insert them at once like:
insert into mytable (field1, field2) values (1,2), (3,4), (5,6), (7,8), .. (n
Hello,
I don't know whether this is a solution for you or not, but I had to
insert a lot of registers ( about 14.000.000 ) and in a first instance I
tried to do it via "INSERT"; the response was not as fast as I needed (I
don't currently have de data here). I changed the approach and, inst
Just thought I'd share the results so far:
As I mentioned earlier, I went ahead and upgraded the kernel from 2.2.16
to 2.4.4. The server has been running for nearly 36 hours since then, and
has reached an RSS of 100M, well over what it ever reached before. And
things are still running very smo
89 matches
Mail list logo
