Hi!
On May 10, Jan Pieter Kunst wrote:
Dear all,
I read the following on this page
http://dev.mysql.com/doc/mysql/en/server-system-variables.html:
bulk_insert_buffer_size
MyISAM uses a special tree-like cache to make bulk inserts faster for
INSERT ... SELECT, INSERT ... VALUES
Hello.
You may create my.cnf from the examples which're shipped with MySQL
distribution. MySQL will create the socket file if it doesn't exists.
It's location could be specified in configuration file or in command
line options. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
Hello.
See:
http://dev.mysql.com/doc/mysql/en/crashing.html
Chris Knipe [EMAIL PROTECTED] wrote:
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A SELECT without an ORDER BY returns the
rows in some undefined order. If you use LIMIT 3,4
Hi, everybody!
I have a problem working with MySQL and C++ Builder 6.
I can´t find the solution and I hope that maybe
somebody can help me.
I use the ZEOS components (6.1.5) to connect the MySQL
database (version 4.1.11) with C++ Builder. The fact
is that everything goes rigth except when I try to
oix ppl,
now I have a question.
I thougth that when you make a SELECT without an ORDER BY, the rows
were
returned in natural order, that would be some specific order (insertion
order, presence in file, I don't know, but the order would be always the
same).
Is this
[snip]
IF I use the following statement:
SELECT * FROM `items` WHERE `item` = 10902 HAVING `venturi_type`
= 'universal' OR `venturi_type` = 'special';
I get a complete and full data dump.
IF I change the statement by inserting a 'letter' in this case 'S'
instead of a 'number' in this case
Hi, Javier!
I don't know Zeos components but I use C++ Builder 6 and ODBC to connect to
MySQL and I had similar problem.
My databases had character set set to latin2 and problem was my client's
(C++ Builder and ODBC) character set.
Try to issue command SET NAMES 'your_WIN_codepage' (main was
Hello.
What output do these statements produce:
show variables like '%char%';
show variables like '%coll%';
Include the results of SHOW CREATE TABLE
executed on your tables as well.
Javier Ballesteros Correa [EMAIL PROTECTED] wrote:
Hi, everybody!
I have a problem working with
You should never assume that an SQL query will return data in any specific
order *unless* you use an ORDER BY to force the sequence of rows in the
result set.
Data returned by a query will sometimes appear to come out in a particular
order but you should always view this as a lucky coincidence,
Hi,
I've implemented my site search using MySQL db fulltext index. I
understand that fulltext index currently doesn't support stemming of
words.
However I want to implement my search such that a query containing
words in singular tense matches records of words in plural tense and
vice versa.
Is
No one ?
Please help me with this.
Gabriel
- Original Message -
From: Gabriel PREDA [EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 4:36 PM
Subject: Underline or minus sign ?
I'm going to start the InnoDB engine... and I want to know if the syntax
for
the CNF file unified at last ?
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the
following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when it is
executed
Gabriel PREDA wrote:
I'm going to start the InnoDB engine... and I want to know if the syntax for
the CNF file unified at last ?
Can I use:
innodb-file-per-table
no
instead of
innodb_file_per_table ?
this one (at least for 4.1.11)
[This is just an example]
Can I use only minus sign in the
Hello. I am receiving the following error when trying to insert into a
field of type text:
#1030 - Got error 139 from storage engine
The data to be inserted should fit easily into a text field. In fact, this
error only occurs for a particular record and other records with much
larger data sets
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when it
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when it
[snip]
Hello. I am receiving the following error when trying to insert into a
field of type text:
#1030 - Got error 139 from storage engine
The data to be inserted should fit easily into a text field. In fact,
this
error only occurs for a particular record and other records with much
larger data
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but
#1030 - Got error 139 from storage engine
The data to be inserted should fit easily into a text field. In fact, this
error only occurs for a particular record and other records with much
larger data sets are not throwing the same error. Has anyone experienced
something similar? I checked via
Hi,
Have you forgotten what's a primary key ?
Using order by will sort data, and if it's already sorted, it will be sorted
again. Time, memory and maybe disk io.
Using the marco example, i gaved a solution considering iy's what he wants. Till
now i don't know if it's ok or not.
if so, just add
Hello. Yes, there are. In fact, other records have more data for this
field in them and inserts for those records never threw an error.
- Asad
On Tue, 10 May 2005, Jay Blanchard wrote:
[snip]
Hello. I am receiving the following error when trying to insert into a
field of type text:
#1030
[snip]
Hello. Yes, there are. In fact, other records have more data for this
field in them and inserts for those records never threw an error.
[/snip]
Is the data for the other fields larger than usual? This field may be
smaller, but the cumulative row length (the combined size of every
field) is
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Hi,
Have you forgotten what's a primary key ?
Using order by will sort data, and if it's already sorted, it will be sorted
again. Time, memory and maybe disk io.
If MySQL really does that, I'd consider this a bug.
Using the marco
news [EMAIL PROTECTED] wrote on 10/05/2005 15:13:49:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Hi,
Have you forgotten what's a primary key ?
Using order by will sort data, and if it's already sorted, it willbe
sorted
again. Time, memory and maybe disk io.
If MySQL
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
CREATE TEMPORARY TABLE tbl1 (
id INT UNSIGNED NOT NULL,
val INT UNSIGNED,
PRIMARY KEY (id),
UNIQUE KEY (val)
);
INSERT INTO tbl1 (id, val) VALUES (1, 1);
INSERT INTO tbl1 (id, val) VALUES (2, 2);
INSERT INTO tbl1 (id, val) VALUES
Hi, Mr. Paharenko,
Here are the results:
character_set_client | latin1
character_set_connection | latin1
character_set_database | latin1
character_set_results| latin1
character_set_server | latin1
character_set_system | utf8
character_sets_dir | C:\Archivos de
Hi Jon, all!
Jon Earle wrote:
Joerg Bruehe said:
Still, this seems to be a problem with the header files supplied / used
by gcc. Are you sure you used the fixincludes script?
Hi Joerg,
I tried your suggestion as per:
cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/
mv include inc
cd
you need to install your distro's ncurses and ncurses-devel packages.
-Eric
ganesan malairaja wrote:
ok i found the source file ..
tarball
mysql-4.1.11.tar.gz
after executing the ./configure command
i does some checking the it gives this error
checking for termcap functions library ... configure :
Keep in mind that this file will only exist when mysqld is running.
Gleb Paharenko wrote:
Hello.
You may create my.cnf from the examples which're shipped with MySQL
distribution. MySQL will create the socket file if it doesn't exists.
It's location could be specified in configuration file or in
Hi Jon (again), all!
Jon Earle wrote:
Hi folks,
I need to get a version of MySQL running on AIX 5.1, but I see that the only
versions available are for v5.2 and v4.3.3.
Yes, currently we have build machines for these two only.
There are proposals to upgrade them to run AIX 5.1 and 5.3,
Here, off the top of my head are situations in mysql where you can trust
that the data is ordered in some fasion.
1. Using an order by clause on a query.
2. Using a group by the data will come out in ascending order of the
column that was grouped on.
3. alter table order by has been performed
Back in the day '_' and '-' meant different things. In recent versions
of mysql they are interchangable.
Philippe Poelvoorde wrote:
Gabriel PREDA wrote:
I'm going to start the InnoDB engine... and I want to know if the
syntax for
the CNF file unified at last ?
Can I use:
[EMAIL PROTECTED] wrote:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
That can't work as my initial query, because I don't know the location
of iTempID: 4 in the query result
to find the position 4, the query is :
mysql select
Can I setup a table so that no matter how data is entered into it (web form,
command line) The data in one of the columns ALWAYS gets converted to
uppercase? I remeber MSSQL had this feature of being able to apply a
function to a field in its configuration.
Thanks!
Matt
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A SELECT without an ORDER BY returns the
rows in some undefined order. If
Chris [EMAIL PROTECTED] wrote on 05/10/2005 12:20:57 PM:
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A
[snip]
Can I setup a table so that no matter how data is entered into it (web
form,
command line) The data in one of the columns ALWAYS gets converted to
uppercase? I remeber MSSQL had this feature of being able to apply a
function to a field in its configuration.
[/snip]
The manual, it is
[EMAIL PROTECTED] wrote:
Chris [EMAIL PROTECTED] wrote on 05/10/2005 12:20:57 PM:
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
Hello,
I am working on a database that deals with network statistics. I have
a program that generates web reports based on this data every ten
minutes.
The table layout looks something like this:
CREATE TABLE traffic
(
unix_secs INT UNSIGNED NOT NULL,
dpkts INT UNSIGNED NOT NULL
At 02:22 PM 5/10/05, Paul Halliday wrote:
Now, as time progresses the queires are getting slower and slower.
I know this is expected,
I don't think so. I thought that if the number of rows returned does not
change and an index is properly used, then query time should not change
significantly
Don't forget to run an analyze to adjust the statistics for the
optimizer/indexes. Also, after any updates (on dynamic tables which yours is)
or any deletes run an optimize.
Quoting Paul Halliday [EMAIL PROTECTED]:
Hello,
I am working on a database that deals with network statistics. I have
a
On Tue, 2005-05-10 at 14:56 -0400, Frank Bax wrote:
At 02:22 PM 5/10/05, Paul Halliday wrote:
Now, as time progresses the queires are getting slower and slower.
I know this is expected,
I don't think so. I thought that if the number of rows returned does not
change and an index is
I'm somewhat a newbee on this database but some observations:
As your table grows (and indexes) INSERTS will definitly slow because of the
indexes.
Consider MySQL's version of Oracle's partitioning and using MERGE TABLES
feature. Just remember that if you change 1 table, all of them have to be
Hi,
you have to play with explain to see which index is used in your queries.
Since you defined only mono-column indexes, i think they are not used in
queries with multi-criteria search.
Consider adding indexes with all used columns and eventually drop the not used
ones to not slow updates and
Excellent, I'll be waiting to see performance numbers, specifically for
FreeBSD vs. Linux.
Save for a few odd machines, we're pretty much pure FreeBSD and the last
releases in the 4 branch are really impressive as far as speed and
stability. That being said, the Opteron would have to offer a
We did something similar for our large statistic tables. The older data
that no longer changes would get shipped off into a very fast read only
table with a cron job and then that is the table we would generate the
reports on. Even with millions of entries it is incredibly fast.
Eric Jensen
On 5/9/05, Kevin Burton wrote:
So... it sounds like a lot of people here (Dathan and Greg) have had
problems deploying MySQL on Opteron in a production environment.
To me it sounds more like a lot of people have had problems running
Linux on x86-64 systems.
Jochem
--
MySQL General Mailing
Hello,
I have a query:
select * from table where del != 1;
Let's assume that I have a record where del is null (del is a single
character field).
In version 3.23.22-beta I get the record returned with the above query,
in version 4.1.10a I get nothing returned.
Did something change between
Hi,
'l' is neither equal to null nor different from null.
you can try select ('l'!=NULL) or select ('l'=NULL).
in 4.1.x you should write :
select * from table where del != l' or del is null;
mysql select * from tbl;
+--+
| del |
+--+
| NULL |
| a|
| b|
| l|
| m|
| l
Mike Rykowski wrote:
Hello,
I have a query:
select * from table where del != 1;
Let's assume that I have a record where del is null (del is a single
character field).
In version 3.23.22-beta I get the record returned with the above query,
in version 4.1.10a I get nothing returned.
Did something
Mike,
If 3.23.22 gave (NULL != 1) = TRUE, that was a bug, because in
SQL, (NULL != 1) is NULL.
This 3.23.26 change history item might be your culprit: "Fixed
`' to work properly with `NULL'."
PB
-
Mike Rykowski wrote:
Hello,
I have a query:
select * from table where del != "1";
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus increase the amount of data your hw can handle.
I have read
I think matt is thinking more automagically like having upper() called
on a column on insert for him instead of putting it into every query.
You can't do this yet. sorry.
-Eric
Jay Blanchard wrote:
[snip]
Can I setup a table so that no matter how data is entered into it (web
form,
command line)
[snip]
I think matt is thinking more automagically like having upper() called
on a column on insert for him instead of putting it into every query.
You can't do this yet. sorry.
[/snip]
Aha, I see. Needs a trigger or stored procedure.
--
MySQL General Mailing List
For list archives:
While you're at it, take a look at Gentoo Linux
(http://www.gentoo.org). I've been having very good luck with it on
everything from a Duron 1GHz to Opterons. Very responsive. It compiled
a kernel on an opteron in about 5 minutes.
Curtis
Atle Veka wrote:
Excellent, I'll be waiting to see
Subject: Re: Opteron HOWTO?!
On 5/9/05, Kevin Burton wrote:
So... it sounds like a lot of people here (Dathan and Greg)
have had
problems deploying MySQL on Opteron in a production environment.
To me it sounds more like a lot of people have had problems
running Linux on x86-64
I have a big whopping problem.g
I have a large database that generates 25gb tables (let's call them
GenTable1 to GenTableN). I'd like to put these tables on another drive
because I'm running out of disk space. If I need to create another database
(let's call it dbGen), so be it. (But it would
On 5/10/05, Roger Baklund [EMAIL PROTECTED] wrote:
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus
Care to share any secrets? You guys are running Suse w/ 2.4 kernel yes?
Any specifics as far as kernel/glibc/gcc versions. Are you running
mysql 4.1.*? Are you using NPTL? You using the binary from mysql, or
building yourself? Are you running Innodb or Myisam. You mentioned
reiserfs
I've upgraded from 5.0.2 to 5.0.3 Beta, and now there is a glitch in
one of my regular expression queries.
The expression works like this: a query for 'search' returns true for
a matching 'search' field, but, querying 's$$#e%ar^c)(h' must also
return true for a 'search' field. In other words, I
When you create the tables, you can specify the DATA DIRECTORY and INDEX
DIRECTORY clause while creating the table to specify different paths. Not
sure if it works on Windows though. Should be a simple enough test
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you
-Original Message-
From: Greg Whalin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 3:12 PM
To: Dathan Pattishall
Cc: Jochem van Dieten; mysql@lists.mysql.com
Subject: Re: Opteron HOWTO?!
Care to share any secrets? You guys are running Suse w/ 2.4
kernel yes?
Yes. We
Hi,
You can create a symbolic link on windows for one specific database.
i sent a thread about this. the doc is here :
http://dev.mysql.com/doc/mysql/en/windows-symbolic-links.html
Mathias
Selon Partha Dutta [EMAIL PROTECTED]:
When you create the tables, you can specify the DATA DIRECTORY
Greg Whalin wrote:
Care to share any secrets? You guys are running Suse w/ 2.4 kernel yes?
Any specifics as far as kernel/glibc/gcc versions. Are you running
mysql 4.1.*? Are you using NPTL? You using the binary from mysql, or
building yourself? Are you running Innodb or Myisam. You
I am trying to set up a chem structures table.
column 1 is the key, column 2 is the description, column 3 is the structure
which is a blob.
In PHP the first 2 columns comes out as text as expected, but the
3rd I am trying to tell PHP please ignore this initially since
this is a blob.
Should I
I have an ORDER statement like:
ORDER BY playlist.order_id ASC,RAND(playlistItems.playlist_order)
I am trying to get a random result very time the query is run ...
Unfortunately, this statement gives the SAME random result each time
how can I get mysql to randomly jumble the playlist items for a
is it possible a firewall is denying mysql to create the mysql.sock file
if not where i can get this file
i cannot find it in my entire harddrive
i am stuck at for days now
a clear guideline will help
i tried reading at the mysql.com
but no help .. i am new to linux.. anyone who had this
At 2:27 + 5/11/05, ganesan malairaja wrote:
is it possible a firewall is denying mysql to create the mysql.sock file
if not where i can get this file
i cannot find it in my entire harddrive
It's created by the server when you start the server.
It won't exist until then.
i am stuck at for days
the socket file is created in the spot specified in /etc/mysql/my.cnf.
In my case its:
socket = /var/run/mysqld/mysqld.sock
as always ymmv.
Curtis
ganesan malairaja wrote:
is it possible a firewall is denying mysql to create the mysql.sock file
if not where i can get this file
Getting a little stuck on this one:
Table defs below:
I have two tables, fedex_zones contains zip code to zone data, so for
example, zip 94947 is in zone 8
select zone from fedex_zones where zip = '94947'
8
Now, in the defex_rates table is how, based on weight, I can look up how
much it will
Scott,
...In part, my trouble is that I need to take the resuling zone
from the first
select and use that to determine the field name.
I can easily do this in my code in 2 selects, but was hoping to be
able to
get the price back in just one select, if possible...
If you have control over
got it to work
thanks
On May 10, 2005, at 7:22 PM, Graham Anderson wrote:
I have an ORDER statement like:
ORDER BY playlist.order_id ASC,RAND(playlistItems.playlist_order)
I am trying to get a random result very time the query is run ...
Unfortunately, this statement gives the SAME random
on 5/10/05 8:29 PM, Peter Brawley at [EMAIL PROTECTED] wrote:
Scott,
...In part, my trouble is that I need to take the resuling zone from the
first
select and use that to determine the field name.
I can easily do this in my code in 2 selects, but was hoping to be able to
get the price
74 matches
Mail list logo
