Re: Question about contributing a patch

2017-10-09 Thread shawn l.green
On 10/9/2017 3:27 AM, Xiaoyu Wang wrote: Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, as well as a patch. And Bogdan, the bug hunter, told me this patch would show up on the dev contribution report. So, could anyone please tell me how to contact dev team, or how can I

Re: question?

2015-01-08 Thread Ron Piggott
The only way I could see this work would be to write forms to a temporary text file array. Then using a cron job to update the database. On Thu, January 8, 2015 10:01 am, bruce wrote: > hey. > > within php (or any other language) > > is there a way to create the mysql sql, and execute the sql, wh

Re: question?

2015-01-08 Thread Reindl Harald
Am 08.01.2015 um 16:01 schrieb bruce: hey. within php (or any other language) is there a way to create the mysql sql, and execute the sql, where the process can "wait" until the network connection for the mysql command/process is actually valid? IE (phpesque) $pdo=new pdo() sql = "select * f

Re: Question regarding creating a query

2013-07-30 Thread hsv
2013/07/30 14:12 -0400, Sukhjinder K. Narula I have several databases (all with same structure), which I to query. For instansce: db1, db2, db3 - all have table tb1 with field a, b and table tb2 with fields flag1, flag2 So I want to query and get field a from tb for all db's. One way to

RE: Question regarding creating a query

2013-07-30 Thread Rick James
> I have to update the query every time. Therein lies the difficulty with the schema design. You could write a stored procedure to locate all the tables (use information_schema.TABLES, etc) and build the UNION, and finally execute it. The SP would have something very remotely like the foreach y

RE: Question about Innodb

2013-02-04 Thread Rick James
Meta info about the tables is stored in ibdata1. Hence, it is not possible to copy just the .ibd file to another database or machine. 5.6.x will remedy this with some export/import commands that do not involve reading/writing the rows individually. (Ditto for moving partitions.) (Sorry, I do

RE: Question about testing memcmp()

2012-06-25 Thread Stillman, Benjamin
By recent security breach, do you mean the issue with passwords? If so: http://www.dbasquare.com/2012/06/11/a-security-flaw-in-mysql-authentication-is-your-system-vulnerable/ for i in `seq 1 2000`; do mysql -u USERNAME --password=INCORRECTPASSWORD -h HOSTNAME ; done If you get in using that, yo

Re: Question about testing memcmp()

2012-06-25 Thread Reindl Harald
Am 25.06.2012 06:17, schrieb Sabika Makhdoom: > I want to test our memcmp() binaries to see if we have the mysql binaries > that are impacted by the recent security breach. How do I test it? why do you simply not update? signature.asc Description: OpenPGP digital signature

Re: Question about deleting data and the undo log

2011-12-02 Thread Rik Wasmus
> Does "drop table" use the undo log (rollback segment) to temporarily store > records to be purged later, the way "delete from table" does? As 'DROP TABLE' causes an implicit commit (http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html), I would highly suspect that it doesnt. You cannot

Re: Question relating to transactions on innodb tables.

2011-11-25 Thread Reindl Harald
Am 25.11.2011 14:20, schrieb Machiel Richards - Gmail: > Just a quick question relating to the use of transactions on innodb tables. > > We are doing some archiving on some innodb tables, however there seems to be > some issues somewhere in the > process with data not being updated accordingly.

Re: [question]any performance tools about UPDATE

2011-09-23 Thread Prabhat Kumar
I don't think any other than > show full processlist. In which state query is locked or not. I/O related things you check at OS level. On Thu, Sep 22, 2011 at 11:07 PM, jiangwen jiang wrote: > Hi, > > Is there any performance toolds about UPDATE/INSERT querys? > I want to monitor the UPDATE/INSE

Re: Question about slow storage and InnoDB compression

2011-09-14 Thread Suresh Kuna
-+---++-+-+--+---++-+-+-+---+--+-+-----+ > > > I am still benchmarking, bu

Re: Question about slow storage and InnoDB compression

2011-09-14 Thread Reindl Harald
Am 14.09.2011 14:50, schrieb Maria Arrea: > I have finally enabled compression: > I am still benchmarking, but I see a 15-20% performance gain after enabling > compression using bacula gui as expected if disk-io is the only bottenleck the same with NTFS-Compression inside a VMware Machine on mod

Re: Question about slow storage and InnoDB compression

2011-09-14 Thread Maria Arrea
| | +++-++---++-+-+--+---++-+-+-+---+--+-+-+ I am still benchmarking, but I see a 15-20% performance gain after enabling compression using bacula gui (bat). Regards Maria - Original Message - From: Maria Arrea Sent: 09/14/11 09:50 AM To: mysql@lists.mysql.com Subject: Re: Question about slow storage and InnoDB

Re: Question about slow storage and InnoDB compression

2011-09-14 Thread Reindl Harald
Am 14.09.2011 09:50, schrieb Maria Arrea: > I have read all your mails, and still not sure if I should enable innodb > compression if you have enough free cpu-ressources and IO is your problem simply yes because the transfer from/to disk will be not so high as uncompressed signature.asc

Re: Question about slow storage and InnoDB compression

2011-09-14 Thread Maria Arrea
The server hosting bacula and the database only has one kind of disk: SATA, maybe I should buy a couple of SSD for mysql. I have read all your mails, and still not sure if I should enable innodb compression. My ibfile is 50 GB, though. Regards Maria Questions: 1) Why are you putting you

