Re: Question about contributing a patch

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

Question about contributing a patch

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 know the progress about integrating the

A question about Oracle Contributor Agreement

Hi, I signed Oracle Contributor Agreement about a month ago, but have not got a response. I reported a bug, but I can not contribute my patch. So, could anyone please tell me how long will it take before I am informed? Thanks, sincerely

Re: Relational query question

It better to LEFT join rather then NOT IN On Wed, Sep 30, 2015 at 6:00 PM, Mogens Melander wrote: > Maybe not the most optimal, but (probably) the most simple: > > SELECT * FROM fruit > where id not in (select fruit from purchase > where customer=1); > > 1, 'Apples' >

Re: Relational query question

Maybe not the most optimal, but (probably) the most simple: SELECT * FROM fruit where id not in (select fruit from purchase where customer=1); 1, 'Apples' 3, 'Oranges' On 2015-09-30 00:01, Richard Reina wrote: If I have three simple tables: mysql> select * from customer; +++ | ID

Relational query question

If I have three simple tables: mysql> select * from customer; +++ | ID | NAME | +++ | 1 | Joey | | 2 | Mike | | 3 | Kellie | +++ 3 rows in set (0.00 sec) mysql> select * from fruit; ++-+ | ID | NAME| ++-+ | 1 | Apples | |

Re: Relational query question

On 9/29/2015 1:27 PM, Ron Piggott wrote: On 29/09/15 13:01, Richard Reina wrote: If I have three simple tables: mysql> select * from customer; +++ | ID | NAME | +++ | 1 | Joey | | 2 | Mike | | 3 | Kellie | +++ 3 rows in set (0.00 sec) mysql>

Re: Relational query question

On 29/09/15 13:01, Richard Reina wrote: If I have three simple tables: mysql> select * from customer; +++ | ID | NAME | +++ | 1 | Joey | | 2 | Mike | | 3 | Kellie | +++ 3 rows in set (0.00 sec) mysql> select * from fruit; ++-+ | ID |

Re: table desin question

- Original Message - From: Richard Reina gatorre...@gmail.com Subject: table desin question Would this be the best way to design the schema and would it be best to make the client ID and technician ID the same as the user ID as they relate to the same person? Close enough; but I

table desin question

I am ceating a database application with two different types of users, clients and technicians. Both types of users have to create and account in which they become users. From there they can become clients or technicians or perhaps even both. Since each type describe different attributes -- user

Re: table desin question

On 2015/08/12 09:42, Johan De Meersman wrote: - Original Message - From: Richard Reinagatorre...@gmail.com Subject: table desin question Would this be the best way to design the schema and would it be best to make the client ID and technician ID the same as the user ID as they relate

Re: table design question

Message From: Richard Reina gatorre...@gmail.com Reply-To: Richard Reina gatorre...@gmail.com Date: 07/29/15 10:19 AM To: mysql@lists.mysql.com mysql@lists.mysql.com Cc: Sub: table design question If I were to create a database table(s) to tract most common repairs to different appliances I

Re: table design question

Hi Richard, On 7/29/2015 10:19 AM, Richard Reina wrote: If I were to create a database table(s) to tract most common repairs to different appliances I can't decide if it would be better to create one table with a long ENUM column that contains repairs that could be attributed to any appliance

table design question

If I were to create a database table(s) to tract most common repairs to different appliances I can't decide if it would be better to create one table with a long ENUM column that contains repairs that could be attributed to any appliance or different repair tables for each appliance. All the

Re: Where to ask a question about installation and configuration

Hello Steve, To what list should I post with a post-installation config and startup question? This list, the MySQL General Mailing List, is the right place if the question is about MySQL! Cheers -- Claudio

Where to ask a question about installation and configuration

To what list should I post with a post-installation config and startup question? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Latency question - #of connections

Learner Study learner.st...@gmail.com writes: Setup: MySQL 5.6.16 + thread pool extensions running on 3.18 kernel Two sysbench clients running from different PCs with total of 14k connections, each connection doing 2 select queries per sec. When I specify 7k connections from each client,

Re: Latency question - #of connections

I'd be doing it and would provide update. BTW, since the query/sec rate is too low, I doubt if it would show anything. but would try and update. Both clients aggregate at a switch and come into my server as a single 10G. So it shouldn't matter from poll() system call perspective. I'm also

Latency question - #of connections

