Ok, I've read the release notes, the manual, the threads on this
mailing list, installed/removed/re-installed about 5 times, tried
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc
867MHz, 768MB RAM). When I run configure, it tells me everything is
hunky-dory and that I should
We have a problem to have "a long life" for the temporary table on innodb
mode. We create the table, but after some minutes of inactivity the sistem
drops the table. My.ini in as follow. Which is the parameter to correct the
problem ?
Tks
Massimi
-
# Example mysql config file.
# C
You can find a number of good starting point data
models here:
http://www.databaseanswers.com/data_models
You might also check out some of the applications on
sites like www.hotscripts.com and www.sourceforge.net
to see how they have structured their database for
similar projects. (or maybe you wi
I would like to install MySQL on a Solaris 8(SPARC) system without the need to have
'root' previliges.
I've installed it into my own directory (ie./home/my_place/) with any problems. I'm
able to run'mysql_install_db and 'mysqld_safe' also without any problems.
BUT when I try to run something li
At 09:04 PM 1/21/2004, you wrote:
Thanks for good explnation.
Some more questions:
#1Does 'update' also create temporary table?
Definitely not. Otherwise if an Update changed a single row it would have
to create a temporary table, and of course it doesn't do that. Boy,
wouldn't that be slow.
One
> SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM tabletwo)
> ;
>
> On Wed, 2004-01-21 at 15:26, Randy Johnson wrote:
> >
> > This example is simplified. I hope you understand
> >
> > Each table has one field called ID which is an integer and is the
primary key
> >
> >
> > Table
Thanks for good explnation.
Some more questions:
#1Does 'update' also create temporary table?
#2What happend with old table after alter?
From: mos <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Kill "alter table" process? Date: Wed, 21 Jan 2004 19:1
I believe this would work
select table1.* table1 left join table2 on (table1.id=table2.id) where
tab2.id not null
The left join will match the values together. Null values are inserted
where matches are not made. Since 4 will not make a match null values
will be put in place of the table2 value
This example is simplified. I hope you understand
Each table has one field called ID which is an integer and is the primary key
Table 1
List of Programs
1
2
3
4
5
6
7
8
9
10
Table 2
Programs members have joined
1
5
8
Here is the scenario. I want to compare the values in table one
At 05:34 PM 1/21/2004, you wrote:
I run alter today on table with 380,000 records. 'Alter' was adding
column to the table. It took 10 minutes and server load went up to
15.
"alter table info add column interactive_email enum('on','off') NOT NULL
default 'on';"
Here comes my questions:
#1 If I ki
* jalil
> I need to get total number of all rows in a table and also select some
> rows from the same table. I know how to do this
> using two queries, but was wondering if there is any way to do it in one
> query (one trip to the database).
>From version 4 you can use the SQL_CALC_FOUND_ROWS opti
I run alter today on table with 380,000 records. 'Alter' was adding
column to the table. It took 10 minutes and server load went up to
15.
"alter table info add column interactive_email enum('on','off') NOT NULL
default 'on';"
Here comes my questions:
#1 If I kill the process after it was runnin
* Chuck Gadd
> Roger Baklund wrote:
>
> >>Either way, I was surprised to see the "like" to be in the top
> >>performers and "left()" to be last.
> >
> > I suppose the LIKE operator is optimized for the case when it
> > begins with a constant:
> >
> > mysql> select BENCHMARK(1000, 'dfsfsdfs' lik
Thanks for your fast response, I'll adjust the autocommit parametr, too, and
I'll will let you know if this improves the restore of my data base.
Greetings
Mikel
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Mikel -" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: Re: Too slow recovering
Roger Baklund wrote:
Either way, I was surprised to see the "like" to be in the top
performers and "left()" to be last.
I suppose the LIKE operator is optimized for the case when it begins with a
constant:
mysql> select BENCHMARK(1000, 'dfsfsdfs' like '%F%' );
1 row in set (3.43 sec)
MySql w
* ed aka emierzwa at micron.com
> I'm on WinXP, 2.6ghz. mysqld-nt Alpha 4.1.2
w2k, 0.6ghz, 3.23.30-gamma
> Either way, I was surprised to see the "like" to be in the top
> performers and "left()" to be last.
I suppose the LIKE operator is optimized for the case when it begins with a
constant:
I'm on WinXP, 2.6ghz. mysqld-nt Alpha 4.1.2
Either way, I was surprised to see the "like" to be in the top
performers and "left()" to be last.
Ed
---
* ed aka emierzwa at micron.com
> You could just use the benchmark function?
>
> select BENCHMARK(1000, 'dfsfsdfs' li
thanks for taking the time to look
best
bill
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 20:19
To: [EMAIL PROTECTED]
Cc: Bill - compuserve
Subject: Re: select count from three tables
* Bill - compuserve
> Thanks for the suggestion but un
* ed aka emierzwa at micron.com
> You could just use the benchmark function?
>
> select BENCHMARK(1000, 'dfsfsdfs' like 'F%' ) /* 0.45 sec. */
> select BENCHMARK(1000, 'dfsfsdfs' between 'F' and 'Fzzz' ) /* 0.55
> sec. */
> select BENCHMARK(1000, left('dfsfsdfs',1)='F' ) /* 0.79 sec.
Grzegorz Paszka <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I use MySQL 4.0.17 from rpm.
> When I want insert new row by perl script to one of my table I get such error :
> DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by
> ...' for key 3
> Table looks :
> mysql>
Alex,
- Original Message -
From: ""Zeltser, Alex"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 21, 2004 10:28 PM
Subject: RE: InnoDB locking 'non-existence' of a row
> Hello Heikki,
>
> Thank you for your reply and your explanation. It clarifies thi
I need to get total number of all rows in a table and also select some
rows from the same table. I know how to do this
using two queries, but was wondering if there is any way to do it in one
query (one trip to the database).
Thanks,
-Jalil
--
MySQL General Mailing List
For list archives: htt
mysql> SHOW TABLES;
Hope this helps.
~~Nick
--- On Wed 01/21, Seena Blace < [EMAIL PROTECTED] > wrote:
From: Seena Blace [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 21 Jan 2004 13:03:51 -0800 (PST)
Subject: SELECT
Hi,How to see all tables in connected database?thx -seena
\u
SHOW TABLES
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
Ninety percent of this game is half mental.
- Yogi Berra
---
> -Original Message-
> From: Seena Blace [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 21, 2004
Hi,
How to see all tables in connected database?
thx -seena
-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
You could just use the benchmark function?
select BENCHMARK(1000, 'dfsfsdfs' like 'F%' ) /* 0.45 sec. */
select BENCHMARK(1000, 'dfsfsdfs' between 'F' and 'Fzzz' ) /* 0.55
sec. */
select BENCHMARK(1000, left('dfsfsdfs',1)='F' ) /* 0.79 sec. */
The times go up a little if the strings
In the last episode (Jan 21), Steve Edberg said:
> At 12:17 PM -0600 1/21/04, Joseph S Brunzelle wrote:
> > I'm try to write a query that will return the number of times a
> > specified character appears in a string (I want known how many
> > times the character "M" appears), but I cannot seem to f
Chuck Gadd said:
> Balazs Rauznitz wrote:
>
>> mysql> select count(*) from sex where id>459000 and id <=46
>> and sex = 'M'; +--+
>> | count(*) |
>> +--+
>> | 504 |
>> +--+
>> 1 row in set (5.09 sec)
>>
>> Any way to make this faster ?
>
> Well, MySql can only use 1
* Bill - compuserve
> Thanks for the suggestion but unfortunately this seems to produce the
> product of the two tables `lghyperlink` and `lgsearch`.
Yes, sorry about that.
[...]
> Any other suggestions gratefully received - maybe this has to be
> done in two queries and the data manipulated in t
Does anyone know if this or mycc has been compiled for Mac OS X?
On Wednesday, January 21, 2004, at 10:40 AM, Hassan Shaikh wrote:
Hi,
I've learned from fabFORCE.net that DB Designer 4 is bought by MySQL
AB. Could any one from MySQL AB please comment on the new acquisition
and shed some light
Balazs Rauznitz wrote:
However when the 'sex' column is involved:
mysql> select count(*) from sex where id>459000 and id <=46 and sex = 'M';
+--+
| count(*) |
+--+
| 504 |
+--+
1 row in set (5.09 sec)
Any way to make this faster ?
Well, MySql can only use 1 index
* Hassan Shaikh
> Which one of the following statements is more efficient?
>
> SELECT * FROM COUNTRY WHERE LEFT(CNNAME,1)='B';
>
> Or
>
> SELECT * FROM COUNTRY WHERE CNNAME LIKE 'B%';
The second statement will normally be the most effective, because the server
don't need to perform a function on t
Hi,
I am trying to find out that if I have a table without any Foreign keys and
I am doing a lot of Inserts to it, should the performance be different if I
have indexes or not? If I don't have any indexes, shouldn't I expect the
performance for the Inserts to be better than it would be if I had
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
Hello Heikki,
Thank you for your reply and your explanation. It clarifies things and explains some
of the
unexpected behavior I've observed (such as my own inability to insert to the gap after
locking it).
In general, is there a place where I can find a good discussion on the various locks
us
Hi All,
Which one of the following statements is more efficient?
SELECT * FROM COUNTRY WHERE LEFT(CNNAME,1)='B';
Or
SELECT * FROM COUNTRY WHERE CNNAME LIKE 'B%';
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hi,
I've learned from fabFORCE.net that DB Designer 4 is bought by MySQL AB. Could any one
from MySQL AB please comment on the new acquisition and shed some light on integration
plans with MySQLCC?
Thanks.
Hassan
Mikel,
- Original Message -
From: "Mikel -" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 7:19 PM
Subject: Re: Too slow recovering mysqldump files
> I'll set up those parameters in my.cnf and try again the recovery from the
> dump
Hello!
If you live in europe or in the states you can get SuSE 9, for 79$ the
box, i recently spent cristhmas in the states and see SuSE boxes every
where i went i even saw suse boxes in wallmart :s
SuSE is quite a nice choice IMHO.
On Wed, 2004-01-21 at 14:49, Ferguson, Michael wrote:
> Openna
At 12:17 PM -0600 1/21/04, Joseph S Brunzelle wrote:
I'm try to write a query that will return the number of times a specified
character appears in a string (I want known how many times the character "M"
appears), but I cannot seem to figure out how to do that. The select
statement is the followin
SuSE Pro. Automatic online updates/bugfixes. Cheap. Only pay for the
support you need. I've been running MySQL on SuSE for 18+mths with no
problems, and SuSE in general for about 3 yrs for allsorts of thing.
Steve
[EMAIL PROTECTED] wrote:
Hello,
For some time we've been running MySQL (from 4.
Thanks for your input on all points. Let me explain my suggested setup
first and then tell me if it still seems absurd.
Point 1: We have an isolated network performing critical functionality.
This network has absolutely no connectivity to the outside world/internet
Point 2: Data from this ne
wow, one post, two mistakes. how right you are. sorry.
update 02093_xdir_links SET title = REPLACE("\"","",title);
you may/may not need to escape the ".
hth
Jeff
> >you should be able to use STR_REPLACE.
> DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
> jd
>
> >update 02093_xdir_links SET title = REPLACE("*","",title);
Thank you very much for responding. Sorry to be dense but will this SQL
find only those records with data in the TIT
Openna.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 11:55 AM
To: [EMAIL PROTECTED]
Subject: Redhat Alternatives for MySQL
Hello,
For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat
(v. 7.2 & 9.0). We us
i've never used MT, but this kinda sounds as if you dont have the DBI
installed:
$ perl -MCPAN -eshell
install DBI
cheers,
M.
tait sanders wrote:
hi all,
not sure if this is the appropriate place to post this -- so please
point me in the right direction if not here...
I have a G4 with os10.3.2
Hello,
For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat (v. 7.2 &
9.0). We use our linux server for one thing: MySQL server.
We are far from linux experts, so Redhat made sense, particularly the ease of
installation and the bugfixes via up2date. Now that Redhat is endi
Thanks for the suggestion but unfortunately this seems to produce the
product of the two tables `lghyperlink` and `lgsearch`. e.g. if user bill
and 10 entries in `lghyperlinks` and 15 entries in `lgsearch` then what is
returned is
username clicks searches
==
bill 1
I'm try to write a query that will return the number of times a specified
character appears in a string (I want known how many times the character "M"
appears), but I cannot seem to figure out how to do that. The select
statement is the following:
SELECT structure_aa_sequence from structure where
>you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
>update 02093_xdir_links SET title = REPLACE("*","",title);
>hth
>jeff
"Bob Cohen"
<[EMAIL PROTECTED]To:
<[
you should be able to use STR_REPLACE.
update 02093_xdir_links SET title = REPLACE("*","",title);
hth
jeff
"Bob Cohen"
* Zaxpaw
> I am getting a syntax error from MySQL when executing the following
> query (names substituted):
>
> Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
> WHERE Another_ID='1');
>
> What is going wrong?
Version 3.x does not support sub-selects.
> My guess is that the
The one major design spec, my management has requested, is lack of TCP/IP
connectivity between the two servers using the data. One network is
completely isolated from the outside world/internet, however we are trying
to find a secure way to allow outside users to query historical data that
current
In the last episode (Jan 19), [EMAIL PROTECTED] said:
> Could someone please tell me if tyhe following is possible or if a solution
> accomplishing the same thing is available?
>
> I would like to build a database using two MySQL servers accessing
> the same physical file on a common Drive attache
As to the direct question of two servers accessing the same file via SAN, I
don't know. But here is an option we are using.
I have two Linux Servers, a Web Server & and SQL server. Our web server
resides on both the internal & external networks (two nics), with some
firewall software installed
I am getting a syntax error from MySQL when executing the following
query (names substituted):
Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
WHERE Another_ID='1');
What is going wrong?
My guess is that the SELECT is considered a subquery, but how else do
you get the "sele
I'll set up those parameters in my.cnf and try again the recovery from the
dump file. I'll hope these changes make faster the recovery.
Thanks again Heikki,
Mikel
P.S. Do you recommend the innodb hot backup tool, does it do faster than the
other options, or is a combination of both?
From: "He
* compuserve aka Bill Stennett
> I have the following situation:
>
> the DB has three tables 'users', 'links' and 'searches'. Each table has a
> common key named 'userid'
This does not match the table/column names you describe below... are you
trying to confuse us? ;)
> What I want to do is, for
* Noamn
> The query itself executes quite fast, but as it's one of the most
> frequently executed queries in the entire program, I thought it
> important to make it as fast as possible.
Have you considered changing the status column to an ENUM, and drop the
status table? (maybe not practical becau
Ah, I forgot to dump the 'mysql' db. Thanks so much, Mikhail, for waking
me up :).
Bing
> Hi,
>
> since MySQL stores stored procs in "mysql" db you need to make backup of
> "mysql" db.
> But it would be nice to have a possibility to make backup of stored procs
> in
> readable format.
>
> Best re
Stored procedure versioning/backup/restoring has always been a pain in the butt for
all dbs that support them. What is done 9/10 times is the sql script that creates
them is stored, versioned, and used for backup...
now a 'show create stored procedure blah_blah' function would be nice... ;)
Sorry for the newbie question.
[Begin]$Groveling_non-programmer_string_of_excuses[End]. I imported a
bunch of records into a table. One of the fields came through bracketed
in double quotes, e.g., "field data". I want remove the double quotes
but not the data bracketed within. E.g., "field data"
I am using tables INNODB.
After one query, the MySQL does not liberate the LOCK, and when I try to
execute same query it appears the message.
#1205 - Lock wait timeout exceeded; Try restarting transaction
whait urgently one helps. thanks, Bruno
--
MySQL General Mailing List
For list archives
Hi,
since MySQL stores stored procs in "mysql" db you need to make backup of
"mysql" db.
But it would be nice to have a possibility to make backup of stored procs in
readable format.
Best regards,
Mikhail.
- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi All
I have the following situation:
the DB has three tables 'users', 'links' and 'searches'. Each table has a
common key named 'userid'
What I want to do is, for each user in the 'lguser' table I'd like to count
the number of corresponding records in EACH of the 'lghyperlink' and
'lgsearch' t
I'm testing backup and restore on MySQL 5.0. I did mysqldump first and
then dropped a table and a stored procedure on purpose. After doing
'mysql -h host -u user -p database < dump-file', the dropped table could
be restored back in the database. But the dropped procedure stayed
missing.
How sho
On Wed, 21 Jan 2004, Yves Arsenault wrote:
> Thanks for your response,
>
> I'm using ColdFusion along side of MySQL to server dynamic content to some
> websites.
>
> When I run the page that this code is in, I get an SQL syntax error:
> Syntax error or access violation: You have an error in your S
Yves Arsenault wrote:
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#'
and year(theDate) = '#session.year#'
Can the day() function be used in this way in the WHERE statement?
Yes, but only from version 4.1.1
Use DayOfMonth() or preferably Extract() (whic
root can only connect through localhost until GRANTed permissions over
the network.
Leave off the '-h inglewood'.
If you have not set the password yet, then you also should leave off the
'-p' option.
[EMAIL PROTECTED] wrote:
This is a new install of mysql 3.23 on a SuSE8.0 Box. I installd every
Thanks for your response,
I'm using ColdFusion along side of MySQL to server dynamic content to some
websites.
When I run the page that this code is in, I get an SQL syntax error:
Syntax error or access violation: You have an error in your SQL syntax near
'(theDate) = '31' and month(theDate) =
function can b used, but value parameter seems syntactically wrong, check
that.
'#session.month#' to '$month'
which is the language,u r using anyway?
- Original Message -
From: "Yves Arsenault" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 6:37 PM
Subje
Hi all,
I have an application that works fine with MySQL 3.23 and the C API (everything on
Linux and only on Linux).
I need now to support unicode (I mean chinese, japanese, russian... all kind of
characters) so I am converting the application to use wchar_t and wstring instead of
char and stri
Hello,
I have a client using a already made calendar component on my server...
The problem seems to be the SQL code.
This code works (i believe) with an MS Access or MS SQL server DB...
MySQL version is 3.23.58
The code is:
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and month(theDate)
Kittiphum Worachat <[EMAIL PROTECTED]> wrote:
>
> Try to set character set to other not latin1 with MySQL 5 (windows
> binary) it not work can some one tell me how to do this.
>
If you want to set character set on the server level, you should start mysqld with
--default-character-set option:
On Wednesday 21 January 2004 10:56, naga rajan wrote:
> hi, I had just installed mysql RPM in RedHat-9.
> It doesn't shows any errors but what nextstep i have
> to do work with mysql.
RT(f)M:
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Unix_post-installation
Pretty
hi, I had just installed mysql RPM in RedHat-9.
It doesn't shows any errors but what nextstep i have
to do work with mysql.
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com
--
Hi!
I'm using Visual Foxpro 6.0 for develop my application whitch is connected to
MySQL 4.1 via MyODBC (3.2.51) driver. I'm using several methods in my
program to monitor server state and switch from one server to another if
server or connection failure occurs. There is one big problem about
conne
On Wednesday 21 January 2004 10:20, naga rajan wrote:
> hi,
> i am trying to install Mysql in RH-9.I follow your
> instructions .But when i typed
Since you have RedHat, might I suggest that you use the RPM versions, which
are pre-compiled and should set everything up properly for you.
--
MySQ
hi,
i am trying to install Mysql in RH-9.I follow your
instructions .But when i typed
./configure --prefix=/usr/local/mysql
after some screens it displays
Starting mysqld daemonwith databases
from/usr/local/src/mysql-standard-4.0.17-pc-linux-i686/data
040121 11:55:41 mysqld ended
after th
Drop the 'sex_index'
Basically when you have few unique values in a column
indexing it doesn't always help.
I setup this table with the 1,000,000 random entries
and query time is nearly the same for your 2 queries
below.
CREATE TABLE sex (
id int(11) unsigned NOT NULL auto_increment,
sex ch
Hi.
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
Thanks
Dr.K
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Noamn wrote:
Judging by some of the comments posed on this list, I wonder whether the
following statements are true:
1. There is no point having an index on a field if that field can only have
a few values
Not for query speed reasons. There may be other reasons
(uniqueness for instance), but for
Ratna Rajesh Thangudu said:
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi14
1nmi14
1oo314
1oo314
1oo414
1oo414
I want to select those rows with 'size' 14, 32 an
Mikel,
what about playing with the autocommit setting?
I guess you use the mysql client for the restore, so you could set
autocommit off and perform a commit yourself every 1 rows or so.
In our case this boosts recovery by a factor of 5 to 10.
Regards,
Frank.
Mikel - schrieb:
>
> I
On Tue, 20 Jan 2004, Todd Burke wrote:
> Is there any way to disable replication of all temp tables using
> replicate-ignore-table or some other means? The names of the temp tables
> are generated randomly by a script. Thanks
If you could have all temporary tables starting with "tmp" or someth
Dear all,
Here I have a query...
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi14
1nmi14
1oo314
1oo314
1oo414
1oo414
I want to select those r
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
87 matches
Mail list logo
