Hello,
I have a server with 18Gb of space. I have ran du to figure out how the
harddrive is being used and I realized that the directory that is taking
the most space is /var/lib/mysql
I know that now I have much less database records than I used to have
and I have the same database structure
I had a transaction script that was working fine.
Now I think it maybe due to a duplicate key error.
At least that is the error being printed out.
Here is the table Profiles_Skicerts[innodb]:
P_ID - PK, Normal Index (int)
Skicert - PK, Normal Index (varchar)
N_Year - int, allow null
L_Used - int,
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
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.
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
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
*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 concurrency
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
column
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','o')
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
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
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 hundred
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
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 = Project;
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
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
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
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.
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
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 leaf of the
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
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
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-5 times slower
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
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
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 see how
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
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
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
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:
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
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 have to
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
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
[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
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
==
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
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
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
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
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
nrn6#
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 in a
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,
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
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.
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
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,
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
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
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
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.
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
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
increase. A
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
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 for
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 PROTECTED]
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
table.
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
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.
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
[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
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
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 -
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
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
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
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
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:
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
-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
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
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
72 matches
Mail list logo