Hello MySQL experts, I am new to MySQL and am seeing following behavior Setup: MySQL 5.6.16 + thread pool extensions running on 3.18 kernel Two sysbench clients running from different PCs with total of 14k connections, each connection doing 2 select queries per sec. When I specify 7k

question?

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 * from foo where a=:a $s=$pdo-prepare($sql)

Re: question?

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 *

Re: question?

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, where

Question about my build of MySQL 5.6.10

I build from source but find that libmysqlclient_r is merely a symlink to libmysqlclient. Is that expected? $ uname -a Darwin Damien-Kicks-MacBook-Pro.local 12.5.0 Darwin Kernel Version 12.5.0: Sun Sep 29 13:33:47 PDT 2013; root:xnu-2050.48.12~1/RELEASE_X86_64 x86_64 $ echo $CXX

Proxy / connected failover question

Hullo peoples, I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck with one shitty application that utterly breaks whenever the database goes away unexpectedly. I can't change the application itself, so I find myself looking for options that allow the heathen contraption to

Re: Proxy / connected failover question

Hi Johan, I wanted to love mysql-proxy for so many years, so I understand you :) I have two main questions: * am I remembering right that MySQL Proxy provides transparent failover ? You need to use/create a lua failover script, I've never seen or tried one. What kept me from investing too

Re: Proxy / connected failover question

Johan, I don't think there's any need for the heavyness (and ugliness ;) ) of MySQL Proxy. We're using haproxy for a similar setup (just with galera behind it, but that shouldn't really matter. Have a look at this blog post that explains most of it:

Re: Proxy / connected failover question

I like HAProxy as well as it simplifies many of the things you seem to be looking for. -- Wagner Bianchi Mobile: +55.31.8654.9510 Em 09/07/2014, às 07:48, Heck, Walter walterh...@olindata.com escreveu: Johan, I don't think there's any need for the heavyness (and ugliness ;) ) of MySQL

RE: Proxy / connected failover question

CC: vegiv...@tuxera.be; mysql@lists.mysql.com From: wagnerbianch...@gmail.com Subject: Re: Proxy / connected failover question Date: Wed, 9 Jul 2014 08:31:05 -0300 To: walterh...@olindata.com I like HAProxy as well as it simplifies many of the things you seem to be looking

Re: Proxy / connected failover question

- Original Message - From: Martin Gainty mgai...@hotmail.com Subject: Proxy / connected failover question I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck with one shitty application that utterly breaks whenever the database goes away unexpectedly. I

Re: replication question replacing the master

2014/1/17 Richard Reina gatorre...@gmail.com I have 3 relay MySQL database servers on my small office LAN backing up a master and 3 more machines backing up each relay (1 each). They are all replicating all databases and all tables. The master although running fine is almost eight years old.

Re: replication question replacing the master

Manuel, Thank you very much for this information. This sounds like a very good strategy. I think I will try switching some slaves from one relay to another to familiarize myself and get practice and them do it to deploy a new master. Again, thank you very much. Richard El Jan 18, 2014, a

replication question replacing the master

I have 3 relay MySQL database servers on my small office LAN backing up a master and 3 more machines backing up each relay (1 each). They are all replicating all databases and all tables. The master although running fine is almost eight years old. I'm thinking it's probably time to make one of the

Re: replication question replacing the master

Am 17.01.2014 22:42, schrieb Richard Reina: I have 3 relay MySQL database servers on my small office LAN backing up a master and 3 more machines backing up each relay (1 each). They are all replicating all databases and all tables. The master although running fine is almost eight years old.

fulltext question

Hello all- I have a question on searching via fulltext. I have the following SQL statement: var('SQLResultsID') = 'select *, MATCH (product_id,product_name,product_desc) AGAINST(' + $sqlKeywordSearch + ') AS SCORE from products WHERE MATCH (product_id,product_name,product_desc

Re: Another query question...

2013/11/08 17:35 -0800, Jan Steinman Okay, I think I found it: http://bugs.mysql.com/bug.php?id=47713 I added a comment with a link to a page I set up to show the behaviour on my system. http://www.ecoreality.org/wiki/WITH_ROLLUP_problem It was submitted in 2009, severity

Re: Another query question...

From: h...@tbbs.net 2013/11/04 09:32 -0800, Jan Steinman I noticed that I have similar queries that work as expected. The difference appears to be that every query that is broken uses WITH ROLLUP, and removing this makes them behave as expected. Is this a known bug? Should I submit it

Re: Another query question...

The plot thickens... I noticed that I have similar queries that work as expected. The difference appears to be that every query that is broken uses WITH ROLLUP, and removing this makes them behave as expected. Is this a known bug? Should I submit it as such? If someone would be so kind as to