Re: Question about slow storage and InnoDB compression

2011-09-13 Thread Suresh Kuna
Thanks for correcting me in the disk stats Singer, A typo error of SSD instead of SAS 15k rpm. Compression may not increase the memory requirements : To minimize I/O and to reduce the need to uncompress a page, at times the buffer pool contains both the compressed and uncompressed form of a databa

Re: Question about slow storage and InnoDB compression

2011-09-13 Thread Suresh Kuna
I would recommend to go for a 15K rpm SSD raid-10 to keep the mysql data and add the Barracuda file format with innodb file per table settings, 3 to 4 GB of innodb buffer pool depending the ratio of myisam v/s innodb in your db. Check the current stats and reduce the tmp and heap table size to a lo

Re: Question about Backup

2011-03-22 Thread Wm Mussatto
and that the backup needs to be >> consistent :-p >> >> >> - Original Message - >>> From: "Reindl Harald" >>> To: mysql@lists.mysql.com >>> Sent: Monday, 21 March, 2011 12:44:08 PM >>> Subject: Re: Question about Backup &g

Re: Question about Backup

2011-03-22 Thread Karen Abgarian
at the database is one table of 5.000 gigabyte, and not > 5.000 tables of one gigabyte; and that the backup needs to be consistent :-p > > > - Original Message - >> From: "Reindl Harald" >> To: mysql@lists.mysql.com >> Sent: Monday, 21 March, 2011 12:

Re: Question about Backup

2011-03-22 Thread Johan De Meersman
You are assuming that the database is one table of 5.000 gigabyte, and not 5.000 tables of one gigabyte; and that the backup needs to be consistent :-p - Original Message - > From: "Reindl Harald" > To: mysql@lists.mysql.com > Sent: Monday, 21 March, 2011 12:44:

Re: Question about Backup

2011-03-21 Thread Karen Abgarian
That would be the last question :-) Suppose we worked out strategy, lined up the solutions along with their costs and then compare them with our budget. That would be easy to find the one we can afford, and we will know what we could dream about :-). On Mar 21, 2011, at 11:28 AM, Singer X.

Re: Question about Backup

2011-03-21 Thread Karen Abgarian
Hi, The statement like 'I need to back up a 5T database' is not a backup strategy. It is intention. There are some specifics that have to be determined to work out a strategy. Going from there, the backup solution can be chosen. The examples of questions one typically asks when determinin

Re: Question about Backup

2011-03-21 Thread Reindl Harald
Forget mysqldump because TABLE LOCKS for so hughe databases I would setup a replication-slave because you can stop the salave and make a filesystem-backup of the whole db-folder while the production server is online, we do this with our dbmail-server since 2009 Am 21.03.2011 12:23, schrieb Pedro N

Re: Question about performance

2011-03-01 Thread András Lukács
Or you can interrupt the query instead, although I've seen it not to work on occasions: KILL QUERY id; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Question about performance

