iain furneaux writes:
> Im afraid I do not know where the possible leaks are as I only have the
> mtrace dump which I included a section of in my first posting, I have
> included the whole dump. As the current code runs into several hundred lines
> I do not think it would be helpful
>
> mtrace du
Andreas Schoelver chortled:
> How about using a VPN (virtual private network) ?
>
> regards
> Andreas
>
> sql,select,mysql
I want to minimize the network structure on their part because they will
have a minimal DSL system as they are on the outskirts of town. As well, I
don't want the bulk of
yes after every call, that was the first thing I tried, it made the
situation better but not cured it. Are there any circumstances where
mysql_free_result() will not free the result ? does it have to be called
before any further mysql_real_query() calls are made even on a diffrent
MYSQL_RES pointe
Marcus Collins chortled:
> (sorry; missed the original post)
>
> If you have admin access to both machines, then how about using stunnel
> http://www.stunnel.org/> to set up an SSL-encrypted connection
> between both machines on the ports on which mysqld communicates?
>
> There's an example for
On Mon, 4 Feb 2002, Randy Arabie wrote:
> Date: Mon, 4 Feb 2002 12:01:11 -0700 (MST)
> From: Randy Arabie <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: Dan Nelson <[EMAIL PROTECTED]>,
> Manuel Bouyer <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
>
hello list,
I'm having trouble with an INSERT command based on a select
Is what I want is in my contacts table I'm selected certain criteria and
then inserting a note into my contactnotes table certain values
Here's what I have so far
contactnotes mysql table headers:
iain furneaux writes:
> yes after every call, that was the first thing I tried, it made the
> situation better but not cured it. Are there any circumstances where
> mysql_free_result() will not free the result ? does it have to be called
> before any further mysql_real_query() calls are made even
Kinney,
I did the following and it worked.
$text="Adding FAQ\'s";
$query="Update faqs SET subject='$text' WHERE id='110'";
mysql_query($query);
Good luck.
--
-
Before posting, please check:
http://www.mysql.com/manual.php
I'm currently trying to install MySQL in my home directory on a server which
I do have root access to. I follow the steps outlined in O'Reilly's
'MySQL&mSQL' book and I get through the first several steps before problems
occure. To set the stage, I'm using mysql-3.23.47. I'm able to 'configure',
'
Hi Makis,
There are separate PHP mailing lists - you can find them at www.php.net
- Jonathan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 11:29 AM
To: MySQL list (E-mail)
Subject: PHP with TTF fonts
Hello again!
I see many people works
What does this have to do with mysql?
Please try a PHP mailing list
ps: database, sql, mysql
savaidis wrote:
>
> Hello again!
>
> I see many people works here with php and that's natural, as php is
> connected with MySQL.
> In php graphics, I found that printing with a TTF font has no possib
On Mon, Feb 04, 2002 at 12:01:11PM -0700, Randy Arabie wrote:
> On Mon, 4 Feb 2002, William R. Mussatto wrote:
>
> > Have you checked on the ulimit for the user that is mysql?
>
> I've checked a lot of things.
>
> Which would apply:
>
> kern.maxfiles
> proc.[mysqld_pid].rlimit.de
I guess I'm a little confused about the MySQL versions.
What is the real "production" version? If 4.0.2 can be called a
production version, I'd gladly use it on my web site; however, it
doesn't seem to indicate that on the MySQL home page. So if I find a
bug in 3.23.47 that was fixed a "long ti
Hi,
> -Original Message-
> From: Jens Collin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 04, 2002 5:42 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: MyODBC leaking handles...
>
>
> Hi again Venu,
>
> I tried the latest one. I'm sorry to say that the error p
If you are using tables of the MyISAM type, the auto-increment goes up every time you
insert,
regardless of any deletes. The only way to reset it is to drop and re-create the table
or do a
"delete from table" command with no where clause. ISAM tables do not do this. Read up
in the manual
on tab
Thanks, I think that maybe the cause, I was using a single MYSQL structure
for mutiple calls with diffrent MYSQL_RES pointers.
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 7:51 PM
Subj
Anyone know what this means? I'm getting A LOT of them in my MySQL server
log.
Thanks,
-Ed
ps... any idea on how to troubleshoot something like this?
Error Message:
020204 8:20:54 Aborted connection 22 to db: 'AtFantasy2' user: 'apache'
host: `localhost' (Got an error reading communicatio
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> >?This does look like a libc bug. How did you build either one of the
binaries?
>
> They're your binaries. ?I don't buld my own binaries on Linux to save
> the hassle of using libraries that are different from what you folks
> use. :-)
In my experience, this happens when the version of mysql you're running is
newer then the version of libraries that something on your system was
compiled with, typically, installing the new libs on your system and
recompiling php or whatever you're using to connect to the mysql server
through,
Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
Windows 2000. I'm having issues with the CAST command, for example, if
I execute:
CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
I receive the error:
ERROR 1064: You have an error in your SQL syntax near '('20
At 01:19 PM 2/4/2002 , you wrote:
>2) I use MySQLfront just for a couple of days. I find it very usefull (has
>to be written in Delphi) Is this the best freeware for this job or is there
>a better one ?
Makis,
MySQLFront is pretty good considering the price. :)
There is
On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote:
> Hi, this is Erin Lilly, I've used support before with you all for
> bodyconsultant.com and you were extremely helpful. I'm installing mysql on
> erinlilly.net and have run into that common /tmp/mysql.sock (111) error
>
Hi, you just m
On Mon, 4 Feb 2002, William R. Mussatto wrote:
> Have you checked on the ulimit for the user that is mysql?
I did, but had only set it "dynamically". I did raise it quite high,
5000 I believe. After that I initiated the load, but from a "normal"
user shell which had the default proc.[shell_p
On Mon, Feb 04, 2002 at 03:43:40PM -0700, Randy Arabie wrote:
> On Mon, 4 Feb 2002, William R. Mussatto wrote:
>
> > Have you checked on the ulimit for the user that is mysql?
>
> I did, but had only set it "dynamically". I did raise it quite high,
> 5000 I believe. After that I initiated the
Hi, this is Erin Lilly, I've used support before with you all for
bodyconsultant.com and you were extremely helpful. I'm installing mysql on
erinlilly.net and have run into that common /tmp/mysql.sock (111) error
version: 3.23.45-pc-linux
To telnet in as root:
erinlilly.net
log-admin
pw-paws
y
On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> > >?This does look like a libc bug. How did you build either one of the
> binaries?
> >
> > They're your binaries. ?I don't buld my own binaries on Linux to save
> > the h
On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote:
>
> Hi.
>
> Does somebody know which server hardware I have to buy to realize my following
>problem ?
>
> I have 3 tables. They are all connected to each other with some queries.
>
> 1st table has momentary 10.000 and shou
I have an application that stores a large (up to 6gb) database in an
InnoDB table. I'm using an InnoDB table to have concurrent inserts and
selects and to get beyond the 2gb limitation.
I have to allow read-only remote database connections and cannot enforce
that users use any kind of special qu
Oganes,
> I have the following create table, and I get the following error when I create it.
> It used to work before. Can anyone help?
>
> CREATE TABLE PROTOCOL_GROUPING(
> PROTOCOL_GROUPING_ID MEDIUMINT(20),
> GROUP_NAMEVARCHAR(50)NOT NULL,
> PROTOCOL_ID
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote:
> (Please reply directly, I am only on the digest list, thanks)
>
> I have an SQL statement that is taking far too long to run, around
> 11 minutes (while locking inserts/updates).
>
> We have installed some more RAM, and I need help w
Hi All,
Does anyone knows how to change my mysqladmin password or how to find out
what the password it, I installed the rpm package, didn't setup any
password, however when I setup a tool to use it with, the tool is asking me
to produce the mysqladmin password.
Thanx
On Monday 04 February 2002 01:12 pm, Greg Bailey wrote:
> What is the real "production" version? ?If 4.0.2 can be called a
> production version, I'd gladly use it on my web site; however, it
> doesn't seem to indicate that on the MySQL home page. ?So if I find a
> bug in 3.23.47 that was fixed a "
Hi All,
I have tried out some performance testing with some heavy SELECT and
UPDATES. The database in question has only 500 records but there are lots of
SELECTs and UPDATEs and the results are:
after timing the program that was targeting MySQL on different platforms
the results are (client
>From time to time I seem to see error messages in my database.err log file
for MySQL.
020130 11:19:10 Aborted connection 40437 to db: 'xyz' user: 'abc' host:
`localhost' (Got an error reading communication packets)
I've been reading about the Morning Bug and here's what I extracted about it:
On Mon, 4 Feb 2002, Manuel Bouyer wrote:
> What a minute ... you're loading the tables to a 'mysqld' process, using
> the 'mysql' command, rigth ?
> Maybe it's just the mysql command which runs out of files descriptors ?
> Did you try to raise the limit of the shell before starting it ?
Right.
Hi,
Your problem is that your query uses all of the rows in the table. That
means that the indexes on the table are incorrect.
You should try putting a single index on prev_e3_id and a single index on
the other table. It'll probably improve your performance a lot.
BTW. Schedule some time for ma
Hi,
I would like to obtain the time in GMT in mySQL.
CURRENT_TIMESTAMP returns the local time
SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on
my system
But how can I get the time in GMT???
Thanks for your time,
Oliver
From
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Default_privileges
The MySQL root user is created as a superuser who can do anything.
Connections must be made from the local host. Note: The initial root
password is empty, so anyone can connect as
: after timing the program that was targeting MySQL on different platforms
: the results are (client program running always from the same box that is not
: hosting MySQL):
:
: Windows NT - 25 sec (Intel P-III)
: Linux - 27 sec (Intel P-III)
: Solaris 2.7 - 1 min 40 sec (Ul
* Christopher Bell
> Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
> Windows 2000. I'm having issues with the CAST command, for example, if
> I execute:
>
> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
>
> I receive the error:
>
> ERROR 1064: You have an erro
Hello,
Thanks for your time. I'm having some problems loading images into a
table. I'm using the statement:
INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg');
The table (blobtest) is made up of 2 columns : id1 (auto counter) and b1
(BLOB)
When I try and run this statement (above) I get a rec
Hi Oliver,
> I would like to obtain the time in GMT in mySQL.
>
> CURRENT_TIMESTAMP returns the local time
> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on
> my system
>
> But how can I get the time in GMT???
MySQL is time-neutral, that is to say, if you ask it the t
With all of the benchmark test I have used the same DB structure, same
TABLE structure, and finally same iterations.
This probably means that Solaris I/O is really poor, or there is some other
explanation (like changing some kernel parameters to get Solaris working
well with DB kind of stuff).
Hmmm - pardon me for jumping in in a conversation in progress - but
according to the manual* you should be able to set the TZ variable to your
timezone - which sounds like what has happened on your machine.
If you can figure out how to put the right code in, your SQL queries will
purportedly be i
Hi dn,
Right. Having said that tho, is there a function
in mysql that will return the GMT time from the operating
system, that I can subsequently use in a query.
I could use the GMT time from the db client but I
would prefer to use the GMT time from the operating
system mySQL is running on.
Than
Hi folks -
I am having 2 related problems with the timezone setting for mysqld & was
hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values & which time z
Nesh,
> With all of the benchmark test I have used the same DB structure, same
> TABLE structure, and finally same iterations.
>
> This probably means that Solaris I/O is really poor, or there is some other
> explanation (like changing some kernel parameters to get Solaris working
> well with
The boxes running the MySQL were isolated from other users so there was no
activity on them while I was performing the benchmark tests.
There was no tuning - I just installed the MySQL from their binary
packages, that is I was using the default config files (hoping that they are
the same - I w
You *could* use UNIX_TIMESTAMP(NOW()), which will return an integer
timestamp from the server in standard Unix time, which is the number of
seconds since 00h00 1 Jan 1970 UTC. However, there is no easy way to
get this to display in -MM-DD HH:MM:SS format w/o the conversion to
local time taki
Hi all,
A couple of weeks back you may remember that I was asking about
setting up a new client on our server that ran around 35GB in bandwidth
per month mostly from MySQL queries. Well, we have put them on our
server and have good and bad news. The good news is that they are now
pull
Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt one)
Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT indicies,
it will crash the mysqld daemon.
The query that does this is a "multi table" query, as such..
MATCH(table1.col1, tabl
I'm hoping I can get some help here, I'm trying to get MySQL running
on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
Ran mysql_install_db then changed the group and owner on
/var/lib/mysql to root.
This is what sho
many thanks brothers
Now, my query fastest again with limit 1, because query count(*) just result
1 row
=-hery-=
- Original Message -
From: "BD" <[EMAIL PROTECTED]>
To: "Hery Yulianto" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 10:34 PM
Subject: Re: How
I need to find a text editor for Linux that doesnt load the whole file
into memory. I need to edit a 1.5 gig text flatfile to add two lines.
But I dont have enough ram to open it in most programs. Can anyone
recommend something?
Filter: sql,query
Matthew Walker
Ecommerce Project Manager
Mounta
At 0:35 + 2/5/02, David Ayliffe wrote:
>Hello,
>
>Thanks for your time. I'm having some problems loading images into a
>table. I'm using the statement:
>
>INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg');
You'll probably need to double the '\' character. Or perhaps use
a '/' instead. (Th
Hi Kinney,
On Mon, 2002-02-04 at 12:06, Kinney Baughman wrote:
> Hi,
>
> I'm playing with PHP/MySQL for the first time having used Perl and MySQL
> for years.
>
> In one of my first update scripts, PHP is automatically escaping quotes and
> such, which I assumed was a good thing.
PHP has a
I am close to a solution:
select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT
Convert this to a date format and you have a GMT date.
Thanks to Chris Land for pointing the UNIX_TIMEST
UTC doesn't do daylight savings. One reason is that different places
do daylight savings at different times. We here in the Western US, for
example, are in standard time right now. In Arizona, they don't do
daylight savings at all.
james montebello
On Tue, 5 Feb 2002, Oliver Mannion wrote:
On Monday 04 February 2002 07:33 pm, [EMAIL PROTECTED] wrote:
> Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt
one)
> Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT
indicies,
> it will crash the mysqld daemon.
Thanks for the
If you need to update an old record in unique key, try to use REPLACE
function. REPLACE could add if there has not existing record and update
when it found a same unique key.
Sommai,
At 19:01 5/2/2002 +, DL Neil wrote:
>HelloErik,
>
> > I have a slight dilemma, and was wondering what the
I ended up using head and tail to split it into 2 files, so that I
didn't have to edit it. See, it was the output of a mysqldump from two
databases, and I needed to make sure each part went where it needed to
go.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
Right.
Perl seems to work with daylight savings, how is this?
At 08:03 PM 4/02/2002 -0800, James Montebello wrote:
>
>UTC doesn't do daylight savings. One reason is that different places
>do daylight savings at different times. We here in the Western US, for
>example, are in standard time righ
Using Perl:
my $GMTdate = gmtime(time);
this will give you the GMT time.
>>On Tue, 05 Feb 2002 15:27:18 +1100, Oliver Mannion <[EMAIL PROTECTED]> wrote:
>>Right.
>>
>>Perl seems to work with daylight savings, how is this?
>>
>>At 08:03 PM 4/02/2002 -0800, James Montebello wrote:
>>>
>>>UTC
Hi All,
How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat
Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB
table.
Thanks in advance,
sreedhar
-
Before posting, please chec
I need a little help getting Basilix to run. The one part I can't get is
the db connection. Somehow username and password are placed in the
basilix.sql file with the command >mysql -u "username" -p "password" <
/usr/local/basilix/db/mysql/basilix.sql
This command (I assume) works fine IF both
I noticed the MySQL Intel 3.23 stable binary has changed its name on the
download page from pc-i686 to libc6.
Is this just different terminology or is something else different?
Helpful souls cautioned me against running the i686 binary on a i586
machine--would this be the same deal?
I'm trying
> PRIMARY KEY (`FIELD_1`),
> KEY `FIELD_1` (`FIELD_1`),
You don't need a second key on the column, as it is a duplicate of the
primary key.
> but, i do query sintax, just simple select count(*) from TABLE_1
where
> FIELD_1 = "XXX_CC";
> But i got the result very long timemore 10 mi
Johannes,
which version of MySQL you are running?
>From http://www.innodb.com/bugfixes.html :
November 17, 2001:
The insert buffer tree can get into an inconsistent state, causing a crash,
and also crashing the recovery. This bug may appear especially in large
table imports or a
Message <[EMAIL PROTECTED]> from zarko.mocnik <[EMAIL PROTECTED]> (return
path: [EMAIL PROTECTED]) and sent to [EMAIL PROTECTED] was NOT DELIVERED because
at least one virus was found within an attachment to it. Details Follow:
->
eTrust EZ Antivirus Version 5.3.7.4
Started sc
- Original Message -
From: "David Phillips" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 4:01 PM
Subject: Re: How to index Optimization on 20 million record
> > PRIMARY KEY (`FIELD_1`),
> > KEY `FIELD_1` (`FIELD_1`),
>
> You don't need a second key on
Hi Bruce
01.02.02 15:41:49, Bruce Stewart <[EMAIL PROTECTED]> wrote:
>Hi Andreas,
>
>> >I think AUTO_INCREMENT is on a per-connection basis. So if
>> you're doing
>> >this across different database connections, it will reset to 0.
>[snip]
>> do a 'select * from where test=1' and you will
>>
I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
3.23.47-max. Before starting up 3.23.47-max, I added several Innodb
options to the my.cnf file:
---snip---
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
innodb_data_home_dir = /home/mysql/yahoo/
Hi Michael
01.02.02 16:27:24, "Fochtman, Michael" <[EMAIL PROTECTED]> wrote:
>BMJI,
>
>But isn't 'last_insert_id()' only meant to be called after inserting a
>record?? If you've never inserted a record (using the current connection),
>it seems like calling 'last_insert_id()' would be a meaningl
03.02.02 18:33:50, Samy Elashmawy <[EMAIL PROTECTED]> wrote:
>Folks, I have installed multiple copies of MySql ,
>MyODBC , unixODBC and need to clean up the system. I
>have removed the rpm versions , but now need to remove
>the source versions. How is this done under linux ,
>especialy for Mysql
Hi all,
My problem goes away after I have upgraded MySQL from
3.23.41 to 3.23.46. Thanks you for anyone who have
made suggestions or who have tried to figure out the
solution.
Kent.
--- Mr Kent Cheung <[EMAIL PROTECTED]> wrote:
> Date: Wed, 30 Jan 2002 20:01:21 -0800 (PST)
> From: Mr Kent Cheung
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa Milivojevic, in order to achieve a
practical and thorough monitoring of MySQL servers. No less than 7
modules, such a
Hi!
InnoDB seems to have created the database and started ok. This does not look
like an InnoDB bug.
I think gethostbyaddr asks from a connection the hostname, and subsequent
code checks that the host has access rights to mysqld.
For some reason gethostbyaddr_r crashes.
Hmm.. if you could run
If you supress aggregate funtions and "group by" clause then:
select *,
(case a.tipo
when 'F' then
case a2.tipo
when 'F' then a2.valor
when 'M' then a2.valor/2
else 0
end
when 'M' then a.valor/2
else null
end) as valorCalculado
from a
Hi.
Does somebody know which server hardware I have to buy to realize my following
problem ?
I have 3 tables. They are all connected to each other with some queries.
1st table has momentary 10.000 and should be upgraded to 50.000 records.
2nd table has 120.000 records at moment and shoul
> Er, no,
>
> 12.3399 < float_var < 12.3400
>
> works fine.
>
> It is the = operation that doesn't. Remember that floating
> point numbers
I don't understand why you think inexact numbers won't compare, the
originators comparison works for '12.3' works with several other types
iain furneaux writes:
> HI,
>
> Firstly I hope this is the right list as the enquiry I have I do not class
> as a bug due to my uncertainty about where the problem lies.
>
> I have been using the C API for MySQL 2.22.32 on Linux 2.2.14 and I have
> noticed that my program was getting to an unman
> which version of MySQL you are running?
3.23.39 :-(... sorry for not including this earlier. I will try and
move to .47
Thanks!
>
> >From http://www.innodb.com/bugfixes.html :
>
> November 17, 2001:
> The insert buffer tree can get into an inconsistent state, causing a cr
Hi,
About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
the internals.h (except the following part :
-#define STACK_SIZE (2 * 1024 * 1024)
+#define STACK_SIZE (128 * 1024)
)
The local_lim.h is also partially patched :
The following part :
-#define PTHREAD_THREADS_MAX
Hi,
i'm running the mysql server in windows98. When i restart windows mysql
(innodb) states the database was not shut down correctly. However when i
shut down the server explicitely with mysqladmin things seem to work OK.
Is it really necessary to do this explicit shutdown with mysqladmin befor
jocelyn fournier writes:
> Hi,
>
> About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
> the internals.h (except the following part :
> -#define STACK_SIZE (2 * 1024 * 1024)
> +#define STACK_SIZE (128 * 1024)
> )
> The local_lim.h is also partially patched :
>
> The fol
>> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid dumping
a very large ISAM mysql table to a text file, just to load it back into another
table (MYISAM).
I was looking for answers as to why isamchk w
Hery Yulianto a écrit :
>
> - Original Message -
> From: "David Phillips" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, February 04, 2002 4:01 PM
> Subject: Re: How to index Optimization on 20 million record
>
> > > PRIMARY KEY (`FIELD_1`),
> > > KEY `FIELD_1` (`FIEL
Hi,
> To tell you a truth, I have downloaded 2.2.5 but still have not found
> time to build / install them.
Perhaps the fear of glibc compilation / installation ;)
I've already installed 2.2.5, and it works really fine for me (and at least
it compiles with gcc 3.0.3 ! :))
(with #define STACK_SI
http://www.alt-php-faq.org/local/70/
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 11:30
To: [EMAIL PROTECTED]
Subject: Help, Root User Password Lost!
zhu,
Monday, February 04, 2002, 7:24:22 AM, you wrote:
zc> Hello Friends:
zc> My
On Monday 04 February 2002 14:02, Henry Hank wrote:
> >> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
>
> That suggests using LOAD DATA INFILE, but I would really like to avoid
> dumping a very large ISAM mysql table to a text file, just to load it back
> into another tabl
Hi again Venu,
I tried the latest one. I'm sorry to say that the error persists...
Still leaking handles at terrible speeds. One handle for each select even if we close
the set.
You mentioned something regarding a new version of the server engine as well... Is
this going to be released soon? Do
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way, data will travel over the net. I need that data secure
and I don't know how I can make that secure. It's not a permissions thing,
Hi Rich,
Just so I understand you correctly;
1. Are you trying to use the replication features of MySql for
this communication?
Or
2. Are you talking on the client side application, like PHP,
Java, Perl...?
How about encrypting the data itself and skipping the wh
Dear all,
I experienced some problems with using MySQL API:
My problem is that if I don't use database a long time it is disconnected and when I
try to connect again at first I use method mysql_ping(), which reopens connection and
that's the point. Please see next code of MySQL API:
static my_
Mikel King chortled:
> Hi Rich,
Hey there. Thanks for the response.
> Just so I understand you correctly;
>
> 1. Are you trying to use the replication features of MySql for
> this communication?
Nope.
> Or
>
> 2. Are you talking on the client side application, like PHP,
There is no reason to add comments like "There's no successful career path
for a hand-held dba." People come to this list looking for help. Comments
such as this will cause some folks not to ask questions for fear of public
ridicule.
Simply answer the question and move on. If you feel a need t
Skriniar Gregor writes:
> Dear all,
>
> I experienced some problems with using MySQL API:
> My problem is that if I don't use database a long time it is disconnected and when I
>try to connect again at first I use method mysql_ping(), which reopens connection and
>that's the point. Please see n
Hery,
You need to get some idea of how many records are being counted.
What I suggest is to put a Limit on your select statement and gradually
increase it.
For example
select count(*) from TABLE_1 where FIELD_1 = "XXX_CC" limit 10;
If this takes too long, then you know right away the
Hi,
Ideally I wish to keep all of my database files on a network drive
(X:\). Using WinMySQLAdmin.exe I have created a my.ini file which
resides in my WINNT directory.
my.ini contents...
[mysqld]
basedir=C:/mysql
#bind-address=127.0.0.1
datadir=X:/Shared/MyData/data
#language=C:/mysql/share/your
Is your software free to use for Commercial use?
Thank You,
Mary Grassell
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
1 - 100 of 143 matches
Mail list logo
