Hi all.
I'm pleased to announce the 4rd release of Gtk2::Ex::DBI ...
http://enthalpy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is a helper object that makes your gtk2-perl apps data aware.
This is mainly a bugfix release ... the previous version was BADLY broken.
Changes in this release:
- Fixed 2 *
I've inherited a problem for a youth soccer league. Their standings are
computed by adding 3 columns (game_pts, ref_pts and adjust_ref_pts)
together. However, the sum of ref_pts plus adjust_ref_pts cannot exceed
15.
Here is the current query which obviously allows total_ref_pts to
exceed 15 an
Hi everybody,
If you've ever wanted to share your knowledge and experience about
MySQL, now is your chance.
You're invited to submit a proposal to speak at the next MySQL Users
Conference, April 18-21, 2005, in Santa Clara, California. The call for
papers is wide open, but please get your submis
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| We have clients sending us xls file.
| We export them as csv files, using commas or semi-colons. as delimiters and
| then make an import in mysql.
| Problem : some of the fields, containing texts, have sometimes already a
| comma or a semi-colon in th
Hi,
On Thursday, October 21, 2004, at 04:40 PM, [EMAIL PROTECTED] wrote:
I don't think that he is worried about table scanning, he is worried
about
ROW scanning. Each of his rows is so large (2500*(size of float) +
3*(size of tinyint) + some other stuff) that just moving that much data
around th
Greetings,
Anyone in this list running "big" Renagade internet created banner engine
AdvertPro.
I'm trying to reach maximums mysql settings optimization for this
software. Running for about 400 queries/s already.
Anyone?
--
KRISHA
--
MySQL General Mailing List
For list archives: http://lists
i need consulting help for optimizing a database with
1.2 million records to handle 3-4 million hits a day.
if interested please contact me off the list for
details. im willing to pay for your time.
___
Do you Yahoo!?
Declare Yourself - Register onl
bertrand
i went to tab delimited fields for the same reason:
commas in text is often done, tabs is rarely done.
david
> -Original Message-
> From: Bertrand Gac [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 21, 2004 12:09 AM
> To: mysql
> Subject: Importing Excel Data in MySql
>
>
As Jay said, it's either a permission issue or the file already exists.
MySQL will not overwrite a file that already exists.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 3:35 PM
To: Mysql General (E-mail)
Subject: RE: SELECT... INTO OUT
Quoting [EMAIL PROTECTED]:
Look at some my.cnf options. You can tell mysql to use keys more often the
table scans with a var called max_seeks_keys=100 // something like that
Definitely. In fact, that's not really the issue at hand, since
max_seeks_for_key is already set to 1000 here. Shawn hit th
The directory is being created by Labview and data is written out by MySQL.
Can it be this? I am using windows 2000.
And that reminded me, do I have to create the directory that I will output
the file? Or, MySQL will automaticly create it if not exits???
Regards..
- Original Message -
I don't think that he is worried about table scanning, he is worried about
ROW scanning. Each of his rows is so large (2500*(size of float) +
3*(size of tinyint) + some other stuff) that just moving that much data
around through his machine is consuming too much time.
If you have a query that
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
'C:\data_out\day234\data_out.txt' (Errcode: 2)
So I copy the query statement and send via PhpMyAdmin, it ended up as
below
#1 - Can't create/write to file
Gary Richardson wrote:
These are essentially temporary tables that aren't defined as such --
they typically take a long time to derive (30 minutes to an hour) and
are used for multiple queries afterwards before being dropped.
In that case, why not just ignore those tables for replication? I
reali
This was exactly what I was looking for :) Too bad you need to be
SUPER to do it :(
Thanks.
On Thu, 21 Oct 2004 12:44:11 -0700, Sanjeev Sagar
<[EMAIL PROTECTED]> wrote:
> Try SET SQL_LOG_BIN=0 before you run your queires on master. This will be valid for
> that connection only.
>
>
>
>
> --
Louie,
Mysql treats the dash as a word separator. There's no way to change
that unless you change the source code and recompile Mysql.
Also, the default min word length is 4. So not only is "E" not
matched; even "018" will not be matched. The min word length is easily
configurable, though. Put a
> If this is the case you can create the table in a separate database, and
> in your mysql configuration tell the binary logging to exclude that
> database. Then anything in that specific database won't get replicated,
> I believe you can only do this exclusion on the database level, not per
> tab
Hi,
I am sending a query to a MySQL server on a network via LabView EXEC QUERY
VI.
It looks like that
SELECT `data1` , `data2`
INTO OUTFILE 'C:\\data_out\\day234\\data_out.txt'
FIELDS TERMINATED BY '\t'
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
FROM data_table;
What I
Thank you very much Paul.
EDWIN LIMACHI N.
Phone. 591-2-2123978
Movil: 591-715-29967
Fax: 591-2-2123975
Paul DuBois <[EMAIL PROTECTED]>
21/10/2004 15:56
Para
[EMAIL PROTECTED],
[EMAIL PROTECTED]
cc
Asunto
Re: ENCRYPT() function
At 15:41 -0400 10/21/04, [EMAIL PROTECTE
> If the queries modify tables that are being replicated, then how would
> the slave remain
> in sync with the master if it didn't replicate them?
These are essentially temporary tables that aren't defined as such --
they typically take a long time to derive (30 minutes to an hour) and
are used fo
No it's not a bug. Look up the DBI documentation and change the mysql_sock=
location in your code OR in /etc/my.cnf define the mysqld.sock file to be
stored in /tmp.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Caron, Christian [mailto:[E
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
>
> So, is there a faster way to insert/index the data? Would a different
> table or
> index type improve performace?
Use Load data from infile .. IGNORE ... u might get a better insert speed
increas
No look at Relay_Master_Log_File and Exec_master_log_pos for the position of
that master log file. The Master_Log_File indicates what position the IO
thread is on.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Marvin Wright [mailto:[EMAIL PR
My.cnf.huge is not good enough for your system specs. Calculate the Key
efficiency from the show status command. I bet the key efficiency is less
then 90% or so. In this case increase the key_buffer_size try 512M. A good
stat for a proper key_buffer_size in the sum of all index files block size.
Th
At 15:41 -0400 10/21/04, [EMAIL PROTECTED] wrote:
Dear list:
I have a short database with id,username and
password for authenticate my users with
freeradius. The passwords are encrypted through
ENCRYPT() function. I´d like to know why
ENCRYPT() function doesn´t give the same
encrypted string f
Try SET SQL_LOG_BIN=0 before you run your queires on master. This will be valid for
that connection only.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Thu 10/21/2004 11:24 AM
To: Mysql General (E-mail)
Subject: Ignore a single query in replication
Hey,
Is
Dear list:
I have a short database with id,username
and password for authenticate my users with freeradius. The passwords are
encrypted through ENCRYPT() function. I´d like to know why ENCRYPT() function
doesn´t give the same encrypted string for a clear text string?.
e.g. In the first time ENCRY
Hi all,
Does anyone know of a graphical monitor for innodb status? Something
like RRD, or that integrates with RRD? I'm looking to set up status
monitoring for a group of 20 servers, and this would be a very big help
in diagnosing problems.
Thanks for your time,
Devananda van der Veen
Neopets,
> now I managed to dump table schema with pg_dump. However,
> is there any schema converting tool available? I don't want to edit
> each table schema to make it mysql-compliant.
Download yourself a trial of Database Workbench
at www.upscene.com
It has a "Schema Migrator" tool that allows you to
Hope this is not a bad suggestion. I'd suggest also
"looking" at something like x-cart-gold. I't s a php
/ mysql product and very robust for online ecommerce.
If you want some ideas about what an online store
would need and should contain , you might get some
ideas.
I'm not promoting the product
So I gather you are creating a table, and doing some work in it, but
even though it isn't declared 'temporary' it really is and you don't
want it replicated?
If this is the case you can create the table in a separate database, and
in your mysql configuration tell the binary logging to exclude that
At 21:03 +0200 10/21/04, Luke Venediger wrote:
Hi Paul,
Thanks for the information. Is there an alternative? Are there plans
to add this in the future?
Not that I know of.
Cheers,
Luke Venediger.
On Thu, 21 Oct 2004 08:46:04 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 15:29 +0200 10/21/04, Lu
Hi Paul,
Thanks for the information. Is there an alternative? Are there plans
to add this in the future?
Cheers,
Luke Venediger.
On Thu, 21 Oct 2004 08:46:04 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 15:29 +0200 10/21/04, Luke Venediger wrote:
> >Hi,
> >
> >I'm trying to raise an error
> When I start MySQL, it does create the socket in
> /usr/local/mysql/. When I
> (or PHP, or Perl) ask mysql_config about the socket, it returns
> "/tmp/mysql.sock"...
>
> nrn6# ls -l /usr/local/mysql/mysql.sock
> srwxrwxrwx 1 mysqlmysql 0 Oct 21 09:30
> /usr/local/mysql/mysql.sock
Gary Richardson wrote:
There are a bunch of queries that happen on the master for statistical
purposes that don't use temp tables and generate large amounts of
data. These queries don't need to run on the slaves and in fact slow
it down quite a bit.
If the queries modify tables that are being repli
Hey,
Is there a way to tell the slave to not execute a query without
ignoring tables or databases?
There are a bunch of queries that happen on the master for statistical
purposes that don't use temp tables and generate large amounts of
data. These queries don't need to run on the slaves and in fa
I heartily agree with Jay.
Use paper and pencil to decide what information you want to maintain about
each of the "objects" (users, customers, administrators, credits, debits,
products, catalogs, descriptions, carts, cart contents, etc.) in your
system. When your paper model supports the busin
Stefan,
InnoDB is included in all MySQL-4.0 downloads from http://www.mysql.com. I
do not know if it is included in the mysqld binary that comes with the SuSE
Linux 9.0 distro.
If you are using a download from www.mysql.com, you probably have the line
skip-innodb
in your my.cnf, or it may also b
Hi,
I installed a fresh copie of MySQL 4.0.21 on Solaris 8 (Sparc). I did put
the following in the my.cnf file:
==
[mysqld]
User=mysql
Port=3306
Socket=/usr/local/mysql/mysql.sock
log
[client]
socket=/usr/local/mysql/mysql.sock
==
[snip]
I am writing an online store for my company using MySQL, and PHP. I was
wondering if anyone could suggest the table structure to include.
[/snip]
This is way too open ended for a sane answer. There are database
structures for as many folks as have designed online stores. Have you
done a fl
I am writing an online store for my company using MySQL, and PHP. I was
wondering if anyone could suggest the table structure to include. My
company has already explored the option of using an open source
eCommerce site, but they have decided to work from the ground up. Here
are the tables we have
Thanks, Stephen - that's interesting to know.
David
Stephen E. Bacher wrote:
FYI, I ran the same scenario under MySQL 3.23.58 and it produced the
results you wanted/expected:
+--+-+-+
| col1 | A-count | B-count |
+--+-+-+
|1 | 4 | 0 |
|2
Is there any output from the command? Any errors?
Try SHOW CREATE TABLE x. It should show you the TYPE= at the end.
out.
On Thu, 21 Oct 2004 11:10:10 +0200, Stefan Gnann
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a mysql database 4.0.15 on a suse linux 9.x system running.
> Now we hav
Hi Folks --
Ran into a couple performance issues, and looking for some optimization tips :)
I'm currently using MySQL 4.1.5-gamma, built from the bitkeeper tree a month or
so ago. I have a table which is roughly 2500 columns by 91 million rows (I get
4 of these a month, from the data we're recei
> You could do a find & replace and change every ; to some other symbol
> directly in excel before importing
I'm not sure our clients will appreciate if I modify their ponctuation
everuwhere :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Thanks, but I don't think a unique index is what I want. I need to allow any
number of records with the same user_id and a value of 'N' in is_primary.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 11:18 PM
To: Josh Howe
Cc: [EMAIL P
Steve Grosz wrote:
Where would I find a good online tutorial that would step me through
understanding setting up seperate tables, and the relationships
between then?
Thanks so much!!
Steve
Did you try putting in google "MySQL Basics"
You'll get numerous results.
Here's one, a colleague of mine u
Juri Shimon wrote:
Hi,
Hello miguel,
Tuesday, October 19, 2004, 10:52:03 PM, you wrote:
ms> Hi,
ms> Thank you for reporting this bug, I already opened the below
ms> bug report:
ms> http://bugs.mysql.com/bug.php?id=6165
How to repeat:
create table t0 (id int not null auto_increment primary key,
foo
Gary,
- Alkuperäinen viesti -
Lähettäjä: "Gary Richardson" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Thursday, October 21, 2004 4:49 AM
Aihe: Re: Char to Varchar on Innodb
> I'm not too worried about it myself, but I can
At 15:29 +0200 10/21/04, Luke Venediger wrote:
Hi,
I'm trying to raise an error in a MySql query, in the same way that
would be done in an MSSQL script:
RAISERROR('My error message', 16, -1)
Is there a way to do this in MySQL?
No.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MyS
Hi,
I have a table containing logfiles in mysql v4.0, myISAM.
The table has about 8.5 million records.
I'm using the my_huge.cnf file on mandrake10 Linux with 1 gig ram and 250gig
HD space.
Some Info:
Space usage :
Type Usage
Data 3,063 MB
Index 660,855 KB
Total 3,708 MB
R
Hi!
On Oct 21, Phil Bitis wrote:
> >From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> >
> >But for auto_increment field (on BIGINT, I believe ?),
> >you'll have hundreds of keys on one key page, so logarithm base will be
> >few hundreds, and log N should be just 3-5. That is, it should be only
> >~3-
Hi,
I'm trying to raise an error in a MySql query, in the same way that
would be done in an MSSQL script:
RAISERROR('My error message', 16, -1)
Is there a way to do this in MySQL?
Thanks,
Luke Venediger.
--
Get Firefox Browser! Reclaim the web. http://getfirefox.com/
--
MySQL General Mailing
>Seldom wrong and right again, Shawn! Yes, I forgot to cover the
>reflexive case. I don't have a magic bullet for that scenario;
>you'd just have to check that with application code.
>
>But on re-reading his original post, it occurred to me that I
>had misread it completely. I just sent a note o
Hi!
On Oct 21, Mads Kristensen wrote:
> *snip*
> > Yes.
> > B-tree is always balanced: http://www.nist.gov/dads/HTML/btree.html
> >
> > Regards,
> > Sergei
> *snip*
>
> You are right, B+Trees are always balanced but When you insert in
> increasing order all your inserts will be to the last l
now I managed to dump table schema with pg_dump. However,
is there any schema converting tool available? I don't want to edit
each table schema to make it mysql-compliant.
Ideas?
Pahud
On Mon, 18 Oct 2004 12:23:41 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
> On Mon, 18 Oct 2004 18:
On Thu, 21 Oct 2004, C.F. Scheidecker Antunes wrote:
> Hello,
>
> On a further inspection and by reading Paul DuBois' I guess m y system
> has to many bin logs. How can I get ride of them?
Assuming you don't need them for replication or point-in-time recovery, you
can use the PURGE command.
http
Hi,
Just wanted to check something from the documentation.
The recommended procedure for removing the bin logs on the master is
On each slave server, use SHOW SLAVE STATUS to check which log it is
reading.
Obtain a listing of the logs on the master server with SHOW MASTER LOGS.
Determine the ea
FYI, I ran the same scenario under MySQL 3.23.58 and it produced the
results you wanted/expected:
+--+-+-+
| col1 | A-count | B-count |
+--+-+-+
|1 | 4 | 0 |
|2 | 0 | 6 |
+--+-+-+
So could it be a bug in 4
Is there any plan to release a 32-bit binary 4.1.6 MySQL max for Solaris 9 and
Solaris 8? I see all the other binaries for Solaris for everything - any reason
to exclude the 32 bit?
Thx,
R
Hi,
Thanks for your reply but the result isnt quite right!!! :
mysql> SELECT T.Date, T.Hours, P.Project_Name FROM Timesheets T
-> LEFT JOIN Projects P ON (P.Project_ID = T.Project_ID and T.Date >=
-> '2004-10-18'
-> AND T.Date <= '2004-10-24')
-> WHERE T.User_ID = "1"
-> AND T.Type =
Hi Gary,
Yeah... we thought about those. Sergei said:
"you'll have hundreds of keys on one key page, so logarithm base will be
few hundreds, and log N should be just 3-5. That is, it should be only
~3-5 times slower as compared to the table with one hundred rows."
So say key base is 200, log 200 (1
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
But for auto_increment field (on BIGINT, I believe ?),
you'll have hundreds of keys on one key page, so logarithm base will be
few hundreds, and log N should be just 3-5. That is, it should be only
~3-5 times slower as compared to the table with one hund
Hi all,
I have a mysql database 4.0.15 on a suse linux 9.x system running.
Now we have to use the features of InnoDB tables (rollback, a.s.o.).
Up to now we use the standard table type MyISAM.
Now I want to change the tabel type with the command "ALTER TABLE x TYPE
= InnoDB".
The command doesn
Jeff,
- Original Message -
From: "Jeff Mathis" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 20, 2004 6:51 PM
Subject: migration of InnoDB 4.1.3 to 4.1.6
I see from the release notes that tables with timestamp column will need
to be rebuilt. will the se
Hello miguel,
Tuesday, October 19, 2004, 10:52:03 PM, you wrote:
ms> Hi,
ms> Thank you for reporting this bug, I already opened the below
ms> bug report:
ms> http://bugs.mysql.com/bug.php?id=6165
> How to repeat:
> create table t0 (id int not null auto_increment primary key,
> foo enum('a','b'
In article <[EMAIL PROTECTED]>,
"Scott Fletcher" <[EMAIL PROTECTED]> writes:
> Sorry you didn't understand what's I'm asking for. It take some logical
> thought to see the picture. Now I know I will have to enforce it with
> the application code (PHP, HTML and JavaScript) with the current two
>
*snip*
> Yes.
> B-tree is always balanced: http://www.nist.gov/dads/HTML/btree.html
>
> Regards,
> Sergei
*snip*
You are right, B+Trees are always balanced but When you insert in
increasing order all your inserts will be to the last leaf of the
B+tree. This means that you can get some concurr
I use a tool called navicat. In supports excel imports excellent. They have
a shareware version on their page you can try out.
www.navicat.com
Regards
/Jonas
-Original Message-
From: Bertrand Gac [mailto:[EMAIL PROTECTED]
Sent: den 21 oktober 2004 09:09
To: mysql
Subject: Importing Excel
Hello
We have clients sending us xls file.
We export them as csv files, using commas or semi-colons. as delimiters and then make
an import in mysql.
Problem : some of the fields, containing texts, have sometimes already a comma or a
semi-colon in them...and when we import, of course MySql thin
Unless you're running InnoDB (with lots of data and indexes) I would assume
your trouble has to do with the fact that you are running I am running
4.0.20-Max-log. (Namely the "log" part) How large are the logs
in /var/lib/mysql?
j- k-
On Wednesday 20 October 2004 22:41, C.F. Scheidec
Hello,
On a further inspection and by reading Paul DuBois' I guess m y system
has to many bin logs. How can I get ride of them?
Thanks in advance,
C.F.
C.F. Scheidecker Antunes wrote:
Hello,
I have a server with 18Gb of space. I have ran du to figure out how
the harddrive is being used and I rea
72 matches
Mail list logo