2011-02-17 Thread Reindl Harald
I am working with mysql since many yaers and i have never found e reason to kill braindead connections - what benefit do you think to have from such actions instead looking why there are hanging ones? kill a connection of postfix and some user gets "temorary lookup error", php-scripts are closing

Re: Question about performance

2011-02-17 Thread Michael Dykman
Rafael, You realize that script will kill perfectly well-behaved queries in mid-flight? If you have so many dead connections that it is interfering with operation, you have another problem elsewhere.. - md On Thu, Feb 17, 2011 at 4:16 PM, Rafael Valenzuela wrote: > Hi Michael: > > Yeah , i t

Re: Question about performance

2011-02-17 Thread Rafael Valenzuela
Hi Michael: Yeah , i think that i do a shell script.something like that. require 'mysql' mysql = Mysql.new(ip, user, pass) processlist = mysql.query("show full processlist") killed = 0 processlist.each { | process | mysql.query("KILL #{process[0].to_i}") } puts

Re: Question about performance

2011-02-17 Thread Michael Dykman
from the mysql console: > show processlist this will show you ids of all active connections, even the dead ones then, again form the console > kill On Thu, Feb 17, 2011 at 3:52 PM, Rafael Valenzuela wrote: > Hi all; > I wonder if there is any tool to Performance Tuning querys. In other know i

Re: Question about database value checking

2011-02-04 Thread Andy Wallace
Thanks Peter, exactly what I was hoping for! andy On 2/4/11 3:11 PM, Peter He wrote: Are you using the strict SQL mode? Check your my.cnf file. Peter Date: Fri, 4 Feb 2011 14:08:01 -0800 From: awall...@ihouseweb.com To: mysql@lists.mysql.com Subject: Question about database value checking

RE: Question about database value checking

2011-02-04 Thread Peter He
Are you using the strict SQL mode? Check your my.cnf file. Peter > Date: Fri, 4 Feb 2011 14:08:01 -0800 > From: awall...@ihouseweb.com > To: mysql@lists.mysql.com > Subject: Question about database value checking > > So, a problem popped up today that has caused us no end of hair-pulling, an

Re: question about restoring...

2010-11-12 Thread Andy Wallace
Thanks, guys. I have copies of the innodb files. The boss went whole hog on using zfs for everything, so backups of files are readily available. Looks like I'll be having the db reconstituted... thanks again On 11/12/10 1:05 AM, Johan De Meersman wrote: From the OP: I have a copy of the I

Re: question about restoring...

2010-11-12 Thread Ananda Kumar
If you just need specific records, you can use "-w" option of mysql to extract only the specifc records. Then you can run the dump file into another db. regards anandkl On Fri, Nov 12, 2010 at 2:35 PM, Johan De Meersman wrote: > From the OP: > > > I have a copy of the INNODB files for these two

Re: question about restoring...

2010-11-12 Thread Johan De Meersman
>From the OP: > I have a copy of the INNODB files for these two tables - is there a way > to extract the table contents from these files short of a full import? > I have to agree, that's quite ambiguous. Andy, is it a copy of the innoDB datafiles, or a database dump that you have ? In the latter

RE: question about restoring...

2010-11-10 Thread Jerry Schwartz
hwartz Cc: Gavin Towey; Andy Wallace; mysql list Subject: Re: question about restoring... On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz wrote: Then I guess it's a matter of preference. I'd rather edit a text file than build a new instance of MySQL. The way I parse that, you'

Re: question about restoring...

2010-11-09 Thread Johan De Meersman
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz wrote: > Then I guess it's a matter of preference. I'd rather edit a text file than > build a new instance of MySQL. > The way I parse that, you're saying that there is a way to reattach ibd files to another database ? -- Bier met grenadyn Is al

RE: question about restoring...

2010-11-09 Thread Jerry Schwartz
#x27;; 'mysql list' >Subject: RE: question about restoring... > >Not if he has the raw innodb files. > > >-Original Message- >From: Jerry Schwartz [mailto:je...@gii.co.jp] >Sent: Tuesday, November 09, 2010 11:05 AM >To: Gavin Towey; 'Andy Wallace'; &#

RE: question about restoring...

