Hi!
> "Eric" == Eric Thelin <[EMAIL PROTECTED]> writes:
Eric> On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote:
>> I always get a syntax error when using INSERT_METHOD in creating merge
>> tables. If I leave off the INSERT_METHOD part it works fine. I have
>> tried this on many versions in th
Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 9:37 AM
Subject: Re: InnoDB transactions with Connection Pooling
> On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri w
I try to compile mysql-2.23.49 but configure process stopped for an error:
checking for termcap functions library... configure:error/No curses/termcap
library found
I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel.
Can you help me?
Thanks
Filippo Trocca
--
Hello!
You are my last chance, reading FAQs and asking in newsgroups gives no
effect.
I have a problem when connecting a MySQL table in MS Access (2000) through
MyODBC.
MySQL is ver. 3.23.44 running on FreeBSD 4.5 box.
Description of the problem:
I connect the table and Access correctly retri
Gelu wrote:
>
> Hi,
> I know , "sound" strange.I "life" the same experience and my problem was ,
> the first network switch, near the server machine(big responding time on
> the network - over 5.000 msec).What is was really oddly, not all the time
> the network have the same behaviour.
> The net
> - Original Message -
> From: "MySQL Newsgroup" <@[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 19, 2002 2:55 PM
> Subject: Re: Select with Order By that don't use my INDEX :(
>
>
> > Subject: Re: Select with Order By that don't use my INDEX :(
> > From: Vic Cekvenich
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote:
> Mark,
>
> if you do not explicitly do
>
> SET AUTOCOMMIT=0
>
> then MySQL automatically calls COMMIT after every SQL statement.
Make that:
SET AUTOCOMMIT=1
Heikki is probably low on coffee. :-)
Jeremy
--
Jeremy D. Zawodny, <
Mark,
if you do not explicitly do
SET AUTOCOMMIT=0
then MySQL automatically calls COMMIT after every SQL statement.
If you set AUTOCOMMIT=0, then you should yourself call COMMIT after each
SELECT so that you do not leave a dangling transaction open in the database
and that you get a fresh snap
On Sunday, 21. April 2002 20:54, Colin Faber wrote:
> it's my understanding that the latest revision of the manual is (minus
> 4.x commits) always included in the distribution set. New features
> are always documented in the manual and are nearly always appended
> with a "This was added in versio
Richard,
- Original Message -
From: ""Richard Harms"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, April 22, 2002 2:32 AM
Subject: InnoDB Error 150, MySQL 4.0.1 alpha & 3.23.49
> Hello,
>
> When attempting to create some tables using the MySQL 4.0.1 alpha and
> 3
Hello olinux,
If I were in your shoes, I would put not only paths to images into a separate
table, but also a field called "content" and probably title, summary,
author and linked all this stuff together via ID-like fields which are
primary keys in those new tables. Then articles table can be sea
>Description:
Very similar to a problem I reported more than 2 years ago, which
was then fixed in a subsequent release, it now appears that the index on
a column that is declared as decimal(14,2) is not being built correctly.
Dropping the index and re-creating it seems to fix the problem t
On Sun, Apr 21, 2002 at 06:21:33PM -0700, olinux wrote:
> Anyone have a good resource for mysql optimization tips? or just
> standard db optimization.
Well, there are a few things I wrote up last year:
http://www.linux-mag.com/2001-06/mysql_01.html
http://www.linux-mag.com/2001-12/mysql_01.
Hello,
I have a table with a large number of news articles.
Articles of type 'feature' (identified in the
article_type field) will have the path to an image
associated with the article stored. The question is
whether to 1) add a field to the database that most
records will not use OR 2) add a ta
yeah.. i've just been researching that subject myself..
it seems that db optimization is mainly about normalization..
check out this
http://www.devshed.com/Server_Side/MySQL/Normal
dan
- Original Message -
From: "olinux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 22
Anyone have a good resource for mysql optimization
tips? or just standard db optimization.
Thanks,
olinux
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 21, 2002 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: How to speed up mods to large table?
>
>
> I haven't been able to dig up any specific information about how to get
> maximum performance when maki
I haven't been able to dig up any specific information about how to get
maximum performance when making changes to large tables. I have a table
that's close to 4 GB, which I'm altering to come up with the best trade-off
between performance and speed. Dropping a column or an index seems
exceeding
In your implementation, using limit,
LIMIT ,<# to retrieve>
so you would want $name="2,1"
-Brenden
On Sun, 2002-04-21 at 17:05, Jule Slootbeek wrote:
> Hey guys,
> I have a, for you simple, newbie question.
>
> my query is SELECT * from $TableName LIMIT $name
>
> now $name goes from 1 to 4
Hello,
When attempting to create some tables using the MySQL 4.0.1 alpha and
3.23.49, I'm getting a generic error message, "General error: Can't
create table './industria/ORDEREDITEMS.frm' (errno: 150)." The other 6
tables, all using similar features, are created without a problem.
perror just sa
Hi, I am interested to know if there was any comparisions made between
windows and unix mySQL ? What is the performance difference in comparable
hardware and same version of mySQL running on unix vs windows ? If anyone
can offer some help/insights/pointers I will appreciate it very much. I
realize
From: Kevin Fialkowski <[EMAIL PROTECTED]>
> ...so that I can access it from another machine.
Hi Kevin,
This isn't a matter of how you start the service, but of your user privileges. Users
are not only known by user name and password, but also by the host they are coming
from.
Start with th
Hey guys,
I have a, for you simple, newbie question.
my query is SELECT * from $TableName LIMIT $name
now $name goes from 1 to 4, the 4 rows in my database, but i just want the
query to give me one row, not say if $name is 2, rows 1 and 2, just row 2.
How do i do this?
thanks,
Jule
--
Jule Sl
I have the standard tarbal install of mysql. I want to know how do I start
the server so that I can access it from another machine. I am running on a
linux 6.2 server where the local ip address of the box is 192.168.1.150 and
the hostname is MysqlServer. I need to be able to change the host that
Hi benjamin/Sven,
it's my understanding that the latest revision of the manual is (minus
4.x commits) always included in the distribution set. New features
are always documented in the manual and are nearly always appended
with a "This was added in version " string some
place.
Benjamin Pflugm
...winner will be announced January 31, or sometime in February.
Did I miss something?
What is the Dolphin's name?
Steve the mysql data guy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
I have a question about how to optimize MySQL performance for a somewhat
unusual (I think) usage pattern.
In the first process, I'm summarizing a large amount of time series data
(the main table will end up around 5GB, index around 1/3 of that) and
storing the summaries to the db. During thi
Hi,
You use and two different mysql_init ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Andrey Kotrekhov <[EMA
-Original Message-
From: zlab1 [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 21, 2002 13:50
To: MySQL Mailing List ([EMAIL PROTECTED])
Subject: Problem with HAVING
Hi,
I'm running Mysql 4.01 on mandrake 8.2 with all production data
using InnoDB type.
I've a field named "dch_pri
Joe:
Here is what we do ...
- Login as Administrator
- Open DOS Prompt, switch to the drive with MySQL on it, and CD\MYSQL\BIN
- Type MYSQLD-NT --INSTALL
- Type NET START MYSQL
If that doesn't do the trick, your C:\WINNT\MY.INI (or C:\MY.CNF) may not be
correct. Most coomon mistake is to use th
Hi,
I know , "sound" strange.I "life" the same experience and my problem was ,
the first network switch, near the server machine(big responding time on
the network - over 5.000 msec).What is was really oddly, not all the time
the network have the same behaviour.
The network interfaces , mounted o
At 23:34 -0500 4/20/02, Darren Vollmer wrote:
> > >Both files are world readable.
>>
>> How do you know this?
>
>Because FTP tells me they are.
>
>>
>> Also, when you say "client machine", what do you mean? In particular,
>> are the web server and the MySQL servers running on the same machine
hey.
I have a little question (hope somebody can help me
out)
I search for a script/tool/... to write mails into a
mysql db. (I know there is a perl script mail2db.pl,
but i cant find it)
Or better is there a script for fetchmail to write the
mails direct to the mysql db
Big thx for your help
Can anybody explain how to start MySQL on Windows 2000? I've moved and
renamed the my.ini file to C:\my.cnf - to no avail. I get the following
messages displayed in the "Err File" tab of WinMySQLadmin:
020421 5:22:28 MySql: Got signal 11. Aborting!
020420 8:41:09 MySql: Shutdown Complete
An
Hi,
You can use "show full processlist" to see what table is locked and "unlock
tables";
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Origin
Hello.
On Sun, Apr 21, 2002 at 02:15:33PM +0200, [EMAIL PROTECTED] wrote:
[...]
> > I assume you are referring to the online manual? It's documenting the
> > most recent version. According to the change history (Appendix D),
> > this optimization was introduced in version 4.0.2.
>
> I see, thank
Hello, All!
I have program which try to connect to different mysql servers twice at
the same time.
When I use libmysqlclient.so sometimes one or two mysql connection freeze
in mysql_real_connect
But when I try to use libmysqlclient_r.so
program crash in my_fopen
this is stack of program :
(gdb)
From: "Andrew Rich" <[EMAIL PROTECTED]>
> Howdy, how can I add an extra field to an already created table in sql ?
ALTER TABLE tablename ADD columnname attributes
See http://www.mysql.com/doc/A/L/ALTER_TABLE.html for more details.
--
denonymous
www.coldcircuit.net
--
On Sun, Apr 21, 2002 at 02:44:32PM +0200, Roger Baklund wrote:
> * Sven Huster
> >
> > This manual is f@#$% up, since it seems like there is no manual for
> > stable versions online or at least some annotations that say in which
> > version a feature was introduced (it's not nice to lookup every c
On Sat, Apr 20, 2002 at 05:16:46AM +0200, Benjamin Pflugmann wrote:
> Hi.
>
> [...]
> > According to the MySQL doc (5.2.7, example 5) this should work
> > using the index without any additional sorting.
> >
> > MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE
>
> I assume you are referring
Howdy, how can I add an extra field to an already created table in sql ?
Andrew rich
-Original Message-
From: Sascha Kettner [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 21 April 2002 9:29 PM
To: [EMAIL PROTECTED]
Subject: Number pickup with parallel updating? with script!
Hi!
I have a sm
Hi!
I have a small problem:
a have a database containing three fields
number, timestamp, used
i allready inserted into the "number" fileds about 50.000 random and
unique numbers - timestamp and used are empty
With my perl script i have to do the following:
look into the database for the first
42 matches
Mail list logo
