Re: need help from the list admin

- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com: > Correct. MyISAM is not a transactional storage engine. It has no concept > of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock > and as soon as the change is complete, the table is unlocked and is

Re: need help from the list admin

- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: >> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or >> with Statement-Based-Logging or with both ? >> >> > > Both. > > >> >> I don't understand the example: >> Does "begin transaction" and "COMMIT"

Re: need help from the list admin

Am 01.04.2016 um 21:09 schrieb Lentes, Bernd: - Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: You said, "This is done on the master, written in the log and then replicated to the slave, " The INSERT would not appear in the Binary log until after session 1 commits

Re: need help from the list admin

if the transaction that rolled back contained statements that > changed MyISAM tables, then the entire transaction (all of the work it > did) needs to be written into the Binary Log and REDO log just to have > the very last command be "ROLLBACK". What that will do is create

Re: need help from the list admin

- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com: >> What is true ? when the transaction started or when the first read is >> performed ? > Until you need to establish a snapshot of the data, then you don't need > a snapshot position. > > The transaction physically

Re: need help from the list admin

On 4/1/2016 10:08 AM, Lentes, Bernd wrote: - On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:

Re: need help from the list admin

On 4/1/2016 9:12 AM, Lentes, Bernd wrote: - On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: "Unsafe" in that sense replies to the fact that certain commands can have a different effect when processed from the Binary Log than they did when they were executed ori

Re: need help from the list admin

- On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says: "...so that all queries within a transaction s

RE: need help from the list admin

- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: > "Unsafe" in that sense replies to the fact that certain commands can > have a different effect when processed from the Binary Log than they did > when they were executed originally on the system that wrote the Bina

Re: need help from the list admin

On 3/30/2016 1:26 PM, Lentes, Bernd wrote: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a webr

Re: need help from the list admin

Am 30.03.2016 um 19:26 schrieb Lentes, Bernd: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a w

RE: need help from the list admin

- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: >> So i should use the default (autocommit=1)? > > no, you should what is appropriate for your application > > if you don't care about inserts/updates triggered by let say a > webrequest are half written due a crash

Re: need help from the list admin

Am 30.03.2016 um 18:56 schrieb Lentes, Bernd: - On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: I read that the converting is not difficult. But has the code of our webapp to be changed ? It's written in php and perl. What i understand is that inserts/updates/dele

Re: need help from the list admin

- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: >> >> I read that the converting is not difficult. But has the code of our webapp >> to >> be changed ? It's written in php and perl. >> What i understand is that inserts/updates/deletions in InnoDB tables have to

Re: need help from the list admin