2010-11-09 Thread Gavin Towey
Not if he has the raw innodb files. -Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: Tuesday, November 09, 2010 11:05 AM To: Gavin Towey; 'Andy Wallace'; 'mysql list' Subject: RE: question about restoring... That's overkill. You should b

RE: question about restoring...

2010-11-09 Thread Jerry Schwartz
l: je...@gii.co.jp Web site: www.the-infoshop.com >-Original Message- >From: Gavin Towey [mailto:gto...@ffn.com] >Sent: Tuesday, November 09, 2010 1:50 PM >To: Andy Wallace; mysql list >Subject: RE: question about restoring... > >No, you should import the data into another instan

RE: question about restoring...

2010-11-09 Thread Gavin Towey
No, you should import the data into another instance of mysql to extract the records. Regards, Gavin Towey -Original Message- From: Andy Wallace [mailto:awall...@ihouseweb.com] Sent: Tuesday, November 09, 2010 10:34 AM To: mysql list Subject: question about restoring... So, I got a req

Re: question about VIEWS in 5.1.x

2010-09-06 Thread Jangita
On 03/09/2010 9:26 p, Hank wrote: On Fri, Sep 3, 2010 at 6:23 AM, Jangita wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: Hank, Have you tried "running away from the problem :-)" by doing... CREATE PROCEDURE `combo`(theid INT) BEGIN (SELECT * FROM table1 WHER

Re: question about VIEWS in 5.1.x

2010-09-06 Thread Jangita
On 03/09/2010 9:27 p, Hank wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: Hank, Have you tried "running away from the problem :-)" by doing... CREATE PROCEDURE `combo`(theid INT) BEGIN (SELECT * FROM table1 WHERE id = theid) UNION (SELECT * FRO

Re: question about VIEWS in 5.1.x

2010-09-03 Thread Hank
On 02/09/2010 8:30 p, Hank wrote: >> >> Simple question about views: >> >> > Hank, > Have you tried "running away from the problem :-)" by doing... > > CREATE PROCEDURE `combo`(theid INT) > BEGIN >(SELECT * FROM table1 WHERE id = theid) >UNION >(SELECT * FROM table2 WHERE id

Re: question about VIEWS in 5.1.x

2010-09-03 Thread Shawn Green (MySQL)
On 9/3/2010 6:23 AM, Jangita wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: I have a view such as: create view combo as select * from table1 union select * from table2; ... (I've also tried "UNION ALL" with the same results). ...

Re: question about VIEWS in 5.1.x

2010-09-03 Thread Jangita
On 02/09/2010 8:30 p, Hank wrote: Simple question about views: I have a view such as: create view combo as select * from table1 union select * from table2; Where table1 and table2 are very large and identical and have a non-unique key on field "id".. wh

Re: Question on http query

2010-06-02 Thread Michael Dykman
MySQL is a tradition Relational DataBase System. It underlays something like 80% (somebody correct me if I'm out-of-date here) of the http applications populating the internet. While some RDBMSs offer extensions for RESP-like HTTP implementations, MySQL does not support this directly. It can be

RE: Question about DELETE

2010-03-18 Thread Price, Randall
.com] Sent: Thursday, March 18, 2010 11:15 AM To: Price, Randall Cc: Ian Simpson; Johan De Meersman; [MySQL] Subject: Re: Question about DELETE delete will also cause the undo(before image) to be generated, in case u want to rollback. This will also add up to the delete completion time. After each m

Re: Question about DELETE

2010-03-18 Thread Ananda Kumar
umber of deletes. > > So I am at a quandary as to how to make this delete process perform better. > > Thanks, > > -Randall Price > > > -Original Message- > From: Ian Simpson [mailto:i...@it.myjobgroup.co.uk] > Sent: Thursday, March 18, 2010 10:11 AM > To

RE: Question about DELETE

2010-03-18 Thread Price, Randall
: Thursday, March 18, 2010 10:11 AM To: Price, Randall Cc: Johan De Meersman; Ananda Kumar; [MySQL] Subject: RE: Question about DELETE Hi Randall, If you're talking about processes that are taking that long, then running SHOW PROCESSLIST several times during the operation should give you a rough

RE: Question about DELETE

2010-03-18 Thread Ian Simpson
he more records you delete, > unless the indexing is happening multiple times? > > Thanks, > > -Randall Price > > > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De > Meersman > Sent: Thursday, March 18, 2010 6:48 AM > To: Ananda Kumar >

RE: Question about DELETE

2010-03-18 Thread Price, Randall
] On Behalf Of Johan De Meersman Sent: Thursday, March 18, 2010 6:48 AM To: Ananda Kumar Cc: Price, Randall; [MySQL] Subject: Re: Question about DELETE Given that OP is talking about a single delete statement, I'm gonna be very surprised if he manages to squeeze an intermediate commit in

Re: Question about DELETE

2010-03-18 Thread Johan De Meersman
Given that OP is talking about a single delete statement, I'm gonna be very surprised if he manages to squeeze an intermediate commit in there :-) For a single-statement delete on a single table, the indexes will be rebuilt only once. I'm not entirely sure what happens to cascaded deletes, though.

Re: Question about DELETE

2010-03-17 Thread Ananda Kumar
Hi, It depends how frequently ur doing a commit. If you have written a plsql, with loop and if you commit after each row is deleted, then it get update for each row. Else if you commit at the end the loop, it commits only once for all the rows deleted. regards anandkl On Thu, Mar 18, 2010 at 1:21

Re: question regarding mysql database location

2009-11-26 Thread Manasi Save
Lue ; mysql > Sent: Wed, November 25, 2009 8:12:25 PM > Subject: Re: question regarding mysql database location > > Dear Johan, > > Need your help again in understanding How mysql reads symlink. > > As you said below, I have created symlinks in default mysql directory. &

Re: question regarding mysql database location

2009-11-26 Thread Manasi Save
Hi Johan, It worked perfectly. Thank you so much for this explanation. I am really greatful. -- Best Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save < > manasi.s...@artificialmachines.com> wrote: > >> Dear Johan, >> >> Need your help again in un

Re: question regarding mysql database location

2009-11-26 Thread nitin mehta
Is mysql the owner of the directories? - Original Message From: Manasi Save To: Johan De Meersman Cc: Waynn Lue ; mysql Sent: Wed, November 25, 2009 8:12:25 PM Subject: Re: question regarding mysql database location Dear Johan, Need your help again in understanding How mysql reads

Re: question regarding mysql database location

2009-11-25 Thread Johan De Meersman
On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Dear Johan, > > Need your help again in understanding How mysql reads symlink. > > As you said below, I have created symlinks in default mysql directory. > and try to read that symlink file as a database. B

Re: question regarding mysql database location

2009-11-25 Thread Manasi Save
Dear Johan, Need your help again in understanding How mysql reads symlink. As you said below, I have created symlinks in default mysql directory. and try to read that symlink file as a database. But mysql is not reading that file as Database. Is there any settings which I need to change. Thanks

Re: question regarding mysql database location

2009-11-25 Thread Manasi Save
Thanks Johan, It was really a great help. I'll try to implement it. I dont want to opt for multiple mysql instances option as thats not feasible. I'll get back to you all if it works fine. Thanks again. -- Best Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 11:55

Re: question regarding mysql database location

2009-11-25 Thread Johan De Meersman
On Wed, Nov 25, 2009 at 12:05 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > At a time mysql can point to one data directory. For your task you can have > n number of mysql installation with different data directory. After that > you > can use federated storage engine to perform y

Re: question regarding mysql database location

2009-11-25 Thread Johan De Meersman
On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Hi Johan, > > I am Sorry. If I have complicated the senerio But, this still not fix my > purpose. > > What I want is - From your example :- > > /data/disk1/mysql/db1 (directory) > /db2 (dir

Re: question regarding mysql database location

2009-11-25 Thread Krishna Chandra Prajapati
Hi Manasi, At a time mysql can point to one data directory. For your task you can have n number of mysql installation with different data directory. After that you can use federated storage engine to perform your task. Thanks, Krishna Ch. Prajapati On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save <

Re: question regarding mysql database location

2009-11-25 Thread Manasi Save
Hi Johan, I am Sorry. If I have complicated the senerio But, this still not fix my purpose. What I want is - From your example :- /data/disk1/mysql/db1 (directory) /db2 (directory) /db3 (directory) /db4 (symlink to /data/disk2/mysql/db4)

Re: question regarding mysql database location

2009-11-25 Thread Johan De Meersman
You don't need to move any databases. Look at this structure: /data/disk1/mysql/db1 (directory) /db2 (directory) /db3 (directory) /db4 (symlink to /data/disk2/mysql/db4) /db5 (symlink to /data/disk2/mysql/db5) /db

Re: question regarding mysql database location

2009-11-25 Thread Manasi Save
Well Waynn, In this case I need to move all the existing databases to new location right. Which I don't want to do. Is it possible that I create sym link between two and use both. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save < >

Re: question regarding mysql database location

2009-11-25 Thread Waynn Lue
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Thanks Waynn, > > I could not get your point of using symlinks. Because as per my knowledge > symlink will store same data which is there in original directory. > and What do you mean by "The limit for fil

Re: question regarding mysql database location

2009-11-25 Thread Manasi Save
Thanks Waynn, I could not get your point of using symlinks. Because as per my knowledge symlink will store same data which is there in original directory. and What do you mean by "The limit for files is significantly higher than > directories." Can you elaborate it more. Thanks in advance. Rega

Re: question regarding mysql database location

2009-11-25 Thread Waynn Lue
I fixed this by using symlinks for the directories for the underlying databases. The limit for files is significantly higher than directories. Waynn On 11/24/09, Manasi Save wrote: > Hi All, > > I have asked this question before But, I think I am not able to describe > it better. > > Sorry for a

Re: question regarding mysql database location

2009-11-24 Thread Manasi Save
Also I forgot to mention that I have gone through the innodb option of innodb_data_file_path but I can just specify it as : innodb_data_file_path=ibdata1:2048M:autoextend:max:1024M;ibdata1:2048M:autoextend:max:1024M; But not as : innodb_data_file_path=/var/lib/mysql/data/ibdata1:2048M:autoextend

RE: Question about MySQL

2009-08-11 Thread Gavin Towey
ing-primer Regards, Gavin Towey -Original Message- From: Banyan He [mailto:ban...@rootong.com] Sent: Friday, August 07, 2009 11:12 AM To: Gavin Towey; joerg.bru...@sun.com; Peter Chacko Cc: mysql Subject: Re: Question about MySQL Hi Gavin, I am interested in the things you made for the optimiz

Re: Question about MySQL

2009-08-10 Thread Joerg Bruehe
Hi all! First of all, please excuse the typo I made in my posting. I had written >> There may be some merit to this in a specialized setup (NAS systems - >> I'm not convinced of them, but don't claim expert knowledge about them), and of course meant SAN, not NAS systems. As regards NFS: Peter

Re: Question about MySQL

2009-08-07 Thread Peter Chacko
umptions! > > Regards, > Gavin Towey > > -Original Message- > From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] > Sent: Friday, August 07, 2009 1:19 AM > To: Peter Chacko > Cc: mysql > Subject: Re: Question about MySQL > > Hi Peter, all, &

Re: Question about MySQL

2009-08-07 Thread Banyan He
http://www.rootong.com > From: Gavin Towey > Date: Fri, 7 Aug 2009 11:07:19 -0700 > To: "joerg.bru...@sun.com" , Peter Chacko > > Cc: mysql > Subject: RE: Question about MySQL > > I always accepted that NFS was unacceptably slow for database access, until I >

RE: Question about MySQL

2009-08-07 Thread Gavin Towey
using GigE over few hops, then it's really not slower than local disks. Remember: benchmark and test your assumptions! Regards, Gavin Towey -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: Friday, August 07, 2009 1:19 AM To: Peter Chacko Cc: mysql Subjec

Re: Question about MySQL

2009-08-07 Thread Peter Chacko
Hi Jorg, I really appreciate your help sharing your experience/thoughts. Yes, i fully concur with you, NFS is not designed for Databases. But you know there are Distributed SAN file systems (that use Direct IO to the SAN) are serving databases like DB2 in many installations for shared storage.

Re: Question about MySQL

2009-08-07 Thread Joerg Bruehe
Hi Peter, all, let me just concentrate on the NFS aspect: Peter Chacko wrote: > [[...]] > > Another question is , whats the general experience of running MySQL > servers on NFS shares ? I would *never* use NFS storage for any DBMS (except for some testing): NFS access is slower than local di

[solved]Re: Question about query - can this be done?

2009-06-02 Thread Ray
s, > Nathan Sullivan Thanks Nathan, I think that completes the picture. Just what I was looking for. Ray > > -Original Message- > From: Ray [mailto:r...@stilltech.net] > Sent: Tuesday, June 02, 2009 4:58 PM > To: mysql@lists.mysql.com > Subject: Re: Question about query -

RE: Question about query - can this be done?

2009-06-02 Thread Nathan Sullivan
4:58 PM To: mysql@lists.mysql.com Subject: Re: Question about query - can this be done? On June 2, 2009 03:14:36 pm Ray wrote: > On June 2, 2009 10:44:48 am Peter Brawley wrote: > > Ray, > > > > >I want a query that will provide one record per event with all times >

Re: Question about query - can this be done?

2009-06-02 Thread Ray
On June 2, 2009 03:14:36 pm Ray wrote: > On June 2, 2009 10:44:48 am Peter Brawley wrote: > > Ray, > > > > >I want a query that will provide one record per event with all times > > > included. feel free to answer RTFM or STFW as long as you provide the > > > manual section or key words. ;) > > >

Re: Question about query - can this be done?

2009-06-02 Thread Ray
On June 2, 2009 10:44:48 am Peter Brawley wrote: > Ray, > > >I want a query that will provide one record per event with all times > > included. feel free to answer RTFM or STFW as long as you provide the > > manual section or key words. ;) > > Can be done with a pivot table. Examples under "Pivot

Re: Question about query - can this be done?

2009-06-02 Thread Peter Brawley
Ray, I want a query that will provide one record per event with all times included. feel free to answer RTFM or STFW as long as you provide the manual section or key words. ;) Can be done with a pivot table. Examples under "Pivot tables" at http://www.artfulsoftware.com/infotree/queries.p