Another query question...

MySQL 5.0.92-log I'm trying to form a clickable link using CONCAT, but the link as displayed points to the NEXT row's URL, not the one from the same row as the other data displayed! Is there something I don't understand about this? Below is the query. {{{1}}} is replaced by a year, like 2013.

Re: Another query question...

2013/11/04 09:32 -0800, Jan Steinman I noticed that I have similar queries that work as expected. The difference appears to be that every query that is broken uses WITH ROLLUP, and removing this makes them behave as expected. Is this a known bug? Should I submit it as such? If someone would

Re: Another query question...

Am 04.11.2013 22:55, schrieb h...@tbbs.net: 2013/11/04 09:32 -0800, Jan Steinman I noticed that I have similar queries that work as expected. The difference appears to be that every query that is broken uses WITH ROLLUP, and removing this makes them behave as expected. Is this a known

Re: Archive Engine Question

If you are looking for great compression another option is TokuDB. It supports quicklz, zlib, and lzma compression. On Wed, Sep 18, 2013 at 2:30 AM, Manuel Arostegui man...@tuenti.com wrote: 2013/9/17 Wayne Leutwyler wleut...@columbus.rr.com Hello List, I have a customer who is wanting

Re: Archive Engine Question

2013/9/17 Wayne Leutwyler wleut...@columbus.rr.com Hello List, I have a customer who is wanting to use the Archive Engine. I have no experience with this engine, other than what I am been reading. Why would I want to use Archive over InnoDB. They are only going to be placing audit

Archive Engine Question

Hello List, I have a customer who is wanting to use the Archive Engine. I have no experience with this engine, other than what I am been reading. Why would I want to use Archive over InnoDB. They are only going to be placing audit information in the table. Walter Wayne Leutwyler, RHCT Sr.

Re: Archive Engine Question

From here: http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html The ARCHIVE engine supports INSERThttp://dev.mysql.com/doc/refman/5.0/en/insert.html and SELECT http://dev.mysql.com/doc/refman/5.0/en/select.html, but not DELETE http://dev.mysql.com/doc/refman/5.0/en/delete.html,

Re: Archive Engine Question

Yea, the more I think about it the more it makes good sense. Are there any special my.cnf setting we should be looking at. We currently have our systems tuned for InnoDB as our primary engine. Thanks for the feedback Keith. On Sep 17, 2013, at 11:34 AM, Keith Murphy bmur...@paragon-cs.com

Re: hypothetical question about data storage

