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: 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 one of those l

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

Jesper Andersson wrote: Hello, I relly new with databases and writing sql-questions. But in my db want I to check what have new rows have come the last hour. the db have I as follow: ID email created updated 001 [EMAIL PROTECTED] 20050215131034 20050215133401 06

Re: MySQL as Email database [sort of OT]

Brent Baisley wrote: I am looking to store all incoming emails into a MySQL database. I've looked into dbmail, but can't get it to compile under Mac OSX (I posted a message on that list). I was wondering if anyone could point me in another direction to use MySQL as an email message store. I don

Re: Difference between 'LIKE' and '='

Joshua Beall wrote: Hi All, From what I understand the LIKE keyword allows you to do things like include wildcards and match against regular expressions. But I have a question: is there any difference between the following? SELECT lname, fname FROM contacts WHERE lname = 'smith'; SELECT lname, fna

Re: Syntax for Compound "IF" Statements?

Harald Fuchs wrote: That's correct, but it can be written shorter and clearer: CASE Lccation WHEN 1 THEN 'Downstairs Cat Room' WHEN 2 THEN 'Kitten Room' WHEN 3 THEN 'Quarantine' ELSE 'Unknown' END AS Location - surely it would be better to have the location ids and location names in a lookup ta

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

Kevin A. Burton wrote: Jason J. W. Williams wrote: Has anyone ever had a problem with Alteon load balancers leaving the MySQL connections half open? After about a minute of heavy use the Alteon has completely DoS'd our MySQL servers. I know we must be doing something wrong...just not sure what. Any

Re: A problem of structure

Pupeno wrote: What I don't like about that, is that half the person_id fields would be empty and half the group_id fields would be empty. I was thinking about: SONG-TO-PERSON-OR-GROUP LINK TABLE * song_id * musician_id * type ('person', 'group') * role (performer, lyricist, etc.) But this is the

Re: A problem of structure

Pupeno wrote: Now that I'm thinking about a fourth solution: Have two totally separate tables for groups and persons (this is what I really like) and then, one table to relate songs to persons, and another table to relate songs to groups. The problem with that is that, sometimes, I need to get a

Re: mydb-bin.xxx files

Philippe de Rochambeau wrote: my /var/lib/mysql directory contains many -bin.xxx files, some of which date back to October 2004. What exactly are these files? Can I safely remove the older ones? - these are the bin logs, used in replication. MySQL writes all INSERT, UPDATE, etc., and DDL co

Re: Slackware10 & mysql

Mohsen Pahlevanzadeh wrote: Dears,I have slackware10.I install it completely. But when i use /etc/rc.d/rc.mysqld start ,I recieve following mesage : mysql ended Please guide me that i can configure mysql in slack. Yours,Mohsen - look in the .err file (probably located in your data directory) to

Re: Complicated Query

Ron Watson wrote: This works, but only if a title and a role exists for the company member. Basically, I want to display the season name from tbl Season, then the show title from tbl Shows, then the roles from cast and titles from production_team for the company member. - use LEFT JOINs. - ian

Re: Can't drop index.

sam wun wrote: Hi, I created an index on a foreign in a table before. I need to drop this index. but I got the following error: mysql> alter table transaction drop index prodcode; ERROR 1025 (HY000): Error on rename of './datacube/#sql-30e8_3' to './datacube/transaction' (errno: 150) - you need t