Re: Question about query - can this be done?

2009-06-02 Thread Brent Baisley
On Tue, Jun 2, 2009 at 11:52 AM, Ray wrote: > Hello, > > I've tried the manual and google, but I am not even sure what to call what I > want to do. > > simplified data example: > I have a table of start and end times for an event, and an id for that event > in a table. each event may occur multipl

RE: Question about Maria readers/writers

2009-05-22 Thread Martin Gainty
only if you are implementing INNODB Transactional Storage Engine MySQL uses table-level locking for MyISAM, MEMORY and MERGE tables, page-level locking for BDB tables, and row-level locking for InnoDB tables. http://dev.mysql.com/doc/refman/5.0/en/internal-locking.h

Re: Question regards mysqldump and replication

2009-05-03 Thread Shawn Green
Dominik Klein wrote: Hi. I have a question regarding mysql replication and mysqldump. I have a master (A). All my clients insert/update/delete only to this master. Then I have a Slave (B). This slave only replicates the master. There are no other processes changing/inserting data into the Slave

Re: Question on replication terminology

2009-04-29 Thread Curtis Maurand
I think what's really being sought after, here is clustering. --C Eric Bergen wrote: Dual master replication can be either dual master dual write or dual master single writer. The latter is preferred. In this configuration replication is connected in both directions but clients only ever conne

