Can my.cnf actually lessen performance?

OS X 10.3 and mysql 4.x, I have a situation where after time certain queries get really slow, in the area of 30 seconds. I seem to have pinned it down to my use of my-large.cnf. If I remove this file and let just the mysql defaults in, then I seem to not have the trouble, at least, I have 8 hours

Problems with Mysql 4.0.15+Tomcat 4.0

Hi, i m using mysql 4.0.15 and tomcat 4 as a webserver on linux 8 machine, now the problem that i am facing is that while testing my web application when i send too many refresh requests to the web page, the server's CPU utilization reaches to 100% for a very long duration of time and on che

Re: MySQL 5 Application Error

At 19:44 -0600 3/5/04, Mulugeta Maru wrote: Table structure: CREATE TABLE `players` ( `PLAYERNO` smallint(6) NOT NULL default '0', `NAME` char(15) NOT NULL default '', `INITIALS` char(3) default NULL, `YEAR_OF_BIRTH` smallint(6) default NULL, `SEX` char(1) default NULL, `YEAR_JOINED` s

Re: Relationship between libz and libmysqlclient libraries

At 14:17 -0800 3/5/04, John Ling wrote: I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to the

query date ranges

I have been trying this is several ways, currently I have a mess MySQL 4.1.1 PHP as the interface I have a table of with a date range called seasons. in it I have two date ranges and an amount to be charged for each day in the range 2004-01-01 00:00:00 2004-06-01 00:00:0044 2004-06-02 00

MySQL 5 Application Error

Table structure: CREATE TABLE `players` ( `PLAYERNO` smallint(6) NOT NULL default '0', `NAME` char(15) NOT NULL default '', `INITIALS` char(3) default NULL, `YEAR_OF_BIRTH` smallint(6) default NULL, `SEX` char(1) default NULL, `YEAR_JOINED` smallint(6) NOT NULL default '0', `STREET`

Re: MySQL C API license

To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: > Folks, > > What license does the MySQL C API fall under? I am looking to add client > support to a game that I am creating, but need to know the terms of the > license etc. > > -Ron -- MySQL General

Re: Iterating thru FullText Index

Hi! On Mar 05, Todd Burke wrote: > Is there any way to iterate thru the keys in a fulltext index? This issue > does not come up for other indexes since ORDER BY can achieve this: > > For example if table t is indexed on part_id > > SELECT DISTINCT part_id FROM t ORDER by part_id; > > will re

Re: The index handles accented UTF-8 chars badly

Hi! On Mar 05, Rikard Bogren wrote: > I have a problem with index on a UTF-8 based db/table and mySQL 4.1 (I have > tried 5.0 too). > I run the mysqld with the --default-character-set=utf8 flag and I'm > certain that it's UTF-8 data that I'm putting into the database. > To reproduce, follow these

MySQL C API license

Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA

Relationship between libz and libmysqlclient libraries

I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to the difference in the versions? Can someon

What causes a crashed table?

Hi, I ran into a slight problem this morning where MySQL suddenly wouldn't recognize a table anymore. After doing a myisamchk on it, it listed the table as having crashed. myisamchk -r on the table fixed the problem, but I am concerned that this error happened in the first place. I've tried to

Re: Please help with join issue

Erica L Ridley <[EMAIL PROTECTED]> wrote: > I need help with rewriting a sql query. Nested queries that work in MS > databases apparently do not work in MySQL databases. Here is what I need > in MS query pseudo code: > > SELECT table1.myfield1, table2.myfield2 > FROM table1, table2 > WHERE ta

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

On Fri, 5 Mar 2004, Paul DuBois wrote: > At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote: > >On Fri, 5 Mar 2004, Paul DuBois wrote: > > > >> At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: > >> >Hello, > >> > > >> >All users should be able to change their own password on any mysql. > >> >I h

You are dismissed

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql_get_metadata with SHOW queries

"Nate Blanchard" <[EMAIL PROTECTED]> wrote: > According to the C API docs on mysql_get_metadata: > " If a statement passed to mysql_prepare() is one that produces a result > set, mysql_get_metadata() returns the result set metadata in the form of > a pointer to a MYSQL_RES structure that can be use

Re: Partial Replication ?

Bonnet R?my <[EMAIL PROTECTED]> wrote: > Hello, > > I have a database which is flushed every four hours, > and > I want to replicate it without replicating the delete > queries . Is this possible ? > (sorry for my awful english) With mysqlbinlog utility or with SHOW BINLOG EVENTS statement find n

Re: 4.1.1 Problem with SELECT INTO OUTFILE

Chris Fossenier <[EMAIL PROTECTED]> wrote: > > It seems that each time we select into an OUTFILE that already exists > (re-use a name) the server crashes. > > Anyone have any ideas if this is a setting or just a bug? It's known bug: http://bugs.mysql.com/bug.php?id=2123 -- For techni

Index continues to fail on large database

On February 5, I posted this message to the list describing my problem: http://archives.neohapsis.com/archives/mysql/2004-q1/2398.html I received the following response and posted a reply to this response, respectively reply: http://archives.neohapsis.com/archives/mysql/2004-q1/2426.html response:

Re: DROP tables question(s)?

"David Jackson" <[EMAIL PROTECTED]> wrote: > Howdy -- > How can I drop all tables in a databases? Get list of table names with SHOW TABLES FROM db_name and compose DROP TABLE statement. > How can I drop tables beginning with foo_ > In this case you can use SHOW TABLES .. LIKE 'foo\_%' statement

The index handles accented UTF-8 chars badly

I have a problem with index on a UTF-8 based db/table and mySQL 4.1 (I have tried 5.0 too). I run the mysqld with the --default-character-set=utf8 flag and I'm certain that it's UTF-8 data that I'm putting into the database. To reproduce, follow these simple steps. #---

Re: mysqlbinlog: unknown command errors

Hi Sasha, Thanks for getting back to me on this. I was hoping to use the binlogs as an alternative to rollback.commit in the event that someone for example hoses a table by doing an update and forgetting the where clause. I want to be able to load a snapshot, dump the binlogs out and find and dele

Re: MySQL Dump Command Does Not Consider Foreign Key Dependencies

Stephen, in <= 4.0, you should put SET FOREIGN_KEY_CHECKS=0; at the start of the dump file. In 4.1, mysqldump knows to add to a dump file a line /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/ to disable foreign key checks in the dump file. Best regards, He

RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies

i turn off the checks before a dump in order to restore it properly. In my scripts looks like: echo "SET FOREIGN_KEY_CHECKS=0;" > ${mysql_backup_directory}/${2}/${database_filename} mysqldump --opt -h $2 -P $3 -u $db_username --password=$db_password $1 >> ${mysql_backup_directory}/${2}/${databas

How long should I keep binary logs?

Two INNODB/mysql/Win questions from a new user: [1] How long should I keep around copies of binarylog? (They're used to recover in case of failure, yes? (I'm also shutting down the databases and dumping them each night to a large text file as backup, too.) [2] Can anyone offer advice (or links t

Re: lire des fichiers windev5

Bonjour Pierre, Non mysql ne support pas un format hyperfile. C'est un format propriétaire. S'il il est possible d'exporter les donnees en format ASCII ça pouvait marcher avec un ou load data commande. Voici le doc en français: http://www.mysql.com/doc/fr/mysqlimport.html En plus s'il est pos

Iterating thru FullText Index

Is there any way to iterate thru the keys in a fulltext index? This issue does not come up for other indexes since ORDER BY can achieve this: For example if table t is indexed on part_id SELECT DISTINCT part_id FROM t ORDER by part_id; will return all keys in index order Is there a way to do

Re: Hitting max_connections - safe to raise this?

Alex Greg wrote: Hi, Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5 made up of 3 36GB disks. It does between 300 and 1200 queries per second. The read to write ratio is about 4:1. My problem is that we're hitting our max_connections more and more frequently. I

Re: 4.0.18 or 4.1.1-alpha?

Hi, hmm, mysql support needed to know that a few weeks ago! :) Thanks, Eric At 09:58 AM 3/5/2004, Victor Medina wrote: >If you use the "old-password" settings in your server, ems should connect with out a >hitch > >Best Regards! >On Fri, 2004-03-05 at 13:41, Eric wrote: >> >>Hi, >> >>If yo

lire des fichiers windev5

Bonjour, La possibilité de lire directement les fichiers windev5 au format hyperfile pour exploiter les données ou les migrer sous mysql existe-t-elle? Merci. Pierre Marcotte -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Please help with join issue

I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE table1.key=table2.key AND myfield1="something" AND myfiel

Re: slave hotbackup question

Mark, http://www.innodb.com/manual.php#advanced.slave describes how to set up a new slave from a hot backup of a master. If you take a hot backup of a slave, and want to use it to set up a new slave, then the important coordinate is the MASTER binlog position that mysqld prints when you start mys

Re: Replication broken after upgrade from 4 to 4.1

Stefan Kuhn wrote: Hi everybody, I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says "Connecting to master".

Re: How can I disable 'max_connect_errors'?

Daevid Vincent wrote: Is there a way to disable this 'max_connect_errors' thing? http://www.mysql.com/doc/en/Blocked_host.html Tried "max_connect_errors=0" but then it shows up as "max_connect_errors=1" What is the 'max' that this value can be in case? We have it set to 10,000 now, but that only

Re: Major problem converting MyISAM to InnoDB

Cliff wrote: I think I may have gotten closer to the root of the problem. It seems that the field named 'comments' is the one that crashes the server when it is selected. Here is the output of the logs when I do 'select comments from allusa': 040304 23:14:52 mysqld restarted 040304 23:14:53 InnoD

MySQL Dump Command Does Not Consider Foreign Key Dependencies

>Description: The current mysqldump utility does an alphabetical dump of the tables as well as a row by row dump of the data following each table declaration. This is adequate enough for most databases; however, if there are strict foreign key constraints, the or

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote: On Fri, 5 Mar 2004, Paul DuBois wrote: At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: >Hello, > >All users should be able to change their own password on any mysql. >I have trouble to allow this feature on mysql 4.0.12, on mysql >3.23.56 it

Re: Major problem converting MyISAM to InnoDB

Cliff, I do not think this is a threading issue. This looks now more like a wrong .frm file problem. Please use innodb_table_monitor as I suggested earlier, and compare the table definition inside InnoDB to what SHOW CREATE TABLE says. Best regards, Heikki Innobase Oy InnoDB - transactions, row

Re: 4.0.18 or 4.1.1-alpha?

If you use the "old-password" settings in your server, ems should connect with out a hitch Best Regards! On Fri, 2004-03-05 at 13:41, Eric wrote: > Hi, > > If you use any 3rd party clients like EMS mysql manager. Check that they have > updated their binaries to support changes in 4.1, if they h

Re: 4.0.18 or 4.1.1-alpha?

Hi, If you use any 3rd party clients like EMS mysql manager. Check that they have updated their binaries to support changes in 4.1, if they have not, you won't be able to connect to 4.1. That was a big pain for me. I wanted to start using 4.1 on a backup server part time. But we use EMS a gre

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

On Fri, 5 Mar 2004, Paul DuBois wrote: > At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: > >Hello, > > > >All users should be able to change their own password on any mysql. > >I have trouble to allow this feature on mysql 4.0.12, on mysql > >3.23.56 it works. > > > >Let me demonstrate it: > >on

DROP tables question(s)?

Howdy -- How can I drop all tables in a databases? How can I drop tables beginning with foo_ Note, I don't have permissons to just drop the db. TX, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump of UTF8 db

Hi all, I was just testing if my utf8 table would restore properly. When I execute mysqldump -umysqladmin -pmysqladmin test < C:\mysql\bin\test-bp.sql No tables are created. Instead I what get in my DOS console (WinXpPro) is the beginning and end of the dump file (having skipped all the restora

Re: 4.0.18 or 4.1.1-alpha?

If it's going to be a full production environment where stability is crucial, use 4.0.18. If it is going to be for a development proyect, you can use 4.1.1 and enjoy the new features. Anyway, 4.1.1 seems to be quite stable if you ask me. But it might depend on how much are you willing to risk B

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: Hello, All users should be able to change their own password on any mysql. I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works. Let me demonstrate it: on mysql 3.23.56: as root: mysql> create database test_dumm

SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

Hello, All users should be able to change their own password on any mysql. I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works. Let me demonstrate it: on mysql 3.23.56: as root: mysql> create database test_dummy; Query OK, 0 rows affected (0.00 sec) mysql> gr

RE: BOM Select statement

> -Original Message- > From: Wesley Baker [mailto:[EMAIL PROTECTED] > What I want is to know how to build a SELECT statement which will > return all components of mynewpc and navigate down the > bill-of-materials > and also return all the components for the case, the powersupply and >

table name is lower case if there is an index on it (4.0.18 )

Hi, I have a problem with mysql 4.0.18 on WindowsXP I set the lower_case_table_names=2 as it is mentioned for windows at the mysql website. (before I'm using version 4.0.15 and had set it to 0) so the tablenames should be stored in this case as I wrote it. So I create a table in Java wi

4.0.18 or 4.1.1-alpha?

I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- MySQL General Mailing List For list archives:

4.1.1 Problem with SELECT INTO OUTFILE

It seems that each time we select into an OUTFILE that already exists (re-use a name) the server crashes. Anyone have any ideas if this is a setting or just a bug? Thanks. Chris.

Re: MySQL 5 Application Error

"Maru, Mulugeta" <[EMAIL PROTECTED]> wrote: > Yes. I tried it at least three times and MySQL crashes i.e. I get disconn= > ected. I do use Windows 2000 to run MySQL.=20 Could you provide structure of table 'players'? (Output of SHOW CREATE TABLE statement or mysqldump program) > -Original Me

Re: OT:select in mysql

>I want a list of table1.id not included in Table2 but i don't find the >solution! SELECT * FROM table1 LEFT JOIN table2 USING (id) WHERE table2.id IS NULL PB

ibdata1

I lost my ibdata1 file, I don't have backup, and now my tables InnoDB don't open. MySQL error: 1016 (Can't open the file: 'table.InnoDB') please, give me a solutions. Are 27 tables. please. Wilker Azevedo __ Acabe com aq

Re: OT:select in mysql

> select table1.id from table1 left outer join table2 on table1.id = table2.id > where table2.id = NULL; Sorry, that last should be where table2.id IS NULL; Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

Re: OT:select in mysql

> I want a list of table1.id not included in Table2 but i don't find the > solution! I _*think*_ this will work for you. If I'm wrong, I'm sure someone will come behind and correct me: select table1.id from table1 left outer join table2 on table1.id = table2.id where table2.id = NULL; Chris

MySQL Administrator

Hello list I have download the MySQL Administrator twice and when trying to gzip It collapse. Does anybody know how and why? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OT:select in mysql

Hi, i've a little problem with query. I have two tables where Table1 id desc Table2 id desc I want a list of table1.id not included in Table2 but i don't find the solution! Example Table1: --- id ! Desc --- 1! xx 2! Xx 3

maintaining logs...

hi, i m using mysqld Ver 4.0.17-standard for pc-linux on i686 (Official MySQL RPM) and i want to maintain trace logs and debug logs to see what my mysql server is doing and what error it encounters, if any. help will be highly appreciated. bye Abubakr

Partial Replication ?

Hello, I have a database which is flushed every four hours, and I want to replicate it without replicating the delete queries . Is this possible ? (sorry for my awful english) Rémy BONNET. Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partou

RE: MySQL 5 Application Error

Yes. I tried it at least three times and MySQL crashes i.e. I get disconnected. I do use Windows 2000 to run MySQL. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 5:02 AM To: [EMAIL PROTECTED] Subject: Re: MySQL 5 Application Error

Re: Innodb table space getting filled up without any increase in actual rows!!

Sp. Raja, - Alkuperäinen viesti - Lähettäjä: "Sp.Raja" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: "mysql" <[EMAIL PROTECTED]> Lähetetty: Friday, March 05, 2004 2:28 PM Aihe: Re: Innodb table space getting filled up without any increase in actual rows!!

SV: Querying serveral databases (Views?)

No I did not. Thank you very much! Regards Daniel -Ursprungligt meddelande- Från: Jeff Mathis [mailto:[EMAIL PROTECTED] Skickat: den 5 mars 2004 00:48 Till: Daniel Ek Kopia: [EMAIL PROTECTED] Ämne: Re: Querying serveral databases (Views?) in case someone hasn't answered you yet.. do

Re: Innodb table space getting filled up without any increase in actual rows!!

Thanks for your valuable suggestions. I'm committing transactions, but not all. Only the transactions which do insert/delete, commit and not all. So I think the better solution for me is to switch to "Read Committed" isolation mode, since I don't require "Repeatable Read" Isolation for my applic

Re: Drop and Add Functions in Mysql 4

You could try MySQL 5(it is in alpha state), which comes with stored procedures, mixing stored procedures and prepered statements could be a possibility. About Sybex's book, haven't read it, but Paul's book (Oreilly's) is very nice. IMHO Best Regards On Thu, 2004-03-04 at 23:23, [EMAIL PROTECTE

Re: msSQL <-> MySQL (exhanging data between the two)

I haven't tried, but it seems quite difficult, for one thing, both sql engines are very differents. So the short answer would be a plain no. Now trying something exotic would be making a odbc bridge between the two dbs and then use some scripted solution it would be possible, something like java or

Re: An doubt about mysql version 4.0.x agains 4.1.x

"Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> wrote: > Dear Friend > > an friend of mine told that the follow line bellow dont work with mysql > version 4.0.x > > * Support for subqueries and derived tables > This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A > WHERE C

locking issues

Hi Group, A question about locking. In my code (delphi but that doesn't much matter) I fire ad-hoc queries (select). Before the query i fire a locking query (read) for that particular tables. Something like this: lock tables tab1 a read, tab2 b read (execute) select * from tab1 a, tab2 b where.

An doubt about mysql version 4.0.x agains 4.1.x

Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this Re

Re: sub-query

"Lorderon" <[EMAIL PROTECTED]> wrote: > Since I don't use MySQL 4.1, is this query OK? > > SELECT SQL_CALC_FOUND_ROWS * FROM >((SELECT * FROM t1 WHERE id>100 GROUP BY country) >UNION ALL > (SELECT * FROM t2 WHERE id>150 GROUP BY country) >LIMIT 0,10); > > I want this to re

Replication broken after upgrade from 4 to 4.1

Hi everybody, I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says "Connecting to master". The error log says:

Re: MySQL 5 Application Error

"Mulugeta Maru" <[EMAIL PROTECTED]> wrote: > I am using MySQL 5 issuing the following query when the application died on me three > times.Query: Select name, year_of_birth from players where year_of_birth <= > ALL(select year_of_birth from players) > > Note: If I only use the first part of the qu