On 30-07-2013 01:16, Rick James wrote: Elevator... If the RAID _controller_ does the Elevator stuff, any OS optimizations are wasted. And there have been benchmarks backing that up. (Sorry, don't have any links handy.) RAID 5/10 ... The testing I have done shows very little difference.

Re: hypothetical question about data storage

2013/7/30 Rick James rja...@yahoo-inc.com Elevator... If the RAID _controller_ does the Elevator stuff, any OS optimizations are wasted. And there have been benchmarks backing that up. (Sorry, don't have any links handy.) RAID 5/10 ... The testing I have done shows very little

Question about Server Debug Info

information to the mysqld.log file. I am wondering what other methods would write the debug info to the mysqld.log file. On the two servers in question my fellow DBA's nor myself did nothing that would have written debug info. Are there any internal settings or processes that would write

Question regarding creating a query

Hello, I have a question regarding creating a query as follows: 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

RE: hypothetical question about data storage

Rick James rja...@yahoo-inc.com wrote: When writing a random block, RAID-5 does not need to touch all the drives, only the one with parity. Suitable XORs will update it correctly. So, a write hits 2 drives, whether you have RAID-5 or -10. Only if the other blocks happen to be in the cache,

RE: Question regarding creating a query

you suggested. -Original Message- From: Sukhjinder K. Narula [mailto:narula...@gmail.com] Sent: Tuesday, July 30, 2013 11:13 AM To: mysql@lists.mysql.com Subject: Question regarding creating a query Hello, I have a question regarding creating a query as follows: I have several

Re: Question regarding creating a query

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 do is

RE: hypothetical question about data storage

] Sent: Saturday, July 27, 2013 4:32 AM To: mysql@lists.mysql.com Subject: Re: hypothetical question about data storage On 7/26/2013 6:58 PM, Chris Knipe wrote: The issue that we have identified is caused by seek time - hundreds of clients simultaneously searching for a single file

RE: hypothetical question about data storage

Rick James rja...@yahoo-inc.com wrote: For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is optimal. (The default, 'cfq', is not as good.) I should look into those again at some point. Do you have a brief word as to why they're better? A RAID controller with multiple drives

RE: hypothetical question about data storage

James; will...@techservsys.com; mysql@lists.mysql.com Subject: RE: hypothetical question about data storage Rick James rja...@yahoo-inc.com wrote: For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is optimal. (The default, 'cfq', is not as good.) I should look into those

Re: hypothetical question about data storage

On 7/26/2013 6:58 PM, Chris Knipe wrote: The issue that we have identified is caused by seek time - hundreds of clients simultaneously searching for a single file. The only real way to explain this is to run 100 concurrent instances of bonnie++ doing random read/writes... Your disk utilization

Re: hypothetical question about data storage

, 2013 11:53:53 PM Subject: hypothetical question about data storage Hi all, We run an VERY io intensive file application service. Currently, our problem is that our disk spindles are being completely killed due to insufficient SEEK time on the hard drives (NOT physical read/write speeds

Re: hypothetical question about data storage

question about data storage Hi all, We run an VERY io intensive file application service. Currently, our problem is that our disk spindles are being completely killed due to insufficient SEEK time on the hard drives (NOT physical read/write speeds). We have an directory structure where

RE: hypothetical question about data storage

26, 2013 12:30 AM To: Johan De Meersman Cc: mysql Subject: Re: hypothetical question about data storage Hi All, Thanks for the responces, and I do concur. I was taking a stab in the dark so to speak. We are working with our hosting providers currently and will be introducing

RE: hypothetical question about data storage

- From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of Chris Knipe Sent: Friday, July 26, 2013 12:30 AM To: Johan De Meersman Cc: mysql Subject: Re: hypothetical question about data storage Hi All, Thanks for the responces, and I do concur. I was taking a stab

Re: hypothetical question about data storage

- From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of Chris Knipe Sent: Friday, July 26, 2013 12:30 AM To: Johan De Meersman Cc: mysql Subject: Re: hypothetical question about data storage Hi All, Thanks for the responces, and I do concur. I was taking a stab in the dark

Re: hypothetical question about data storage

2013/07/27 00:58 +0200, Chris Knipe I would definately consider the md5 checksum as a PK (char(32) due to the hex nature), Well, not that it greatly matters, but you could convert it to BINARY(16). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Replication question

On 24/07/2013 19:52, Rick James wrote: 4) 3 tables from the slaves are to be replicated back to the master NO. However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow multiple writable masters. But they won't let you be so selective about tables not being replicated. Here

hypothetical question about data storage

Hi all, We run an VERY io intensive file application service. Currently, our problem is that our disk spindles are being completely killed due to insufficient SEEK time on the hard drives (NOT physical read/write speeds). We have an directory structure where the files are stored based on the

Re: hypothetical question about data storage

Hi, Sorry but mysql is not the address of it , use riak instead of mysql With riak which is key and value based , all keys are on memory and just only one seek enough to handle it Consider to use riak VM On 7/26/13 12:53 AM, Chris Knipe sav...@savage.za.org wrote: Hi all, We run an VERY io

Replication question

I have been asked to set up multiple database replication which I have done before for simple cases however there are some nuances with this instance that add some complexity and I'd like to hear your collective expertise on this proposed scenario:- 1) Single master database 2) n (probably 3

RE: Replication question

://mysql.rjweb.org/doc.php/galera If you can live with them (plus replicating everything), it may be best for you. -Original Message- From: rich gray [mailto:r...@richgray.com] Sent: Wednesday, July 24, 2013 8:21 AM To: mysql@lists.mysql.com Subject: Replication question I have been

restore question

Hi everyone- This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat. I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order that somehow duplicated the items. I need to see if

Re: restore question

Hello Jim, On 7/5/2013 3:11 PM, Jim Sheffer wrote: Hi everyone- This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat. I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order

Re: restore question

Hi 2013/7/5 Jim Sheffer j...@higherpowered.com Hi everyone- This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat. I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order

Re: NET START MYSQL QUESTION?

Hello Reindl, On 5/11/2013 11:52 AM, Reindl Harald wrote: ... virtually nonofy is using mysql on windows seriously as i have not touched windows since 2006 at all Your experience is not indicative of the population as a whole. Many important and mission-critical installations exist on

RE: [Suspected Spam][Characteristics] Re: NET START MYSQL QUESTION?

why not answer the question another user made hours ago? under which account do you try to start mysqld? Agreed. Chances are good that if he goes into the Windows Services control panel and gets the properties of the mysql service, he will find that it is configured to start under a Windows

Re: NET START MYSQL QUESTION?

Am 11.05.2013 16:50, schrieb SIVASUTHAN NADARAJAH: I want to start the mysql from command prompt using NET START MYSQLBUT the server not started. It display an error message. C:\Users\PC NET START MySQLSystem error 5 has occurred. Access is denied. could you please help me, how to

Re: NET START MYSQL QUESTION?

I could not understand your answer. please give me the step by step guidance. thank you so much... Date: Sat, 11 May 2013 16:58:16 +0200 From: h.rei...@thelounge.net To: mysql@lists.mysql.com Subject: Re: NET START MYSQL QUESTION? Am 11.05.2013 16:50, schrieb SIVASUTHAN NADARAJAH

Re: NET START MYSQL QUESTION?

On 11.05.2013 17:50, SIVASUTHAN NADARAJAH wrote: C:\Users\PC NET START MySQL System error 5 has occurred. Access is denied. Run command window from elevated permission. -- Mimiko desu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: NET START MYSQL QUESTION?

Am 11.05.2013 20:04, schrieb Mimiko: On 11.05.2013 17:50, SIVASUTHAN NADARAJAH wrote: C:\Users\PC NET START MySQL System error 5 has occurred. Access is denied. Run command window from elevated permission wow - you mean he *really* tried to start a service as restricted user and instead

Re: NET START MYSQL QUESTION?

2013/05/11 20:50 +0600, SIVASUTHAN NADARAJAH I want to start the mysql from command prompt using NET START MYSQLBUT the server not started. It display an error message. C:\Users\PC NET START MySQLSystem error 5 has occurred. Access is denied. could you please help me, how to start the

Re: NET START MYSQL QUESTION?

. could you please help me, how to start the Mysql service FROM command prompt? why not answer the question another user made hours ago? under which account do you try to start mysqld? hence you need FULL ADMIN PRIVILEGES on every OS to start services or use the system settings which at least

Re: NET START MYSQL QUESTION?

2013/05/11 22:58 +0200, Reindl Harald why not answer the question another user made hours ago? under which account do you try to start mysqld? Well, I learnt something here. When I had the problem of (under Vista) starting mysqld, from command prompt I always did this, start mysqld -b

Re: Chain Replication QUestion

To activate log-slave-updates do I just add log-slave-updates to the my.cnf file? 2013/4/30, Manuel Arostegui man...@tuenti.com: 2013/4/30 Richard Reina gatorre...@gmail.com I have a few slaves set up on my local network that get updates from my main mysql database master. I was hoping to

Re: Chain Replication QUestion

That is correct. On Mon, May 6, 2013 at 11:06 AM, Richard Reina gatorre...@gmail.com wrote: To activate log-slave-updates do I just add log-slave-updates to the my.cnf file? 2013/4/30, Manuel Arostegui man...@tuenti.com: 2013/4/30 Richard Reina gatorre...@gmail.com I have a few

Re: Chain Replication QUestion

Hello Manuel, Thank you for your reply. Could I do the following?: 1) Enable log-bin on master2 (slave that will be converted to a master) 2) Enable log-slave-updates on master2 3) Execute CHANGE MASTER to on another existing slave so that it gets it's updates from master2 instead of master1.