Re: Question on replication terminology

2009-04-29 Thread Eric Bergen
Dual master replication can be either dual master dual write or dual master single writer. The latter is preferred. In this configuration replication is connected in both directions but clients only ever connect to one master at a time. It's just as safe as master -> slave replication if you handle

Re: Question on replication terminology

2009-04-28 Thread Claudio Nanni
Hi there, I would only like to stress that the only supported (and recommended) replication solution in MySQL is Master--->Slave replication. In this scenario you can have ONLY one master and (virtually) any number of slaves. There is NO other safe replication solution. The terms you mention

re: Question!

2009-04-02 Thread Michael Widenius
Hi! > "Jarikre" == Jarikre Efemena writes: Jarikre> Dear sir, Jarikre>   Jarikre> I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites. Jarikre>   Jarikre> Please, how do I import, upload/export Mysql database to a w

Re: Question!

2009-04-01 Thread Jujitsu Lizard
On Tue, Mar 31, 2009 at 1:30 AM, Jarikre Efemena wrote: > Dear sir, > > I am young web developer using PHP Script in designing interactive website. > I desire to include Mysql database on my websites. > > Please, how do I import, upload/export Mysql database to a website server > after creating a

RE: Question!

2009-03-30 Thread Joshua Gordon
Read the online Manual. -Original Message- From: Jarikre Efemena [mailto:jefem...@yahoo.com] Sent: Monday, March 30, 2009 11:30 PM To: mysql@lists.mysql.com Subject: Question! Dear sir,   I am young web developer using PHP Script in designing interactive website. I desire to include Mys

