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 patch

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' > 3, 'Oranges' > > > On 20

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

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> sel

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 | NA

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: table desin question

On 2015/08/12 09:42, Johan De Meersman wrote: - Original Message - >From: "Richard Reina" >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

Re: table desin question

- Original Message - > From: "Richard Reina" > 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?

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 -- use

Re: table design question

ls. > > PB > > Original Message > From: "Richard Reina" > Reply-To: "Richard Reina" > Date: 07/29/15 10:19 AM > To: "mysql@lists.mysql.com" > Cc: > Sub: table design question > If I were to create a database table(s) to tract most

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 or

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 tables

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 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, sysbench shows late

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 thinkin

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 connection

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

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 * f

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)

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 /Users/dkick/bi

Re: Proxy / connected failover question

- Original Message - > From: "Martin Gainty" > 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 th

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

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" escreveu: > > Johan, > > I don't think there's any need for the heavyness (and ugliness ;) ) of > MySQL Proxy. We're usin

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: http://www.olindata.com/blog/2014/04/managing-pe

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

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: 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

Re: replication question replacing the master

2014/1/17 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. I'm thinking it's

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 ol

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

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 (p

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

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? Shou

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. > >

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 some

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 "201

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 t

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 wrote: > 2013/9/17 Wayne Leutwyler > > > Hello List, > > > > I have a customer who is wanting to use the Archive Engine. I have

Re: Archive Engine Question

2013/9/17 Wayne Leutwyler > 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.

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 wrote: > From here: > >

Re: Archive Engine Question

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

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. My

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

RE: Question regarding creating a query

ach 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 creat

RE: hypothetical question about data storage

Rick James 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, otherwise a read is

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&#

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

Re: hypothetical question about data storage

2013/7/30 Rick James > 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. > However, y

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. ...r

RE: hypothetical question about data storage

Monday, July 29, 2013 3:38 PM > To: Rick James; will...@techservsys.com; mysql@lists.mysql.com > Subject: RE: hypothetical question about data storage > > Rick James wrote: > > > >For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is &g

RE: hypothetical question about data storage

Rick James 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 striped (and opt

RE: hypothetical question about data storage

64TB limit per PARTITION. > -Original Message- > From: william drescher [mailto:will...@techservsys.com] > 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: >

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 a

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

Re: hypothetical question about data storage

will have seeks. >> >>No, adding more RAM won't help much. Here's an argument: >>Suppose your data is 20 times as big as the buffer pool and you are >>doing random fetches (MD5, etc). Then 1/20 of fetches are cached; 95% >>cache miss. Estimated time: 0.95

RE: hypothetical question about data storage

1/20 of fetches are cached; 95% >cache miss. Estimated time: 0.95 * 100ms = 95ms. >Now you double your RAM. 1/10 cached -> 90% cache miss -> 90ms average >-> Not much improvement over 95. > >> -Original Message- >> From: ckn...@savage.za.org [mailto:ck

RE: hypothetical question about data storage

ilto: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 &

Re: hypothetical question about data storage

ge - >> From: "Chris Knipe" >> To: mysql@lists.mysql.com >> Sent: Thursday, 25 July, 2013 11:53:53 PM >> Subject: hypothetical question about data storage >> >> Hi all, >> >> We run an VERY io intensive file application service. Curren

Re: hypothetical question about data storage

mysql@lists.mysql.com > Sent: Thursday, 25 July, 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

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" wrote: >Hi all, > >We run an VERY io intensive file appli

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 MD5

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 ar

RE: Replication question

http://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: Repl

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 t

Re: restore question

Hi 2013/7/5 Jim Sheffer > 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 > "du

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 th

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: [>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 star

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 Windo

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

Re: NET START MYSQL QUESTION?

PC> NET START MySQLSystem error 5 has occurred. > Access is denied. > 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 P

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 MYSQL"BUT 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 star

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 ins

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:http://lis

Re: NET START MYSQL QUESTION?

NADARAJAH: > Sorry 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 Q

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 MYSQL"BUT > 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

Re: Chain Replication QUestion

That is correct. On Mon, May 6, 2013 at 11:06 AM, Richard Reina wrote: > To activate log-slave-updates do I just add "log-slave-updates" to the > my.cnf file? > > > > 2013/4/30, Manuel Arostegui : > > 2013/4/30 Richard Reina > > > >> I have a few slaves set up on my local network that get upda

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 : > 2013/4/30 Richard Reina > >> 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

RE: Chain Replication QUestion

rom: Richard Reina [mailto:gatorre...@gmail.com] > 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 l

RE: Chain Replication QUestion

ql.com/why-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 > &

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. Th

RE: Rookie question

age- > From: Gary Smith [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 wh

Re: Chain Replication QUestion

2013/4/30 Richard Reina > 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 documentation fo

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.

April 05, 2013 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

RE: Update and lock question.

al Message- 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

Re: Update and lock question.

vel > locking. > > > -Urvi > > -Original Message- > 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. &

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 field

RE: Blob implementation question

ELECT myblob FROM mytable 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: Blo

Re: Blob implementation question

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

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

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

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

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 wrote: > Hello, > > currently on this version of MySQL a database has been built for me to > use. and following privileges are given: I am not able to c

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 ta

Re: Relay log Question

_ From: Akshay Suryavanshi To: Wayne Leutwyler 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 runs, which executes "

Re: Relay log Question

.@gmail.com> wrote: > 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_purg

  1   2   3   4   5   6   7   8   9   10   >