RE: Chain Replication QUestion

-mysql/white-papers/mysql-replication-tutorial/ Andrew. -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: 01 May 2013 16:29 To: Richard Reina; Manuel Arostegui Cc: mysql@lists.mysql.com Subject: RE: Chain Replication QUestion 1) Enable log-bin on master2 (slave

RE: Chain Replication QUestion

] Sent: Wednesday, May 01, 2013 6:00 AM To: Manuel Arostegui Cc: mysql@lists.mysql.com Subject: Re: Chain Replication QUestion Hello Manuel, Thank you for your reply. Could I do the following?: 1) Enable log-bin on master2 (slave that will be converted to a master) 2) Enable log-slave

Re: Chain Replication QUestion

2013/4/30 Richard Reina gatorre...@gmail.com I have a few slaves set up on my local network that get updates from my main mysql database master. I was hoping to turn one into a master while keeping it a slave so that I can set up a chain. Does anyone know where I can find a how to or other

RE: Rookie question

[mailto:li...@l33t-d00d.co.uk] Sent: Monday, April 29, 2013 10:43 AM To: mysql@lists.mysql.com Subject: Re: Rookie question On 29/04/2013 18:29, Patrice Olivier-Wilson wrote: Hi all: I have a membership directory where folks can belong to more than one category. But all folks do not qualify