Re: Question about triggers

2009-02-02 Thread Baron Schwartz
Send the value of @@server_id in the message, and make sure each server has a unique value for that. Compare the value in the received message to the value in the server and see whether you should stop the loop. On Mon, Feb 2, 2009 at 4:38 AM, Tobias Stocker wrote: > Hy there, > > I'm planing to

Re: question about natural join

2009-01-21 Thread doug
Thank you. On Wed, 21 Jan 2009, c...@l-i-e.com wrote: The natural join will JOIN on *all* the fields whose names match, not just the ones you want it to. In particular, the JOIN is matching up .expires and .expires with "=" You then use WHERE to get only the ones with ">" This is a tautolo

Re: question about natural join

2009-01-21 Thread ceo
The natural join will JOIN on *all* the fields whose names match, not just the ones you want it to. In particular, the JOIN is matching up .expires and .expires with "=" You then use WHERE to get only the ones with ">" This is a tautology: There are NO records both "=" and ">" on the fie

Re: Question about Master-Master replication: Is this possible?

2009-01-13 Thread Frank Becker
Hello Baron, thanks for your response. > These types of questions can always be answered by asking: "does my > proposed setup require any server to have more than one master?" If > so, it's currently not possible. What I want to do is the following: eGroupware is a enterprise-groupware solution.

