--- Daniel Kasak <[EMAIL PROTECTED]> wrote:
> Abs wrote:
>
> >mysql and php question:
> >the magic_quotes_gpc is set to 1. when i echo it to
> >the browser, it shows the added slashes. i inserted
> >these same values into a database. when i read the
> >database values and printed them, i forgot t
I did a:
CHANGE MASTER TO MASTER_HOST='XXX', MASTER_USER='XXX',
MASTER_PASSWORD='XXX', MASTER_LOG_FILE='mysql-bin.034',
MASTER_LOG_POS=1089001;
and a:
SLAVE START;
but it gives me:
ERROR 1200: The server is not configured as slave, fix in config file or
with CHANGE MASTER TO
What am i missin
Well after a restart of the server, it seemed to work??
-Original Message-
From: Søren Neigaard [mailto:[EMAIL PROTECTED]
Sent: 18. september 2003 09:45
To: '[EMAIL PROTECTED]'
Subject: The server is not configured as slave???
I did a:
CHANGE MASTER TO MASTER_HOST='XXX', MASTER_USER='X
I have just added aother slave to a master i have running.
I have used the command:
CHANGE MASTER TO MASTER_HOST='XXX', MASTER_USER='XXX',
MASTER_PASSWORD='XXX', MASTER_LOG_FILE='mysql-bin.034',
MASTER_LOG_POS=1091117;
With the correct IP/user/password/log-file/position.
There are two databases
whats the error?
-Original Message-
From: Søren Neigaard [mailto:[EMAIL PROTECTED]
Sent: 18 September 2003 09:52
To: '[EMAIL PROTECTED]'
Subject: Slave not replicating database
I have just added aother slave to a master i have running.
I have used the command:
CHANGE MASTER TO MASTER_H
Daniel Kasak wrote:
Paul DuBois wrote:
If you have problems reloading the table due to the order
in which the InnoDB tables appear in the dump files, add
SET FOREIGN_KEY_CHECKS = 0;
to the beginning of the file before reloading it.
Our backups are quick large - over 500 MB. Opening the file an
Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 05:34:12PM -0500, Lewis Watson wrote:
I currently have three mysql machines replication from A-B-C-A type
fashion. I need to replace A. I am thinking that I could add D and have it
pull from C. Then once A is removed restart D as A. Is this a good way
Hi Victoria,
Read the bug report, but couldn't find if the problem was fixed in 4.0.14
or not...
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-269-76-62
On Wed, 17 Sep 2
Jeremy,
I don't think there's a huge difference in WinTel performance and Linux,
given the same hardware. Anyway, your application is so lightweight, it's
not really going matter very much. Ease of administration for you and your
client will be far more important.
Andy
> -Original Message-
Hei :)
I have an extreme performance problem with a MySQL-DB.
The database consists of 21 tables where all except three are storing only a
few records. Two have about 150.000 records but they are only used
temporary. The main table is rather huge, it has 90 columns and now after
three month it h
> > Pros? Cons? I know the windows box would need a good reboot now
> > and then and what is the performance hit on a WinTel 98/XP Pro
> > platform vs Linux? Looking at a 40K record database with maybe
> > 3 users at a time running 5-10 Large (length of the select
> > statment is over 500 chara
Hi Marcin,
have you tried using unicode?
Adam
On 09/17/2003 02:02 PM Marcin Giedz wrote:
Hi all,
My company(situated in Poland) produce cross platform software based on
Borland Delphi/Kylix. We also use mysql server to store all our date.Server
is configured with latin2 character set. Nowadays se
I am trying to select the firstname and surname fields from a table.
select firstname + surname fullname from people;
This does work in other databases but does not seem to work here.
Am I doing something wrong or is there a different way to achieve this with mysql?
Michael
I am trying to select the firstname and surname fields from a table.
select firstname + surname fullname from people;
This does work in other databases but does not seem to work here.
Am I doing something wrong or is there a different way to achieve this with
mysql?
Michael
--
MySQL Gen
- Original Message -
From: "Adam Hardy" <[EMAIL PROTECTED]>
To: "Marcin Giedz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 18, 2003 11:34 AM
Subject: Re: Character set problem Linux - Windows
> Hi Marcin,
> have you tried using unicode?
Not yet Adam but though
On 18 September, 2003 11:56, Michael Piko [SMTP:[EMAIL PROTECTED] wrote:
> I am trying to select the firstname and surname fields from a table.
>
> select firstname + surname fullname from people;
>
try:
select concat(firstname,surname) as fullname from people;
HTH,
Mark
-
Matthias,
Can you send us your table index definitions and the output of an EXPLAIN
command on your query?
ie
DESCRIBE pool;
SHOW INDEX FROM pool;
EXPLAIN SELECT sendnr FROM pool where sendnr = 111073101180;
I'm pretty sure we can improve this - I've got a table with 55 million
records (though o
Michael
--Original Message-
> I am trying to select the firstname and surname fields from a table.
>
> select firstname + surname fullname from people;
>
> This does work in other databases but does not seem to work here.
>
> Am I doing something wrong or is there a diff
Does anybody know of any issues when have a large (+1000) databases in
MySQL?
It will be running on RedHat 9. Would there be any problems running backups
with this many DBs on
one box?
Regards
Richard
- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Se
Hi,
I have a large MyISAM database with 22 million rows. The MYD file is now 4
GB in size, and the MYI file is 2 GB. I am constantly adding rows to this
database and rarely deleting any. Thus the database size grows constantly.
MySQL seems to increase the database files (MYD/MYI) in very small
in
Bogdan TARU <[EMAIL PROTECTED]> wrote:
>
> Read the bug report, but couldn't find if the problem was fixed in 4.0.14
> or not...
>
Yes, it's fixed.
http://www.mysql.com/doc/en/News-4.0.14.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is s
Hi,
Someone asked me if it were possible to do the following SELECT
statement in MySQL.
I am sure we need a workaround for this.
Can someone please offer any clues or even answers?
The statement:
SELECT ename, empno, mgrnr, job
FROM emp
START WITH job = PRESIDENT""
CONNECT BY PRIOR empno = mg
Do you use indexes?
See http://www.mysql.com/doc/en/CREATE_INDEX.html.
In my system a retrieval from a 24 million records table (3 columns) with a
result of 25 records only took 0.09 sec and 24 million records table with 5
columns 0.25 sec
Harald
- Original Message -
From: "Schonder, M
Abs,
On Thu, Sep 18, 2003 at 08:35:25AM +0100, Abs wrote:
> --- Daniel Kasak <[EMAIL PROTECTED]> wrote:
> > Abs wrote:
> >
> > >mysql and php question:
> > >the magic_quotes_gpc is set to 1. when i echo it to
> > >the browser, it shows the added slashes. i inserted
> > >these same values into a
Piko,
Please see http://www.mysql.com/doc/en/String_functions.html for more
information about String functions in the SELECT. The function you're
looking for is CONCAT or CONCAT_WS.
Harald
- Original Message -
From: "Michael Piko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursd
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,&color
The data is as follows:
j2400 S BLK j2400blk.jpgBlack Jacket12.00 24.00 Jacket
I have only one thing to say really on this. Data never has any meaning at
all. It is simply data, and not information. Information is extracted from
data and is then given meaning by the viewer of the data.
In the case of NULL I have always thought of it is simply "undefined". Thats
what Orecal s
> The main table is rather huge, it has 90 columns and now after
> three month it has 500.000 records... but in the end it has to store data of
> 36 month.
Hmm, I think you had better look at normalizing your data, and creating
indexes. Start with the indexes since that won't force you to make an
Hello,
I started getting this error since I upgraded from mysql 4.0.13 to 4.0.15:
030918 7:17:13 InnoDB: Error: page 12412 log sequence number 0 670697749
InnoDB: is in the future! Current system log sequence number 0 186563990.
InnoDB: Your database may be corrupt.
any idea how to get rid of t
Hi Jamie:
Thank very much you for your help.
EDWIN LIMACHI N.
DATACOM - Instalaciones
TSE - INFONET BOLIVIA
Phone. 591-2-2123978
Movil: 591-715-29967
Fax: 591-2-2123975
"James M Kupernik" <[EMAIL PROTECTED]>
17/09/2003 21:01
Por favor, responda a
<[EMAIL PROTECTED]>
Para
<[EMAIL PROTECT
Hi All,
I'm designing a rather large database, and I'm concerned about performance.
Was wondering if anyone had any comments/advice?
The particular table I'm concerned about will have about 10 million lines,
each referencing a physical item I need to track. Each item in the table
will have a auto
Patrick Shoaf <[EMAIL PROTECTED]> wrote:
> I have a table name product defined as follows:
> Item_Code
> Item_Size
> Item_Color
> Item_img
> Description
> Cost
> Retail_Price
> Category
> and other non-essential items, such as qty based on code,size,&color
>
> The data is as follows:
> j2400 S
I don't see anything in there that is relevant to the original posting.
Andy
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
> Sent: 18 September 2003 14:04
> To: [EMAIL PROTECTED]
> Subject: Re: Platform vs. Performance
>
>
> In article <[EMAIL PROTECTE
Hi all!
(My apologies if this has been beaten to death allready, but I *did*
search the archives without much luck.)
I'm moving from MS SQL to MySQL. Before jumping from the old server, I
scripted out the definitions for tables and their fields, thinking I
might just run them into MySQL. Guess
Hi, All!
SQL, mysql
I have 2 servers. 1-st is master, 2-d - slave.
But slave store only some tables of master.
For example, master has tables A, B
But slave has only A table
The problem:
query: UPDATE A,B SET A.a=B.a WHERE A.c=B.c;
the result: crash replication on slave;
Is it right?
Best
Most likely you'd need to do some datatype mapping changes to the
script...
Everyone I know who's had to do this has typically used something like
sqlyog (search google) and used the ODBC import cabability to transfer
data from MSSQL -> MySQL..
On Thu, 18 Sep 2003, Tormod Halvorsen wrote:
> Hi
no problem for me... 1000+ DBs on RH linux (ext3 fs), then moved it to
freebsd 5.1 (almost 1500). Linux is probably faster because of the
kernel based thread, but I like BSD.
You definetely have to tune your my.cnf... use thread and query cache,
increase the key buffer, optimize tables very oft
I'm pretty sure you need to sync the entire database (all tables) to all
slaves before starting replication..Your servers are technically
already out of sync..
And no wonder it crashes, tables are missing in it's view..You need to
hit the initial replication setup manual pages..
On Thu,
I am using the following command to load a table:
LOAD DATA LOCAL INFILE "email.txt" INTO TABLE email;
The command works and the second and third column go in correctly. But the
first column is not loading correctly. I am using Notepad on WIN ME to
generate the txt file.
JohnDoe[EMAIL PRO
Tormod,
I feel your pain brother! Actually, I do this allot more than I'd prefer to
admit.
I assume when you say MS SQL you mean SQL Server 2000. When you say MySQL,
you mean MySQL 4.0.x. Scripting the database/tables from query analyzer
doesn't produce files, which are immediately executable in
Hello
I hope you can help with this enquiry.
I have a small access db split front and back end used by a small group. I
would like to convert it to MySQL but my only knowledge is with access. I
would also like to investigate the possibilty of producing small db for
other people. I accept that i w
> I don't see anything in there that is relevant to the original posting.
The tables headed "Speed difference between different SQL servers (times in
seconds)"
The top row of each table shows times for the same operation on Linux and
Windows, showing that for both operations tested, Linux achi
Alec,
My point was that in a 40,000 row database, server speed is irrelevant -
it's going to be sub second on anything more powerful than my mobile phone.
Cost of ownership is much more important for this application, and that
depends on the particular circumstances.
Andy
> -Original Messag
Hi, All!
SQL, mysql
Sorry. I am wrong. Situation is worse.
Both tables aren't replicate to the slave.
But query try run it on slave :(
slave: mysql-4.0.13
master: mysql-4.0.14
>
> I have 2 servers. 1-st is master, 2-d - slave.
> But slave store only some tables of master.
> For example, master h
O.K., I understand. And I have always coded in this manner.
Throw the data at the system and see if it sticks. In most cases it will.
However, when it does fail, it would be nice to determine the error w/o
issuing more calls.
So, the school solution is, "When a unique constraint is violated,
Hi all,
for myisam tables we have "optimize table" that can be cronned to run at
night, but is there something like this for the innodb table type as well?
Franky
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
I have two tables. One table is 13 million rows the other is about 250,000. I am trying to join the two to find users. The tables are not indexed and I know that will effect the speed, but the join never completes. I let it run for about 10 hours and the process was stuck in the "sending" state
from the manual:
-
7.5.12.3 Defragmenting a Table
If there are random insertions or deletions in the indexes of a table,
the indexes may become fragmented. By fragmentation we mean that the
physical ordering of the index pages on the disk is not close to the
alphabetical ordering of the
from the manual:
-
7.5.12.3 Defragmenting a Table
If there are random insertions or deletions in the indexes of a table,
the indexes may become fragmented. By fragmentation we mean that the
physical ordering of the index pages on the disk is not close to the
alphabetical ordering of the
On Thu, Sep 18, 2003 at 08:20:00AM -0700, Scot Campbell wrote:
> O.K., I understand. And I have always coded in this manner.
>
> Throw the data at the system and see if it sticks. In most cases it will.
>
> However, when it does fail, it would be nice to determine the error w/o
> issuing more
On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote:
> no problem for me... 1000+ DBs on RH linux (ext3 fs), then moved it to
> freebsd 5.1 (almost 1500). Linux is probably faster because of the
> kernel based thread, but I like BSD.
If you use LinuxThreads on FreeBSD, it's nearly
In the last episode (Sep 18), Allen said:
> I have two tables. One table is 13 million rows the other is about
> 250,000. I am trying to join the two to find users. The tables are not
> indexed and I know that will effect the speed, but the join never
> completes. I let it run for about 10 h
I already use linuxthreads for freebsd...
Do you think mysql would run well with the new threads for freebsd 5.XX?
Did anybody try it?
thanks
Jeremy Zawodny wrote:
On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote:
no problem for me... 1000+ DBs on RH linux (ext3 fs), then mov
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>
> Sorry. I am wrong. Situation is worse.
> Both tables aren't replicate to the slave.
> But query try run it on slave :(
>
> slave: mysql-4.0.13
> master: mysql-4.0.14
What replication options do you use?
>
>>
>> I have 2 servers. 1-st is master, 2
Allen wrote:
I have two tables. One table is 13 million rows the other is about
250,000. I am trying to join the two to find users. The tables are not
indexed and I know that will effect the speed, but the join never
completes. I let it run for about 10 hours and the process was stuck in
th
In the last episode (Sep 18), Gustavo A. Baratto said:
> I already use linuxthreads for freebsd...
>
> Do you think mysql would run well with the new threads for freebsd
> 5.XX? Did anybody try it?
I've been running mysql 4.1 on a -current box with likse threads and
haven't had any problems. I
"Tore Bostrup" <[EMAIL PROTECTED]> wrote:
>
> MySQL 3.23.36 (yeah, I know it's getting old...):
>
> What permission do I need to run the following query:
>
> REVOKE ALL
> ON mydb.* FROM 'sdaf'@'%';
>
> I get an error 1044:
> "Access denied for user: 'Admin@' to database 'mydb'"
>
> My user ha
It's not a continued access denied, because it can accept connections all
day long, but randomly it will just deny one, but the accept it on the next
try.
I've googled this problem to death, I don't know what else I can do
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wedn
At 11:17 AM 9/18/2003, you wrote:
It's not a continued access denied, because it can accept connections all
day long, but randomly it will just deny one, but the accept it on the next
try.
I've googled this problem to death, I don't know what else I can do
James,
Are you sure it's not something si
On Thu, Sep 18, 2003 at 12:49:09PM -0300, Gustavo A. Baratto wrote:
> I already use linuxthreads for freebsd...
Ah, okay. Most don't, which is why I mentioned it.
> Do you think mysql would run well with the new threads for freebsd 5.XX?
> Did anybody try it?
In theory, yes. In practice, not
"Chris" <[EMAIL PROTECTED]> wrote:
>
>Quick question... I need to be able to send a query like:
>
> select cd,fid,s_from,s_to from ima where '3355443200' between s_to and
> s_from
>
> Thats fine and all, but when I get my results I pull 2 records:
>
> MA smith 335544320 352321535
> BS m
Thank you,
I have checked all of the above. I have set the max connections to 200, but
that didn't help any. The connection per hour is not a factor because it
doesn't lock out the user, it just fails to authenticate, but as soon as you
refresh the page or try to connect via the command line to go
Recently, the great Heikki said that the following directive should also
defragment your InnoDB tables:
ALTER TABLE table_name TYPE=InnoDB;
How was it put...ah yes, a "table no-op".
Regards,
Chris
On Fri, 2003-09-19 at 01:32, Gustavo A. Baratto wrote:
> from the manual:
> -
> 7.5.12.3
"Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> wrote:
>
> I tried
> SELECT * FROM WHERE LIKE '%?%';
> to find out if german umlauts (???) are imported.
>
> In the resultset where some ds with '?' and some with 'y'.
> So the charset itself seems to be OK but why did I get 'y'.
> They sound some
Are these numbers still valid? Those documents are quite old - well
before the time of 4.0 being declared production ready and before the
inclusion of InnoDB tables. Since then, the Windows port has had a lot
of work done on it and many of the "TODO" sections at the bottom have
been taken care of.
We're running bi-directional replication between two servers running
MySQL 3.23.56.
One server being active the other a hot standby.
Wanting to switch to the hot standby I noticed that replication had
ceased on the HS server. The show slave status:
| 192.168.1.10 | mysql_replicator | 3309
Well I figured out what was going on, MS uses a LF,CR instead of just a Line
feed. The was corrupting the first column. I added a LINES TERMINATED BY
statement and put in the '\r\n'. Now everything works fine.
Thanks again.
- Original Message -
From: "upscope" <[EMAIL PROTECTED]>
To: "MySq
Somebody suggested that I create the cron job as a php scripts, so I
did:
include("dbinfo.inc.php");
$connect = MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable
to connect to the database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$insert = "INSERT INTO sys
What do you mean it doesn't release itself? Can you provide some free
examples of before and after then 5 min after that?
The indication from the content of the below message is that the PHP
version in use has a memory leak. 1st you need to make sure that the
memory is not being put into a cache p
Here's a snapshot from a mysql environment:
mysql> LOAD DATA LOCAL INFILE 'c:/mysql/miamibilling-Cash.txt'
-> REPLACE INTO TABLE ln_cash
-> FIELDS TERMINATED BY '|'
-> ENCLOSED BY '~'
-> LINES TERMINATED BY '\r\n'
-> ;
Query OK, 16374 rows affected (20.83 sec)
Recor
I have a database called abc-100 which seems to cause problems with
replication and importing sql files created with mysqldump.
First, if on the master we create a temporary table (because we
don't have subselects yet) it causes the slave to die with the
following.
Relay log says:
DROP /*!40005
Yes, you are correct. I was thinking that wouldn't be the case, but it makes sense now. I added indexes and then the query returned in a few seconds. Definitely have to have indexes.
Thanks!
Dan Nelson wrote:
In the last episode (Sep 18), Allen said:
I have two tables. One table is 13 milli
The same thing happens whether or not I use the PHP script or a standard
SQL script as described in my original post, so I don't think it is a
PHP problem. Below is two snapshots, one @ 2:06 and the second @ 2:11,
if this is hard to read due to formatting let me know and I can send it
to you as an
I'm not normally one to panic, and I know I can revert back to an old
3.23.57 version, but this is concerning and was hoping a guru could tell me
what is wrong here. After the rpm upgrade, all my databases show up (ie. In
phpMyAdmin for example), but they all show (-) for the tables -- in
otherwor
FYI
I want to share this with others JIC you didn't know. I asked a question
about slave compatibility between masters and slaves of different
versions. Here is the compatibility matrix chart found.
http://www.mysql.com/doc/en/Replication_Implementation.html
Master
Master
Master
Maste
Is there any way to see what MySQL is storing in memory? Like, for
instance, what is stored in the query cache, or at least what tables
have data stored in the query cache, and how much they have stored?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On Thu, Sep 18, 2003 at 12:44:10PM +0100, Haydies wrote:
> I have only one thing to say really on this. Data never has any meaning at
> all. It is simply data, and not information. Information is extracted from
> data and is then given meaning by the viewer of the data.
True. We were arguing about
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
several binary packages of the initial release of MySQL 4.0.15 did not
include the embedded server library "libmysqld.a", because of a
compile/linking error with the compilers used on these platforms. As a
workaround, the creation of the embedded
Sometimes I get this error on a slave... for unknown reasons
Error 'Incorrect key file for table: 'hasit'. Try to repair it' on query
'REPLACE INTO hasit
If there is a wish list could the error report 'db.table'?
Also why doesn't mysql automatically fix the error itself when the error
I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field
SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size
SEPARATOR ";") as sizes,Item_Img,
Description,Category,Retail_Price,Short_Desc,Product.Item_Color
FROM Cat_Items,Product
WHERE cat_code ="BoltTech" an
Hi,
I have a server which has been running for about a year now. It
started with kernel 2.4.19 and mysql 3.x it has since been continually
upgraded so that it is now kernel 2.4.20 and mysql 4.0.13. The server is
a Compaq server with dual Pentium II (Deschutes) 400MHz 512Kb cache
CPUs, 320Mb RAM an
On Thu, Sep 18, 2003 at 01:14:47PM -0400, Christopher Ferry wrote:
> We're running bi-directional replication between two servers running
> MySQL 3.23.56.
>
> One server being active the other a hot standby.
> Wanting to switch to the hot standby I noticed that replication had
> ceased on the HS s
Ok. I looked through google and saw a couple examples of how to find the duplicates in a table that looked like this...
SELECT date, time, id, count(*) as n from session GROUP BY date,time,id
HAVING n > 1;
Ok. So I tried it. I have a table of 13,128,178 rows (not a small example). I ran a DIST
At 4:22 PM -0500 9/18/03, Allen wrote:
Ok. I looked through google and saw a couple examples of how to
find the duplicates in a table that looked like this...
SELECT date, time, id, count(*) as n from session GROUP BY date,time,id
HAVING n > 1;
Ok. So I tried it. I have a table of 13,128,178 r
DISTINCT key_field is fine. I don't think it will make a difference. My example was using only one field.
Paul DuBois wrote:
At 4:22 PM -0500 9/18/03, Allen wrote:
Ok. I looked through google and saw a couple examples of how to find
the duplicates in a table that looked like this...
SELECT
On Thu, Sep 18, 2003 at 03:00:17PM +1000, [EMAIL PROTECTED] wrote:
> Hi there i have a couple of projects which required fulltext searching so
> was unable to setup innodb on these. I was wondering if lock tables is a
> secure way to make the transaction on these tables and does this prevent
> bein
At 1:43 PM -0400 9/18/03, Randy Chrismon wrote:
Here's a snapshot from a mysql environment:
mysql> LOAD DATA LOCAL INFILE 'c:/mysql/miamibilling-Cash.txt'
-> REPLACE INTO TABLE ln_cash
-> FIELDS TERMINATED BY '|'
-> ENCLOSED BY '~'
-> LINES TERMINATED BY '\r\n'
-> ;
On Thu, Sep 18, 2003 at 01:57:17PM +0300, Mikko Noromaa wrote:
> Hi,
>
> Is it possible to configure MySQL so that it would allocate a large amount
> of extra space for the MYD/MYI files, and then use this space as necessary?
I don't know of any.
> This way the files would need to be grown only
On Thu, Sep 18, 2003 at 02:53:29PM -0400, Gabriel Ricard wrote:
> Is there any way to see what MySQL is storing in memory? Like, for
> instance, what is stored in the query cache, or at least what tables
> have data stored in the query cache, and how much they have stored?
Nothing other than wha
rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
try.
On Fri, 2003-09-19 at 08:01, Jeremy Zawodny wrote:
> On Thu, Sep 18, 2003 at 03:00:17PM +1000, [EMAIL PROTECTED] wrote:
> > Hi there i have a couple of projects which required fulltext searching so
> > was unable to setup
At 4:56 PM -0500 9/18/03, Allen wrote:
DISTINCT key_field is fine. I don't think it will make a
difference. My example was using only one field.
Your example was using three fields by my count.
DISTINCT field1 is likely to yield a different result than
DISTINCT field1, field2, field3. What form
Harald,
How often do you read 200 rows by key in a daya to day application?
How often do you insert 350768 rows in an application that you're
considering Win98 as the platform?
I've never deployed MySql on Wintel, except for developing on my laptop. I
always use Solaris or Redhat for serious
I'm not quite sure why I haven't run across this in the past, but now that I
have I am stumped. I am needing to update a table based on criteria found in
it and one other table, but I am uncertain how to proceed. If I had
subselects I would run the query as follows, I believe:
UPDATE suppliercatl
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: electroteque [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, September 17, 2003 6:38 PM
-->To: [EMAIL PROTECTED]
-->Subject: Re: Lock t
At 11:38 AM +1000 9/18/03, electroteque wrote:
rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
try.
Rollback *doesn't* work with MyISAM, that's why Jeremy said you have
to put the necessary logic in your application if you want to achieve
the same effect.
At least, that's wha
At 5:14 PM -0500 9/18/03, <[EMAIL PROTECTED]> wrote:
I'm not quite sure why I haven't run across this in the past, but now that I
have I am stumped. I am needing to update a table based on criteria found in
it and one other table, but I am uncertain how to proceed. If I had
subselects I would run t
Hi,
No, ROLLBACK doesn't work with MyISAM. Jeremy meant that you can add
logic/code between LOCK/UNLOCK to "simulate" ROLLBACK. e.g. queries that
"undo" what you did if something goes wrong. Of course this won't cover
you if mysqld dies, is killed, or you lose the connection etc. as real
transacti
>
> No rollback does not work on myisam Jeremy was stating that you don't
> have to do what you suggested to implement a correct ROLLBACK in mySQL.
> Use INNODB.
>
> http://www.mysql.com/doc/en/COMMIT.html
>
>
Hmm if you got my other post i am trying to simulate innodb in myisiam for
projects tha
Righty, so if error unlock table hehe, i have found i need to produce my
error first then do a rollback for an error to display in php as it wouldnt
show a mysql error after a rollback, i guess i could add an unlock table in
my trigger error function too.
> At 11:38 AM +1000 9/18/03, electroteque
On Thu, Sep 18, 2003 at 11:38:17AM +1000, electroteque wrote:
> rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
> try.
No. That's what I meant about having to put extra smarts in your code.
It needs to be able to undo its actions.
> On Fri, 2003-09-19 at 08:01, Jeremy Zawo
1 - 100 of 121 matches
Mail list logo
