Details required in cnf files

Hi all, I have a advanced servers 4 with 30 gb of ram please let me know the exact details how much i have to configure and use the exact variables in the cnf file and which one to be used.(innodb engine) any my database size is upto 600gb how to take up the backup, using ibbackup my system get

Re: Spfile in Mysql......

Hi all The same thing mysql also uses it own defaults file if my.cnf is not found. It uses its own defaults-extra-file configurations to start the db. Yeah but only specific variables can be changed globally or session wise. Others needs recycling of db. :-) - Original Message --

Re: Why is Delete slow on a Merge Table?

Further reason DELETE FROM on a Merge Table is so inefficient is this: DELETE FROM tbl without a WHERE clause on a MyISAM Table is mapped internally to TRUNCATE TABLE, which would be instatntaneous DELETE FROM tbl WHERE 1=1 would clearly make even a MyISAM table terribly ineffeicient as it mus

How to find Free space in innodb

Hi I am running 5.0.46-enterprise-gpl-log version in linux (Red Hat Enterprise Linux AS release 4 (Nahant Update 5). In my.cnf i have configured innodb as : innodb_data_file_path = datafile1:500M;datafile2:500M;datafile3:500M;datafile4:500M;datafile5:500M;datafile6:500M;datafile7:500M and da

Re: Add a replicated DB w/o rebooting the server

Hi, Master to slave replication. If a database is created in master and in slave config file if i needs to add the 2nd database name to replicate, without restarting the instance in slave it is not possible. Cheers John_mysql - Original Message From: Oriol Capsada <[EMAIL PROTECTED

Re: disconection

Hi Check whether u have enabled the safe_updates in the config file. - Original Message From: Mulyadi <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Wednesday, October 31, 2007 3:22:59 PM Subject: disconection - Original Message - From: Ravi Shanmugam <[EMAIL PROTECTED]>

Re: Can't find file: './mysql/(database_name).frm'

Hi, If you are using binaries from mysql.com and extract the files and when u try to start the database it says in the error frm/* not found...then u might try out this option as Try to run the ./configure file which will come with binaries, It will auto create the frm and MY* files under the

Ibbackup failure

Hi all, When i try to backup the database through ibbackup i am getting the following error :- Details are here. - InnoDB Backup Utility v1.3.0; Copyright 2003-2005 Innobase Oy This software is published

Re: Problem creating a Trigger

Did you remember to switch your SQL delimiter ? MySQL default delimter for SQL is the semicolon ( ; ) MySQL's stored procedure language also uses the semicolon to delimter statements. These two rules cannot peacefully coexist. You can get around this in three steps: 1) Change

Re: MySql priority

You may want to consider tuning the 'his-priority' server instance by giving it larger values for the following: temp_table_size query_cache_size query_cache_limit Ben Clewett <[EMAIL PROTECTED]> wrote: Sorry if this has been asked many times before... I have 5 MySql systems running

Re: user permissions to all DB

OK. I am just a little pumped up these days. I just passed my Certification Exams. Chapter 34 of the Certification Book is still fresh in my mind. Even though I'm in the US, Cheers everybody !!! Jay Pipes <[EMAIL PROTECTED]> wrote: Terry, I absolutely agree with Rolando on this. Rol

RE: MySQL in read-only mode

This will be not that easy as there is a large array of different users accessing the DBA at different time during the day/night. CL t 11:58 AM 8/3/2007, Edward Kay wrote: > -Original Message- > From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED] > Sent: 03 August 2007 16:55 &g

Re: MySQL in read-only mode

Lewis - DBA wrote: Is this possible with MYSQL using the innodb engine? If so, what is the command/process to make this happen. Thanks in advance, ~ Clyde Lewis Database Administrator ~ Clyde Lewis Database Administrator

MySQL in read-only mode

Is this possible with MYSQL using the innodb engine? If so, what is the command/process to make this happen. Thanks in advance, ~ Clyde Lewis Database Administrator

Multiple binary log files question

Guys, I would like to know if there is a way to have individual databases under the same instance or server write to separate binary log files. The idea is to have multiple binary log file for each database on the same server. The problem that I experiencing is sorting through the binary log

Re: Help with MySQL 5

Login to mysql Perform this on the table ALTER TABLE tbl-name MODIFY COLUMN Rating varchar(10); Then recreate the ODBC link in OpenOffice Give it a try. Colleen Beamer <[EMAIL PROTECTED]> wrote: Hi, I apologize for posting here, because I only use MySQL at a very basic level

Re: Reapply bin-log question( Help Please)

t;. or from binlog_sql.sql, check the insert or update that is giving "foreign key fail" error, know the position just before this sql and recovery till that position and then recovery from position after this sql still till the end of file. regards anandkl On 6/20/07, Clyde Lewis - DBA &

Reapply bin-log question( Help Please)

Guys, I'm attempting to reapply a number of bin-log files in a effort to restore all changes that was made to a database. I'm performing the following command, but continue to get a foreign key constraint error message when doing so. Has anyone ever ran into this issue, and if so, what is a p

Re: UPDATE statement causes signal 11 on 5.0.16

Gleb Paharenko wrote: Hello. Resolve a stack trace and provide it to the list. See: http://dev.mysql.com/doc/refman/5.0/en/crashing.html http://dev.mysql.com/doc/refman/5.0/en/using-stack-trace.html - resolving the stack dump gives me this:- 0x8150650 + 135595600 0xe420 + -7136 0x9

Re: UPDATE statement causes signal 11 on 5.0.16

Gleb Paharenko wrote: Hello. Please, could you explain what does it mean 'Signal 11 without fail'. Usually after receiving such a signal MySQL crashes. Of course, it should do this in normal circumstances. What is in the error log? Check if the problem still exists on official binaries of 5.0.

UPDATE statement causes signal 11 on 5.0.16

Hi, I'm running a 5.0.16 instance on a Debian box (2.6.13 kernel). The following statement causes a signal 11 without fail, and each time when mysqld_safe restarts the daemon, no socket file is created: UPDATE X_Products.product_details AS pd , X_Products.tblMaxProductStockDisplay AS sd SET

Re: High Performance MySQL on Amazon

Ian wrote: Hi, On Amazon uk there are two versions of the book "High Performance MySQL ": 1st: High Performance MySQL ~Jeremy D. Zawodny, Derek Balling O'Reilly Paperback - April 23, 2004 £19.95 2nd: High Performance MySQL ~Derek J. Balling O'Reilly Vlg. GmbH & Co. Paperback - October 3

Re: triggers on 5.0.17 -- definer not fully qualified

Gleb Paharenko wrote: Hello. This should be interesting for you: http://bugs.mysql.com/bug.php?id=16266 Hi, The bug report implies that if you recreate the triggers on the slave (deleting them manually from the database directory), then it resolves the issue. Unfortunately, the proble

Re: triggers on 5.0.17 -- definer not fully qualified

Gleb Paharenko wrote: Hello. I've subsequently upgraded the instance to 5.0.18, Have you updated master to 5.0.18 as well? - unfortunately, the set up demands that the master stays at 4.0. I can't change that. The triggers were working in 5.0.16. It's the new DEFINER that w

triggers on 5.0.17 -- definer not fully qualified

After upgrading to 5.0.17, the triggers on one of my instances now break replication with a "definer is not fully qualified" error. I set the DEFINER in the CREATE TRIGGER statement to CURRENT_USER (i.e., [EMAIL PROTECTED]), but the error still occurs. If I try setting the DEFINER to any othe

Re: PHP4 or PHP5?

Jan Pieter Kunst wrote: I don't see why 40 tables is such a big deal? Normalizing data usually results in more (but smaller) tables and crosstables. If you are working with complicated normalized data, 40 tables does not sound so excessive to me. - I wish I only had 40 tables to worry about..

Re: Not finding customers without invoices

Brian Dunning wrote: I'm trying to find a list of customers including a count of all their invoices, but it's not including customers who have no invoices - and it should. What's broken? SELECT customers.company, count(invoices.id) as invcount FROM customers, invoices WHERE customers.id= in

Re: Triggers

Steffan A. Cline wrote: Upon insert or update I get the following error: ERROR 1442 (HY000): Can't update table 'locations' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. What exactly is the meaning of this? Is there no way around

Re: innodb locking

Tony Leake wrote: Hi, I have a query: UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid = 10798 intOrderUid is the primary key There are 25 columns in the table and a further 8 of these have indexes on them. The table is innodb I have just tried to run the above query 3

Re: good database design

Tim Hayes wrote: I disagree completely. I prefer to have regard to the statement of requirement, which in this case is a concern over performance. If following conventional design rules creates performance issues, then performance related issues come first when considering design. - persona

Re: database structure question...

bruce wrote: hi... i'm considering an app where i'm going to parse a lot of colleges (~1000) faculty information. would it be better to have all the faculty information in one large table or would it be better/faster to essentially place each college in it's own separate table, and reference ea

Re: Suggestions on db server configuration - Replication & load balancing or Clustering??

Ed Pauley II wrote: I need to come up with a high availability, high performance MySQL server setup. I have two database servers half way across the country from one another being replicated through a VPN. These db servers serve two very busy web sites with multiple applications accessing th

Re: Seriously.. When are we going to get subqueries?!

- Original Message - From: "Kevin Burton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Tuesday, June 07, 2005 6:11 PM Subject: Re: Seriously.. When are we going to get subqueries?! > Greg Whalin wrote: > >> They do use indexes if you use them to build derived tables and are >

Re: How do you become a MySQL DBA

Mark Ahlstrom wrote: Here's an odd question for you, how do you become a MySQL DBA? I've got enough Solaris/Linux Experience under my belt and I was a Jr. Oracle DBA for a year, which got me really interested in RDBMS. I try to work with MySQL as much as possible, but I work with on

Re: InnoDB to MyISAM

Peter Normann wrote: Martijn Tonies wrote: Nevertheless, foreign key constraints belong in the database, not in your application... If you have foreign keys (your wording), you need foreign key constraints. Period. Plain and simple. No discussion :-) Foreig

Re: InnoDB to MyISAM

Scott Purcell wrote: Hello, I posted last night but did not receive an answer. I am trying to create a fulltext index, but my table was created as an InnoDB type. There is quite a bit of data there (1000+ records) and I need to change to a MyISAM table for the indexing for fulltext search. H

Re: substituting a certain word in all the tinytext rows in a table using SQL command

symbulos wrote: Is it possible to substitute, using SQL command, a certain word with another word in all the field in all the rows (tinytext) within a certain table? - see REPLACE here: http://dev.mysql.com/doc/mysql/en/string-functions.html - ian -- +--

Re: Update Email Column

shaun thornburgh wrote: Is it possible to update all the domain names for an email column? I want to change everyones email address to my domain for a test site, so can I change the email address column such that everything after @ is changed to mydomain.com? - see REPLACE here: http://dev.mysq

Re: Performance Tuning - Table Joins

j llarens wrote: 2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for the right data, int for numbers, float for money, char for fixed string, and certainly NOT 255 for lenght! If its necesary such amount of characters, TEXT or BLOB must be used, but only if it is necesary.

Re: Sum() unequal number of rows

"Dave Kennedy" <[EMAIL PROTECTED]> wrote on 03/06/2005 05:09:36 PM: SELECT sum(col1) AS total1 FROM t1 GROUP by col1 SELECT col1, sum(col2) AS total2 FROM t2 GROUP by col2 Table t1 contains 4 rows to sum for each value in col1 Table t2 contains 8 rows to sum for each value in col2 If one sele

Re: help with an SQL query

Michael Satterwhite wrote: - As it is, all I can suggest is to JOIN on all 90 tables - and hope MySQL can handle the query - and that you can type all of them without error. Note that if you use a UNION query as you suggest above, you will get the last login FOR EACH DAY - not the overall last logi

Re: how to make question that check the last hour

| | | | "If your DBA is busy all the time... | | ...he's not doing his job properly" | | ebuyer http:/

Re: MySQL as Email database [sort of OT]

wever, is appalling... - ian -- +---+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the time... | |

Re: Difference between 'LIKE' and '='

m i t h', in that order, such as Smithfield, Aerosmith, Nasmith, Smithsonian... - ian -- +---+ | Ian Sales Database Administrator | |

Re: Syntax for Compound "IF" Statements?

+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the time... | | ...he's not doing his job properly" | | eBuye

Re: MySQL Load Balancing w/ Alteons...Half Open Connections

rator | | | | "If your DBA is busy all the time... | | ...he's not doing his job properly" | | eBuyer http://www.ebuyer.com | +---+ -- MySQL

Re: A problem of structure

---+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the time... | | ...he's not doing his job properly" | | eBuyer

Re: A problem of structure

s the case. - ian -- +---+ | Ian Sales Database Administrator | | | | "If your DBA is bu

Re: mydb-bin.xxx files

r my.cnf - ian -- +---+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the time... | | ...he's n

Re: Slackware10 & mysql

) to see what caused mysqld to die. - ian -- +---+ | Ian Sales Database Administrator | | | | "If your D

Re: Complicated Query

. - ian -- +---+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the

Re: Can't drop index.

"If your DBA is busy all the time... | | ...he's not doing his job properly" | | eBuyer http://www.ebuyer.com | +---+ -- MySQL Genera

RE: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)

Password on Solaris 8 (Not the usual - strange.) Pada Sun, 28 Jul 2002 11:04:09 +0100 "MySQL DBA" <[EMAIL PROTECTED]> menulis : > > ./mysqladmin -u root password newpass > > $ ./mysqladmin -u root password newpass ok then, maybe you this can solve the problem .

RE: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)

Wahyu Purnomo [mailto:[EMAIL PROTECTED]] Sent: 28 July 2002 11:01 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.) Pada Sun, 28 Jul 2002 10:49:01 +0100 "MySQL DBA" <[EMAIL PROTECTED]> menulis : > .

MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)

Hi, I have a Solaris 8 Server. I have just compiled MySql 3.23.51. My Solaris servershas 2 NIC's - 1 with the name/ip of burns, the other with the name/ip vader I have done a make all; make install; mysql_install_db I have then copied the mysql.serverto /etc/init.d/mysql_server I start mysql

Compile guide / needed /recommended versions solaris 8 Sparc

hi, I am trying to build the best version of mysql on solaris 8 for Sparc. Can anyone please recommend 1.) The best version of Mysql to use (I am told there is a payfor version with transactions) 2.) The suggested version of GCC to use (I am using sun freewares GCC 3.1) 3.) The needed / sugge

MSQL mysql-3.23.45 on Solaris 2.6 - not charset at configure

Hello I am trying to configure mysql on solaris 2.6 when I run the configure command I use ./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql --enable-thread-safe-client --with-mysql-user=mysqldba configure reports back the following error configure: error: No size

printing/Displaying Mysql Database layout

Hello all. I am running mysql 3.x on Redhat Linux, and Solaris 2.6 and 8 Most of the development work is done on these servers. I do have a couple of windows developers using tools like mysqlfront Is there way with mysql to print out table structure in a useable text format or maybe even a gr

parallel processing in mysql

Does anyone know whether mysql supports parallel processing? I searched the documentation on mysql.com, but didn't find it mentioned thanks AOD __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocit

scaling/tuning problem

Hi. I have a query which completes in about 9 sec when executed alone, but the time grows dramatically when I execute several similar queries at the same time. If I execute 3 queries the time grows to 27-40sec, for 5 queries - toabout 1min, for 20 queries ran simultaniously the time jumps to 2-4

how to spool timing of a query into a spool file

Hi this is a 2nd attempt. My first post never made it to the list. What I'm trying to do is to spool queries results into a spool file (via tee command). For some reason the timing information doesn't get there. When I run a query from mysql, the output is followed by a line with the number of ro

how to spool timing of a query into a spool file

Hi. this is a minor problem that is driving me nuts. I have a query that runs nicely and I want to save its timing information in a spool file. When I connect to mysql and run the query it adds the time elapsed after the data (9 rows in set 1.1 sec). But when I run the same query in the line mode

more problems with Wokrbench migration tool

Hi. I have ran into couple of problems using Oracle workbench migration tool. I was wondering if anyone out there has any insight. 1. If a date field in a mysql table has a default (let's say -12-31) the script for oracle table will also have -12-31 as a default field. This doesn

Re: InnoDB Tables/Databases

Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? From what I read it looks like it will have more overhead to support the transactions and that should decrease the performance rather than improve it.

can't use m2o.pl

Hi all: I have tried running the m2o.pl scrip to convert the mysql dump into an Oracle DDL and it seems to me that it didn't do anything at all. I ran the command the way README suggest : m2o < mysqldump > oracledump, but saw a number of the mysql-specific commands in the resulting file. Has a

scheduling, priorities etc

Hi all: I have read somewhere that mysql allows inserts into a table without "holes" to go concurrently with the reads from that table. starting at v 3.23.7. I'm running 3.23.41-nt and have tried to accomplish that, but couldn't. My reads seem to only start after the inserts are completed. Is th

why, oh why do I get this error

Hi. I'm running mysql on NT. when I start it via mysqld everything works. when I try to do: mysqld --log-update, I'm getting message can't initialize innodb as 'innodb_data_file_path' is not set. I didn't see anything about innodb being related to log-update option in the manual or MySQL book.

intro mysql book

Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL internals from the dba standpoint as well as usage from a developer standpoint. I'm going to take a look at MySQL by Paul Dubois. It seems to have good reviews, but would be interested in other recom