Re: Rookie question

On 29/04/2013 18:29, Patrice Olivier-Wilson wrote: Hi all: I have a membership directory where folks can belong to more than one category. But all folks do not qualify for a category. So I want to list folks who have qualified in a category but not have them repeat. So if member 1 is in cat 3

RE: Update and lock question.

2:56 PM To: Urvashi Pathak Cc: mysql Subject: Re: Update and lock question. Thanks Urvashi. Based on your answer, instead of the data I looked into the index, and it appears that it was an index issue... I think I have nailed the wait lock contdition due a updating indexes unnecesarely

RE: Update and lock question.

: Andrés Tello [mailto:mr.crip...@gmail.com] Sent: Thursday, April 04, 2013 9:08 AM To: mysql Subject: Update and lock question. I'm doing some tests, but have a questions about locking. In a innodb table, if you issue an select for update lock for a row, supposedly, it only locks that row

Update and lock question.

I'm doing some tests, but have a questions about locking. In a innodb table, if you issue an select for update lock for a row, supposedly, it only locks that row, but if you don't issue a select for update, and trow the update... does it locks the hole table? The update goes over an indexed

Re: Update and lock question.

- From: Andrés Tello [mailto:mr.crip...@gmail.com] Sent: Thursday, April 04, 2013 9:08 AM To: mysql Subject: Update and lock question. I'm doing some tests, but have a questions about locking. In a innodb table, if you issue an select for update lock for a row, supposedly, it only locks

Re: Blob implementation question

; -Original Message- From: Adam Ilardi [mailto:mastaskill...@gmail.com] Sent: Wednesday, March 13, 2013 9:16 AM To: mysql Subject: Blob implementation question Hello All, I'm trying to grok the blob implementation. This scenario is contrived to understand blobs please don't suggest I

RE: Blob implementation question

WHERE id=123; This probably will (if foo is not indexed): SELECT myblob FROM mytable ORDER BY foo; -Original Message- From: Adam Ilardi [mailto:mastaskill...@gmail.com] Sent: Wednesday, March 13, 2013 9:16 AM To: mysql Subject: Blob implementation question Hello All, I'm trying

Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question

you need CREATE Privileges. http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-privileges On Wed, Feb 27, 2013 at 10:42 PM, Rajeev Prasad rp.ne...@yahoo.com wrote: Hello, currently on this version of MySQL a database has been built for me to use. and following privileges are given: I

Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question

oh, osrry i was focused on the at % means I can do the operations from other hosts too? Am 27.02.2013 19:00, schrieb Stillman: OP's first question: I am not able to create a table on my own. what privileges I need to create and modify tables in this database? The answer to that question

Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question

says who? you MAY need CREATE privileges but it not uncommon have a defined scheme and not allow the user to create or drop tables, the user below is able to do anything for a common web-app to anser the OP's question % in mysql is the same as * for the bash so yes, % means any host Am

RE: mysql Ver 14.12 Distrib 5.0.27 user privileges question

OP's first question: I am not able to create a table on my own. what privileges I need to create and modify tables in this database? The answer to that question is that he/she needs CREATE to create tables and ALTER to alter them. -Original Message- From: Reindl Harald [mailto:h.rei

RE: Question about Innodb

don't know the exact fields in ibdata1.) -Original Message- From: Wayne Leutwyler [mailto:wleut...@columbus.rr.com] Sent: Monday, February 04, 2013 11:47 AM To: mysql@lists.mysql.com Subject: Question about Innodb Question about InnoDB tables and tablespaces. I have one file per

Re: Relay log Question

: Akshay Suryavanshi akshay.suryavansh...@gmail.com To: Wayne Leutwyler wleut...@columbus.rr.com Cc: mysql@lists.mysql.com Sent: Wednesday, January 9, 2013 1:42 AM Subject: Re: Relay log Question Also, you may want to see, if at all new file is really getting every hour exactly, if any cron'd script

Re: Relay log Question

Hi, Please re-phrase your question. The relay logs are created as and when required by the Slave_SQL thread. Once all the events in the relay logs are executed the relay log would be purged by the Slave_SQL thread. By setting relay_log_purge=0 you are disabling this automatic purge option. So

  1   2   3   4   5   6   7   8   9   10   >