Am 28.03.2016 um 21:36 schrieb Lentes, Bernd: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine behaviors (tran

Re: need help from the list admin

Hello Bernd, On 3/28/2016 3:36 PM, Lentes, Bernd wrote: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine beha

Re: need help from the list admin

- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: >>> You would be better served by first converting your MyISAM tables to >>> InnoDB to stop mixing storage engine behaviors (transactional and >>> non-transactional) wit

Re: need help from the list admin

Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine behaviors (transactional and non-transactional) within the scope of a single transaction. But if you cannot convert them, using MIXED will be a

Re: need help from the list admin

- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com: > Hello Bernd, > > Sorry for the delay, I wanted to make sure I had enough time to address > all of your points. >> He proposed to have two hosts, and on each is running a MySQL instance >> as master AND slave. But

Re: need help from the list admin

Hello Bernd, Sorry for the delay, I wanted to make sure I had enough time to address all of your points. On 3/22/2016 7:07 AM, william drescher wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know t

Re: need help from the list admin

- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com wrote: >> >> Hi William, >> >> thanks for the try. Good idea ! >> Did you change anything ? >> >> >> Bernd > > Yes, in the original document there were some characters that > were put on the screen as asian pictograph

Re: need help from the list admin

On 3/22/2016 7:49 AM, Lentes, Bernd wrote: - On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know that there is a list ded

Re: need help from the list admin

- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com wrote: > sent for Bernd, and to see if it works from another sender > -- > Lentes, Bernd wrote: > Hi, > > i know that there is a list dedicated to replication, but when > y

Re: need help from the list admin

sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know that there is a list dedicated to replication, but when you have a look in the archive it's nearly complete empty. Really not busy. So i hope it's ok if i

Re: need help from the list admin

- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 19.03.2016 um 15:23 schrieb Reindl Harald: >> >> >> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: >>> one further question: >>> if some of my e-mails get through (like this one) and others don't, it >>> does not

need help from the list admin

Dear list admin, i need your help. I'm trying to write an e-Mail to the list for already one week. I always get it back because it's classified as spam. The mail is formatted as plain-text, include neither links nor attachments. I don't understand why it's classified as spam. Neither our domain

Re: need help from the list admin

Am 18.03.2016 um 14:56 schrieb Chris Knipe: Blah blah blah... Delivery to the following recipient failed permanently: mysql@lists.mysql.com Technical details of permanent failure: Your message was rejected by the server for the recipient domain lists.mysql.com by lists-mx.mysql.com. [13

Re: need help from the list admin

On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd < bernd.len...@helmholtz-muenchen.de> wrote: > i need your help. I'm trying to write an e-Mail to the list for already > one week. I always get it back because it's classified as spam. > Ditto. I've pretty much given up on this list...

Re: need help from the list admin

Am 19.03.2016 um 15:23 schrieb Reindl Harald: Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that parti

Re: need help from the list admin

Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail? both a spamfilter is typically

Re: need help from the list admin

Am 19.03.2016 um 15:08 schrieb Lentes, Bernd: Ok. I tried again: pc53200:~ # nslookup 20.103.107.146.score.senderscore.com. Server: 146.107.8.88 Address:146.107.8.88#53 Non-authoritative answer: Name: 20.103.107.146.score.senderscore.com Address: 127.0.4.62 My result is 127

Re: need help from the list admin

Hi, one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail ? Bernd Helmholtz Zentrum Muenchen Deutsches Forschungszentrum fuer Gesundh

Re: need help from the list admin

- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net: > Am 18.03.2016 um 15:25 schrieb Lentes, Bernd: >> >> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be: >> > > as i already told you offlist > senderscore.com LISTED 127.0.4.67 > > this *

Re: need help from the list admin

f the mailserver classifies you as spam, that's usually caused by something on your side :-) - Original Message - From: "Chris Knipe" To: "Lentes, Bernd" Cc: "MySql" Sent: Friday, 18 March, 2016 14:46:26 Subject: Re: need help from the list admin Ditto.

Re: need help from the list admin

; >>> - Original Message - >>> >>>> From: "Chris Knipe" >>>> To: "Lentes, Bernd" >>>> Cc: "MySql" >>>> Sent: Friday, 18 March, 2016 14:46:26 >>>> Subject: Re: need help from the list adm

Re: need help from the list admin

u as spam, that's > usually caused by something on your side :-) > > - Original Message - >> From: "Chris Knipe" >> To: "Lentes, Bernd" >> Cc: "MySql" >> Sent: Friday, 18 March, 2016 14:46:26 >> Subj

Re: need help from the list admin

> > To: "Lentes, Bernd" > > Cc: "MySql" > > Sent: Friday, 18 March, 2016 14:46:26 > > Subject: Re: need help from the list admin > > > Ditto. I've pretty much given up on this list... > > -- > Unhappiness is discouraged and will be corrected with kitten pictures. > -- Regards, Chris Knipe

Re: Lost connection to MySQL server - need help.

sounds like a scheduler issue did you try "deadline"? http://en.wikipedia.org/wiki/Deadline_scheduler on Linux systems pass "elevator=deadline" as kernel param Am 12.10.2013 20:58, schrieb Chris McKeever: > We had a similar issue a bit back - and although it sounds similar - based > on your foll

Re: Lost connection to MySQL server - need help.

We had a similar issue a bit back - and although it sounds similar - based on your followups it probably isnt, but will just toss this out there anyhows. We were experiencing connection timeouts when load would ramp up. Doing some digging we learned that our firewall between the servers bandwidth

Re: Lost connection to MySQL server - need help.

Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 17:36, Reindl Harald wrote: >> so someone did "optimize table" on a large table >> you do yourself not a favour restarting the server in such a moment > > 7 hours before the server was shut down, we did a alter table t

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 17:36, Reindl Harald wrote: > so someone did "optimize table" on a large table > you do yourself not a favour restarting the server in such a moment 7 hours before the server was shut down, we did a alter table to add a primary key to a table that is read-only from the

Re: Lost connection to MySQL server - need help.

Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 13:07, Andrew Moore wrote: >> Could be a crash related to innodb data dictionary being out of sync. Could >> be a bug. > > Seems like a bug yes. However, we had a strange situation yesterday when we > had several proc

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 13:07, Andrew Moore wrote: > Could be a crash related to innodb data dictionary being out of sync. Could > be a bug. Seems like a bug yes. However, we had a strange situation yesterday when we had several processes in the state "copying to tmp table" (if i remember the

Re: Lost connection to MySQL server - need help.

Could be a crash related to innodb data dictionary being out of sync. Could be a bug. http://bugs.mysql.com/bug.php?id=55277 On 12 Oct 2013 11:21, "Jørn Dahl-Stamnes" wrote: > On Saturday 12 October 2013 12:01, nixofortune wrote: > > You might want to comment > > > > bind-address= 12

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 12:01, nixofortune wrote: > You might want to comment > > bind-address= 127.0.0.1 > > in your my.cnf and restart mysql server. It does not explain why it works under low load and not under high load. However, I seem to have found something. When I started p

Re: Lost connection to MySQL server - need help.

You might want to comment bind-address= 127.0.0.1 in your my.cnf and restart mysql server. On 12/10/13 10:49, Jørn Dahl-Stamnes wrote: Hello, I got a strange problem related to a production server. It has been working OK for months, but yesterday it start to fail. There are seve

Lost connection to MySQL server - need help.

Hello, I got a strange problem related to a production server. It has been working OK for months, but yesterday it start to fail. There are several batch scripts using the database in addition to a web application using it. The php scripts running in batch mode began to get: mysql_connect(): L

Re: Need Help Converting Character Sets

2012/09/30 11:07 -0700, Mark Phillips The data for this table comes from a web page (charet utf8). I copy/paste word files into gedit (on linux) and then copy/paste from gedit to a text boxes on the web page input form. I had thought I was stripping out all the funky characters by usin

RE: Need Help Converting Character Sets

the single straight one. But that would be work for you to explicitly do. If you are using PHP, see functions htmlentities() and html_entity_decode(). > -Original Message- > From: Mark Phillips [mailto:m...@phillipsmarketing.biz] > Sent: Sunday, September 30, 2012 11:08

Re: Need Help Converting Character Sets

COLUMN BINARY (or BLOB); -- to forget any charset > knowledge > ALTER TABLE ... MODIFY COLUMN CHARACTER SET ...; -- coming from BINARY, > this does not check the encoding. > (sorry, don't have the link handy) > > > -Original Message----- > > From: h...@tb

RE: Need Help Converting Character Sets

the encoding. (sorry, don't have the link handy) > -Original Message- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Thursday, September 27, 2012 2:24 PM > To: Mark Phillips > Cc: Mysql List > Subject: Re: Need Help Converting Character Sets > > >>&

Re: Need Help Converting Character Sets

essage- >> From: Mark Phillips [mailto:m...@phillipsmarketing.biz] >> Sent: Monday, September 24, 2012 4:28 PM >> To: Mysql List >> Subject: Need Help Converting Character Sets >> >> I have a table, Articles, of news articles (in English) with three text &

Re: Need Help Converting Character Sets

2012/09/24 16:28 -0700, Mark Phillips I have a table, Articles, of news articles (in English) with three text columns for the intro, body, and caption. The data came from a web page, and the content was cut and pasted from other sources. I am finding that there are some non utf-8 characte

RE: Need Help Converting Character Sets

eclared for the column they go in. (Presumably, all the text columns will be declared utf8 or utf8mb4.) > -Original Message- > From: Mark Phillips [mailto:m...@phillipsmarketing.biz] > Sent: Monday, September 24, 2012 4:28 PM > To: Mysql List > Subject: Need Help Convertin

Need Help Converting Character Sets

I have a table, Articles, of news articles (in English) with three text columns for the intro, body, and caption. The data came from a web page, and the content was cut and pasted from other sources. I am finding that there are some non utf-8 characters in these three text columns. I would like to

Re: Need help for performance tuning with Mysql

default` enum('on','off') default NULL > Did you really mean to have 3 values (on, off, NULL)? > > > > > -Original Message- > > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com] > > Sent: Wednesday, May 23, 2012 7:10 PM > > To: my

RE: Need help for performance tuning with Mysql

('on','off') default NULL Did you really mean to have 3 values (on, off, NULL)? > -Original Message- > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com] > Sent: Wednesday, May 23, 2012 7:10 PM > To: mysql@lists.mysql.com > Subject: Re: Need help for

Re: Need help for performance tuning with Mysql

Johnny Thank you for the reply. >Second, make sure your Innodb buffer pool is allocating as much ram as >possible. I'd even go as far as adding another 8gb of ram to the >server. The buffer pool setting is going to give you the best >performance increase. The problem is mainly on MyISAM engine

Re: Need help for performance tuning with Mysql

Alex Thank you for the advice. Probably, we will put index (key) on both columns. Thanks, Yu Alex Schaft さんは書きました: >On 2012/05/24 07:37, Alex Schaft wrote: >> You are selecting a record based on the value of data_id and >> thold_enabled, but don't have an index on either? Add an index for both.

Re: Need help for performance tuning with Mysql

On 2012/05/24 07:37, Alex Schaft wrote: > You are selecting a record based on the value of data_id and > thold_enabled, but don't have an index on either? Add an index for both. > If data_id is unique, then you would only need an index on that. > > Alex > On second thought, an index on thold_enabl

Re: Need help for performance tuning with Mysql

On 2012/05/24 04:10, Yu Watanabe wrote: > 2. Instead INDEXes and schema design must be studied. Please provide: > SHOW CREATE TABLE > | thold_data | CREATE TABLE `thold_data` ( > `id` int(11) NOT NULL auto_increment, > `rra_id` int(11) NOT NULL default '0', > `data_id` int(11) NOT NU

Re: Need help for performance tuning with Mysql

query. Tuning will not help. Period. > >1. There are only a few things worth tuning -- see >http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried) > >2. Instead INDEXes and schema design must be studied. Please provide: >SHOW CREATE TABLE &

RE: Need help for performance tuning with Mysql

BLE SIZE EXPLAIN SELECT ... > -Original Message- > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com] > Sent: Tuesday, May 22, 2012 7:07 PM > To: mysql@lists.mysql.com > Subject: Need help for performance tuning with Mysql > > Hello all. > > I would like

Re: Need help for performance tuning with Mysql

Hi, How much ever tuning you do at my.cnf will not help much, if you do not tune your sql's. Your first priority should be tune sql's, which will give you good performance even with decent memory allocations and other settings regards anandkl On Wed, May 23, 2012 at 3:45 PM, Andrew Moore wrote:

Re: Need help for performance tuning with Mysql

Yu, The upgrade to 5.5 that Jonny advises should NOT your first action. If MySQL is mis-configured on 5.0 it will likely be misconfigured on 5.1 and 5.5. Test your application thoroughly on the new version before heeding that advice. Read the change logs and known bugs. Running the upgrade might s

Re: Need help for performance tuning with Mysql

Hello, Yu-san, (へろへろな英語で申し訳ないです) Can I think that you already tweaked Index on the tables? if you yet,please create apt indexes. MyISAM caches only Index without data. i take way for decreasing disk seek, 1) create more indexes on the tables,if the tables doesn't update quite often. including

Re: Need help for performance tuning with Mysql

Hello Tsubasa. Thank you for the reply. (返信ありがとうございます。) Our high loaded DB are both INNODB and MyISAM. Espicially , on MyISAM. I will consider the tuning of innodb_buffer_pool_size as well. Do you know the tips for how to tune the disk access for MyISAM? Thanks, Yu Tsubasa Tanaka さんは書きました: >

Re: Need help for performance tuning with Mysql

I don't see any attachments. First, I would upgrade to 5.5 as 5.0 is very old. The upgrade process is painless. Second, make sure your Innodb buffer pool is allocating as much ram as possible. I'd even go as far as adding another 8gb of ram to the server. The buffer pool setting is going to give

Re: Need help for performance tuning with Mysql

Hello, I seem your mysqld doesn't use enough memory. >>Date Time CPU% RSS VSZ >>2012/5/22 21:00:39 109 294752 540028 if your mysqld uses InnoDB oftenly, edit innodb_buffer_pool_size in you my.cnf. http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_b

Re: Need help for performance tuning with Mysql

Also following is the free command result. total used free sharedbuffers cached Mem: 81623807843676 318704 0 956325970892 -/+ buffers/cache:17771526385228 Swap: 8032492 235608008932 Thanks, Yu Yu Watanabe

Need help for performance tuning with Mysql

Hello all. I would like to ask for advice with performance tuning with MySQL. Following are some data for my server. CPU: Xeon(TM) 2.8GHz (2CPUs - 8core total) Memory : 8GB OS : RHEL 4.4 x86_64 MySQL : MySQL 5.0.50sp1-enterprise Attached file # my.cnf.txt : my.cnf info

RE: need help with -- unknown variable

l.com Subject: Re: need help with -- unknown variable Check if this is in the [mysqldump] section of your my.cnf file(s). Of course it might not be a valid option in mysqldump...I haven't checked... On 13 Jun 2011 17:00, "Brown, Charles" mailto:cbr...@bmi.com>> wrote: > He

Re: need help with -- unknown variable

Check if this is in the [mysqldump] section of your my.cnf file(s). Of course it might not be a valid option in mysqldump...I haven't checked... On 13 Jun 2011 17:00, "Brown, Charles" wrote: > Hello All ~ I attempted to do a mysqldump when I got this message -- see below: > > mysqldump: unknown va

need help with -- unknown variable

Hello All ~ I attempted to do a mysqldump when I got this message -- see below: mysqldump: unknown variable 'datadir=/var/lib/mysql' Please can someone help me. Thanks This message is intended only for the use of the Addressee and may contain in

Re: need help creating relation

I could be wrong but I think your problem is the unique index. -- João Cândido de Souza Neto "robert rottermann" escreveu na mensagem news:4dd967a8.5040...@redcor.ch... > Hi there, > > I would like to create a table that optionally links to an other table. > > The field company_id in the fol

need help creating relation

Hi there, I would like to create a table that optionally links to an other table. The field company_id in the following table should be either Null or link to the table tblCompany (`id` ). How do I do that. The way I it now, I can not enter records where the field company_id is null. Thanks

Re: Need help with query

2011/03/15 17:51 -0500, LAMP Let's say there is a table orders (simplified, of course) CREATE TABLE orders ( item_id int, org_id int, ) ENGINE=MyISAM Need to select all (distinct) org_id they have item_id 34, 36, 58 and 63. All of them, not only some of them. Result is org_id=2

Re: Need help with query

Hi! I think that the query that you have proposed is the best possible for the problem. However, if there are duplicates in the orders table, then HAVING COUNT(item_id) = 4 should be replaced with HAVING COUNT(DISTINCT item_id) = 4 (I assume that you meant item_id and not org_id in the COU

Re: Need help with query

2011/03/18 08:49 -0500, LAMP Is here anybody from mysql development team, to suggest to build IN ALL function? There is a problem here: the basic operation is on the record, each record by each record, all by itself. The solution to your problem entails acting on more distinc

Re: Need help with query

On Mar 17, 2011, at 3:01 PM, Geert-Jan Brits wrote: Indeed, I don't thing there is. Just be sure that each record has an unique combination of org_id and item_id, otherwise you might end up with an org_id that, for example, references 4 times item_id 34 in 4 different records, but no oth

Re: Need help with query

First I was thinking there is function IN ALL or something like that, since there are functions IN and EXISTS. And I would be able to make a query something like this select distinct org_id, item_id from orders where item_id in all (34, 36, 58, 63) order by org_id asc But, there

Re: Need help with query

> What I need is a list of orgs they bought all of items 34, 36, 58, 63. every of them. Some solutions under "What else did buyers of X buy" at http://www.artfulsoftware.com/infotree/queries.php. PB --- On 3/17/2011 12:00 PM, LAMP wrote: Yes, that was my question. Though, since English is n

Re: Need help with query

Yes, that was my question. Though, since English is not my first language, let me try to post it again: There is a list of all orgs and items org bough, from table called orders item_idorg_id 342607 342607 341520 362607 361520 368934 38

Re: Need help with query

On Mar 15, 2011, at 6:18 PM, Rhino wrote: All you should need is this: select distinct org_id from orders where item_id in (34, 36, 58, 63) I'm assuming that the DISTINCT operator is available in the version of MySQL that you are using. I don't currently have any version of MySQL instal

Need help with query

Hi, I need a help to build a query. Let's say there is a table orders (simplified, of course) CREATE TABLE orders ( `item_id` int, `org_id` int, ) ENGINE=MyISAM item_idorg_id 342607 342607 341520 362607 361520 368934 3828 3815

Re: need Help - Mysqldump issue

Hello, Thank for your help I just try mysqldump with --quick or --opt option ... to avoid "out of memory" problem but --> dump fails with --max_allowed_packet=2048M and --quick : r...@pcjahia01:/# /usr/bin/mysqldump -A --max_allowed_packet=2048M --quick --default-character-set=UTF8 -

need Help - Mysqldump issue

Hello, Starting today, my daily database backup script does not work :-( with mysqldump typically Out of memory error. So, I try to change max_allowed_packet option value, but I don't succeed (mysql run on ubuntu 10.04 OS with 5.1.41-3ubuntu12.7 0 mysql version.) On the last successfull backu

Re: Need Help Writing Simple Query

t 1) as name_2 > from test1; > > - test1 table: > col1v_idh_id > America 1 2 > > - test2 table: > id name > 2 SAM > 1 UNCLE > > - Original Message - > From: "Mark Phillips" > To: "Mysql List" >

Re: Need Help Writing Simple Query

On 07/25/2010 09:29 PM, Mark Phillips wrote: I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two tables. Table 1 has many columns, two of which are hID and vID. Table 2 has two columns, ID and name. The hID and vID in table 1 correspond to the I

Re: Need Help Writing Simple Query

SAM 1 UNCLE - Original Message - From: "Mark Phillips" To: "Mysql List" Sent: Monday, July 26, 2010 8:29:00 AM Subject: Need Help Writing Simple Query I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two

Need Help Writing Simple Query

I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two tables. Table 1 has many columns, two of which are hID and vID. Table 2 has two columns, ID and name. The hID and vID in table 1 correspond to the IDs in table 2. I want to make a query so I get

Re: Need help with query optimization

It may only be returning 51 rows but its having to read significantly more. Get rid of the derived table join if possible. Something like SELECT TAP.ID , M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,

Re: Need help with query optimization

Can you please show us the indexes on both the tables. regards anandkl On Tue, Mar 16, 2010 at 11:47 PM, Jesse wrote: > I have the following query: > > SELECT TAP.ID , M.UID, TAP.FirstName, TAP.MI, > TAP.LastName, TAP.State, > TAP.SchoolName, TAP.StateApproved, TAP.DiplomatAppro

Need help with query optimization

I have the following query: SELECT TAP.ID, M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType, S.Region, S.District,Pts.TotPoints FROM TorchAwardParticipants TAP JOIN Members M On M.ID=TAP.CurrentMemberID JOIN Chapters

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

Give the ful path of file name with in '' and try it out Thanks Suresh Kuna MySQL DBA --Original Message-- From: Colin Streicher To: mysql@lists.mysql.com Cc: kebede teferi ReplyTo: co...@obviouslymalicious.com Subject: Re: I NEED HELP ON 'SOURCE(\.) MYSQL Sent: Feb 2, 201

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

what everyone else said... also, is there a longer version of the error? or is it literally error 2 or error 22? Colin On February 1, 2010 06:38:08 pm kebede teferi wrote: > Hi, I'm very new to this and I need help. > > What I want to do is to execute a source command stateme

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

Error 2 is "No such file or directory" So, probably the file is not in the right path or you need to explicitly provide the path to the file. Carlos On 2/1/2010 5:38 PM, kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

On 02/01/2010 06:38 PM, kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd to create tables and populate them on a data base that I created in Mysql. Here is what I did at CMD: *I changed the directory f

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

How did you type the source command? Did you remember not to quote the file name? E.g. mysql> SOURCE schema.sql is the correct way. Jesper On Tue, 2 Feb 2010 10:38:08 kebede teferi wrote: > Hi, I'm very new to this and I need help. > > What I want to do is to execute

I NEED HELP ON 'SOURCE(\.) MYSQL

Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd to create tables and populate them on a data base that I created in Mysql.  Here is what I did at CMD: *I changed the directory from c:\> to mysql *At mysql prompt i used -u

  1   2   3   4   5   6   7   8   9   10   >