RE: Question about Master-Master replication: Is this possible?

2009-01-13 Thread Rolando Edwards
In the topology you just illustrated, you need to be specific about your scheme using arrows. Here are some examples: == Example 1: This is MultiMaster Replication among 4 servers Master1--->Master2 ^ | |

Re: Question about Master-Master replication: Is this possible?

2009-01-13 Thread Baron Schwartz
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker wrote: > Hello together, > > I have successfully set up a master-master-replication between two > servers. My question is: It is possible to set up such a replication > between three (or more) servers? Like this > > > Master3 --- Master1 --- Master2 >

Re: Question on default database for stored functions

2008-12-26 Thread Peter Brawley
select get_area(11); ERROR 1305 (42000): FUNCTION test2.get_area does not exist Can someone tell me what I'm doing wrong? Thanks. SELECT dbWhereFunctionWasCreated.get_area(11); PB - Jerry Schwartz wrote: -Original Message- From: blue.trapez...@gmail.com [mailto:blue.trapez...@

RE: Question on default database for stored functions

2008-12-26 Thread Jerry Schwartz
>-Original Message- >From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On >Behalf Of Vikram Vaswani >Sent: Thursday, December 25, 2008 5:47 AM >To: mysql@lists.mysql.com >Subject: Question on default database for stored functions > >Hi > >According to the MySQL manual, "By

RE: Question about Averaging IF() function results

2008-11-04 Thread Eric Lommatsch
-8939 Fax 303-778-0378 [EMAIL PROTECTED] From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 1:14 PM To: Eric Lommatsch Cc: mysql@lists.mysql.com Subject: Re: Question about Averaging IF() function results Eric, I'd re

Re: Question about Averaging IF() function results

2008-11-04 Thread Peter Brawley
Eric, I'd replace (avg(IF(avgTest.Q1<7,avgTest.Q1,Null)) +avg(IF(avgTest.Q2<7,avgTest.Q2,Null)) +avg(IF(avgTest.Q3<7,avgTest.Q3,Null)) +avg(IF(avgTest.Q4<7,avgTest.Q4,Null)) +avg(IF(avgTest.Q5<7,avgTest.Q5,Null)))/5 as overallAvg from avgTest group by course; with ... (IF(avgTest.Q

  1   2   3   4   5   6   7   8   >