RE: io thread very slow copying binlogs

have entered swap space: everythingthing is working fine, just in incredibly slow motion. What does vmstat report? Try someithng like $ vmstat 2 60 and see if any swap traffic can be observed? How about cat /proc//status ? What does VmSwap suggest? - michael dykman -Original Message

Re: Query Summary Help...

I'm not at a terminal but have you tried grouping by p.pk_ProductID instead of i.fk...? It is the actual value you are selecting as well as being on the primary table in the query. On Thu, Oct 22, 2015, 5:18 PM Don Wieland wrote: > Hi gang, > > I have a query: > > SELECT >

Re: Query Summary Help...

net> wrote: > > > On Oct 22, 2015, at 2:41 PM, Michael Dykman <mdyk...@gmail.com> wrote: > > > > I'm not at a terminal but have you tried grouping by p.pk_ProductID > instead > > of i.fk...? It is the actual value you are selecting as well as being on > >

Re: Very strange issue while trying to login remotely

have done all that I could find from google. I will be really, really grateful for ideas that could help me recover from this mess, that is aching me since last 3 hours :( Thanks and Regards, Ajay -- Regards, Ajay -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: time stamp specific to columns

. Is there a command that says ³update the time stamp if and only if there is a change in columns a, b,c, or d -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May

Re: ssh basics

://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Help with REGEXP

/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: update and control flow

and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: forum vs email [was: Re: table-for-column]

I have been a resident of this list for a very long time. In the early days, this was the only place to get reliable information about what was then a relatively obscure database system. Now, local and online bookstores have shelves full of books, many of them authored by list regulars. We have

Re: MySQL dying?

Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Stored Procedure help

why do you need the 'order by' in your update at all? The statement, if innodb, will certainly be atomic; the order in which they are updated means nothing. On Jul 13, 2014 11:46 PM, kitlenv kitl...@gmail.com wrote: maybe try 'order by sort_id desc'? On Mon, Jul 14, 2014 at 12:42 PM, Don

Re: error 29, file not found (errcode: 13)

/thufir/make_year_model.csv make1,model1,2012,604,buy now make2,model2,2013,780,need to sell make3,model3,2001,780,cheap thufir@dur:~$ thanks, Thufir -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

such queries. It has something to do with a layer below our application. But i am not sure as to where it is. Thanks Jatin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk

Re: multilple mysql engines, one set of shared table spaces?

? Is it reliable or not? Are there authoritative references to support the answers? Inquiring minds want to know Thanks in advance Bruce Ferrell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael

Re: Decode Json in MySQL query

. Many Thanks, Sukhjinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http

Re: Precedence in WHERE clauses.

on query processing, about the order of WHERE clauses ? Regards, Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL

Re: regexp in conditional

'^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; I'm getting an error from that. Is there some way to do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source

Re: How do I mysqldump different database tables to the same .sql file?

to do this with some command line option I'm not seeing in the man page? -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: how to create unique key for long varchar?

The odds against the eventuality you are worried about are astronomically high. Much serious work on the internet would fall apart were that not true. Collision is simply not going to happen within the next several hundred thousand years. On Nov 5, 2013 9:59 PM, Li Li fancye...@gmail.com wrote:

Re: Update Column in table only if variable is Not NULL

Consider: update table1 set field1 = if( :var,:var,field1), ... Can be in a procedure but doesn't have to be. On Oct 28, 2013 5:28 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: Hi Shawn Thanks for your reply. Maybe my example wasn't detailed enough. Basically the snippet of the

Re: restore problem

a suggestion? Thanks in advance, BR -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

. Thanks in Advance, Nick. -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: best way to copy a innodb table

://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: string-likeness

: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL

Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found

archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Bug in BETWEEN same DATETIME

on transaction_date to be used, if one exists. WHERE `transaction_date` BETWEEN '2013-04-16 00:00:00' AND '2013-04-16 23:59:59' Although you probably get the result you want by just incrementing the day on the upper-limit. WHERE `transaction_date` BETWEEN '2013-04-16 AND '2013-04-17' - michael dykman

Re: auto-increment more than one field

-table-with-more-than-one-auto-incremented- coloumn?rq=1 I am using MySqlWorkbench. I can see Triggers section below the table. I don't know how to use the trigger script suggested in the link. Thanks. -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Triggers

possible ways. Thanks, -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Chain Replication QUestion

can also use xtrabackup if you like. Manuel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: MySQL on Mac OS 10.8

For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: replication problem

Trimurthy, you will have to describe the method you are using to setup replication. The error message seems plain but an observer could not reasonably guess what caused it without more information. - michael dykman On Mon, Dec 3, 2012 at 7:24 AM, Trimurthy trimur...@tulassi.com wrote: hi

Re: Failed to setup SSL

I had noticed that the paths to your certificates were expressed as relative paths. I think at least part of Reindl's recommendation was to express fully qualified paths to your certs and to examined the permissions on those files carefully. SSL is very particular about rejecting security files

Fwd: Basic SELECT help

As INTERSECT is not avilable under mysql, we will have to go the JOIN route select distinct a.id from mytable a inner join mytable b on (a.id=b.id) where a.type= 2 and b.type = 5; - michael dykman On Thu, Nov 22, 2012 at 9:30 AM, Neil Tompkins neil.tompk...@googlemail.com wrote: Hi, I'm

Re: Basic SELECT help

. But what about if I have 5 types ? On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman mdyk...@gmail.com wrote: response did not go to the list.. I assume that you mean the id must be associated with bo... -- - michael dykman - mdyk...@gmail.com May the Source be with you

Re: Basic SELECT help

22, 2012 at 10:09 AM, Neil Tompkins neil.tompk...@googlemail.com wrote: Do you know if I had multiple joins there would be a performance issue ? On Thu, Nov 22, 2012 at 3:06 PM, Michael Dykman mdyk...@gmail.com wrote: Keep joining I think. In the absence of intersect (which incurs the cost

Re: Basic SELECT help

Assuming that (id,type) is unique in the source data, that is a pretty elegant method: select id from (select distinct id, count(*) from my_table where type in (2,5) group by id having count(*) = 2)a; -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL

Re: Basic SELECT help

On Thu, Nov 22, 2012 at 11:58 AM, Neil Tompkins neil.tompk...@googlemail.com wrote: By unique you mean that no id and type would be duplicated like 1,1 1,1 Yes it isn't possible for duplicate id and type in more than 1 row Yes, that's exactly what I meant. - mdyk...@gmail.com May the

Re: Basic SELECT help

volunteers to share it. Excepting only the working assumption that he is using a MySql version released in this century, I don't know how this would have informed my analysis or response. - michael dykman On Thu, Nov 22, 2012 at 4:00 PM, Mogens Melander mog...@fumlersoft.dk wrote: On Thu, November 22

Re: Re: UDF behaves non-deterministic

will likely suggest a threadsafe alternative if one is available. If none are available, you might have to consider a mutex. - michael dykman On Mon, Nov 5, 2012 at 9:28 AM, Stefan Kuhn stef...@web.de wrote: Hi Dan, thanks for your answer. The UDF only contains functions (the one called

Re: UDF behaves non-deterministic

A couple of questions present. You mention that selecting from the whole table takes 5-10s so I assume you have a lot of records. is the data not in flux? are you sure? these conflict queries are all on the same server? i would have structured the query like so: select *,

Re: index

-- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Unknown database error

The contents of datadir is typically owned by the mysql user and group. Certain attributes on the datadir itself (ls -ld $datadir) can affect the permissions of newly-created files and directories. You need to talk to you sysadmin, with a eye towards doing something like chown -R

Re: error 13

The reason this is significant is because we are speaking about INFILE use. The server processes infile commands assuming the file is already stored on the server. LOCAL INFILE tells mysql that file is local to the mysql client and must be moved to the server before processing. I suspect that

Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

your now() statement is getting executed for every row on the select. try ptting the phrase up front as in: set @ut= unix_timestamp(now()) and then use that in your statement. On 2012-10-16 8:42 AM, spameden spame...@gmail.com wrote: Will do. mysql SHOW GLOBAL VARIABLES LIKE '%log%';

Re: Odd Behavior During Replication Start-Up

I have to agree with Harald on this: filesystem snapshots are not an effective way to clone innodb databases. The rsync-based method described has worked for me in large scale data situations very reliably. - michael dykman On Tue, Oct 16, 2012 at 3:20 PM, Reindl Harald h.rei...@thelounge.net

Re: Odd Behavior During Replication Start-Up

load data from master never worked for innodb. On 2012-10-16 3:52 PM, Tim Gustafson t...@soe.ucsc.edu wrote: Thanks for all the responses; I'll respond to each of them in turn below: you can not simply copy a single database in this state innodb is much more complex like myisam... I know;

Re: error 13

is your mysql client on the same host as the mysql server? if not, google the docs for 'local infile' On 2012-10-16 10:45 PM, Lixun Peng pengli...@gmail.com wrote: Hi, What's the dir permissions? For example, if we have a file in /a/b/file, dir a is 644, even though file is 777, we can't

Re: innodb_lock_wait_timeout

In my implementation we found no need to establish a new connection after a lock timeout but just retried on the existing connection. We did instigate a sleep timeout of 10 ms which theoretically increased on each iteration but we never had to try a third time even under very heavy load. On

Re: RE: innodb_lock_wait_timeout

The original poster mentioned that he is not using transactions explicitly. Some transactions may still occur as a side effect of some operations under certain conditions and, in a busy high load environment, cannot be entirely avoided. Having some experience with this, I can report that it is

Re: passing shell variable to the SET data type in parentheses

What is the result if you echo that line instead of running it? ie: echo mysql -u $user -p${password} --skip-column-names -e 'ALTER TABLE ' $table' MODIFY '$kolom' SET( '$var' );' $database ; I'm not clear exactly what the text is of the command you are trying to run. - michael dykman On Wed

Re: user not able to login from localhost

you use: grant select,insert,update,delete on mydb.* to mysql@localhost identified by password('password'); or what variant exactly? When you are trying to log in, are you doing that explicitly from the same server or are you accessing remotely? -- - michael dykman - mdyk...@gmail.com May

Re: Mysql cluster installation error

If all you need to transfer is schema, do it the same way you would any other table type: use mysqldump with the - - no-data option. On 2012-09-23 1:29 PM, Aastha aast...@gmail.com wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have

Re: Mysql cluster installation error

the cluster from the remote host. When i try to connect one of the SQL node through remote host it says access denied. WHile the same is working fine from local host. Kindly help. Thanks! On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman mdyk...@gmail.com wrote: If all you need to ...

Re: Licensing question about mysql_com.h

Your code might not qualify for the linking excepetion, but users of your code can use the inking exception to licence their product however they choose. - michael dykman On Mon, Apr 9, 2012 at 2:43 PM, James Ots my...@jamesots.com wrote: I don't think I can use a linking exception when I

Re: Licensing question about mysql_com.h

would necessarily be GPL. - michael dykman On Sat, Apr 7, 2012 at 6:52 PM, James Ots my...@jamesots.com wrote: I am writing a MySQL connector for the Dart programming language. I was hoping to licence it under the BSD Licence, but since it uses modified parts of mysql_com.h, which is licensed

Re: OT: SQL Question

in the flights table. I need to change the data model to allow for a many to many relationship between teacher_id and the data in the flight table. What is the best way to do this? Thanks, Mark --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing

Re: One inst has 39 columns- the other 40

Bear in mind, MySQL Cluster/NDB runs independently of the mysql nodes used to ast as clients to that cluster. This is really not an issue. - michael dykman On Thu, Mar 22, 2012 at 1:03 AM, Nuno Tavares nuno.tava...@dri.pt wrote: Charles, You should run SELECT @@version on both nodes

Re: does the number of column affect performance

are not important, only to find out later in the project that they are critical., - michael dykman On Tue, Feb 28, 2012 at 2:41 PM, Paul DuBois paul.dub...@oracle.com wrote: On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: for example there are 2 tables to save same data table A has 10 columns: a primary

Re: two 5.1 servers, different behaviour

width template -| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List

Re: two 5.1 servers, different behaviour

...@umich.edu wrote: According to Michael Dykman mdyk...@gmail.com on Fri, 02/24/12 at 11:42: That error is coming from neither the MySQL server nor from DBVisualizer.  That is coming from your JDBC driver.  Check the version of that and research the effect of configuration options. http

Re: two 5.1 servers, different behaviour

the servers.. Have you read the relevant release notes between those versions? This looks like an ugly one. I don't envy you. - michael dykman On Fri, Feb 24, 2012 at 1:09 PM, William Bulley w...@umich.edu wrote: According to Michael Dykman mdyk...@gmail.com on Fri, 02/24/12 at 12:58: I see your

Re: two 5.1 servers, different behaviour

was: I can't think of a better way to spend a weekend. Have fun! --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Stored Procedure Debugging?

In my community, interest would be VERY high.  I often counsel putting logic on the server; the biggest point of relunctance is the difficulty debugging.  - michael dykman On Wed, Feb 15, 2012 at 10:45 AM, Martijn Tonies m.ton...@upscene.com wrote: Hi all, As you probably now, we created

Re: conditional updating

untested: update set mydate = IF(mydate =  '-00-00', now(), mydate) - michael dykman On Thu, Feb 9, 2012 at 8:14 AM, william drescher will...@techservsys.com wrote: I want to update a date field in a record. if the date in the field is -00-00 I want to change it to the current

Re: conditional updating

/mysql --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Tuning mysql

Good advice, all of it. What hasn't been said and should be noted: in most cases, the bottleneck is the queries themselves. You will generally get a lot more boost from tuning those than from any configuration tweaking (excepting the pathological cases). - michael dykman On Thu, Feb 9, 2012

Re: Filesystem choice

If what you are looking for is performance optimization, you might want to consider: http://dev.mysql.com/doc/refman/5.5/en/innodb-raw-devices.html - michael dykman On Tue, Feb 7, 2012 at 1:31 PM, List Man list@bluejeantime.com wrote: Ext4 is faster to me. LS - Original Message

Re: Filesystem choice

for mysql partition, non for the root. rr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List For list archives

Re: Filesystem choice

to be a recommendation, just an item on the checklist to consider if performance-at-all-costs is the goal. - michael dykman On Tue, Feb 7, 2012 at 3:19 PM, Claudio Nanni claudio.na...@gmail.com wrote: Micheal, I have the feeling that no one on this planet uses raw devices with mysql, I

Re: mysql won't start with service, but starts with mysqld_safe

the cause. It should be owned by the mysql user. --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: how to changing default '-' character in Datetime in MySQL?

to the documentation page below for details on manipulating system variables either globally or on a per-session basis. http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html - michael dykman 2012/2/5 Halász Sándor h...@tbbs.net: 2012/02/04 19:13 -0800, Rajeev Prasad MySQL datetime field type keeps

Re: how to changing default '-' character in Datetime in MySQL?

. - Original Message - From: Michael Dykman mdyk...@gmail.com To: mysql mailing list mysql@lists.mysql.com Cc: Sent: Sunday, February 5, 2012 9:24 PM Subject: Re: how to changing default '-' character in Datetime in MySQL? To clarify, what we are discussing is the date format. It has nothing

Re: MYD, MYI and TMD files

This is still the list although more quiet than it used to be. Repairing a table is already a fragile process.. I would not try to interrupt it if the data has no backup. - michael dykman On Mon, Jan 23, 2012 at 11:04 PM, kalin m ka...@el.net wrote: hey. this list used to be pretty active

Re: MYD, MYI and TMD files

the MYD. which one has the TDM to reach in size in order for the repair to be complete? thanks. On 1/23/12 11:27 PM, Michael Dykman wrote: This is still the list although more quiet than it used to be. Repairing a table is already a fragile process..  I would not try to interrupt

Re: Editing/form interface

For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Editing/form interface

Tim, I'm a dyed-in-the-wool console user myself. I find the GUI tools make it quicker getting a project started, slower getting a project done so, no, I can't recommend a thing. - michael On Wed, Jan 18, 2012 at 7:11 PM, Tim Johnson t...@akwebsoft.com wrote: * Michael Dykman mdyk

Re: Aborted connection 102

are seeing a lot of these, don't waste your time.. it looks like operational white-noise. - michael dykman On Wed, Dec 14, 2011 at 9:39 AM, Rafael Valenzuela rav...@gmail.com wrote: Hi everybody, I have this notice , 111214 11:55:53 [Warning] Aborted connection 102 to db: 'proninop_proninop' user

Re: PID and LOG file

/5.1/en/mysqld-safe.html - michael dykman On Tue, Nov 15, 2011 at 7:31 AM, javad bakhshi javadbakh...@yahoo.com wrote: Hi, I am trying to install Mysql on linux which I don't have a root access. I have done the folowing : 1. Download source files from http://dev.mysql.com/downloads/mysql

Re: MySQL install on OS X Lion does not create root account

, there is an initialization step you may have missed. - michael dykman On Tue, Nov 15, 2011 at 4:21 PM, Martin Mueller martinmuel...@northwestern.edu wrote: I have been struggling with installing MySQL 5.5.17 on a Mac running OS 10.7. My machine had 5.5.15 on it. I keep getting user denied access messages

Re: Cleaning up old files

College, McMinnville Oregon --  - michael dykman  - mdyk...@gmail.com  May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: setting max_allowed_packet dynamically problem

properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS -- - michael dykman - mdyk...@gmail.com May the Source be with you.

credit where due

. -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: How to select the id of 2+ records for given user?

...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Starting up the server

. - michael dykman On Sat, Oct 15, 2011 at 8:24 PM, AndrewMcHorney andrewmchor...@cox.netwrote: Hello I installed the server a while back but never did anything with it. I would like to get going. How does one start the server. In my task manager under the service list I see a mysql service

Re: MySQL-devel.tar.gz Availability

on the mysql site. Thanks in Advance, Nick. -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: Monitor Locked query

Your instrumentation script should be invoking SHOW PROCESSLIST and parsing the status fields. - md On Mon, Oct 10, 2011 at 2:16 PM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Have any idea how to monitor Locked queries with Nagios? Thanks -- - michael dykman - mdyk

Re: A Newbie question about make and the term.c file

I can't help directly with the error message (the warning seems fairly harmless), but may I inquire why you are building MySQL instead of using one of the prepared binaries? Compiling under OS/X can be pretty harrowing. - michael dykman On Sat, Oct 8, 2011 at 2:49 AM, Peter Schrock peter.schr

Re: optimizer in function

| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } - michael dykman 2011/10/8 Halász Sándor h...@tbbs.net Does the optimizer look into function called from query? In my queries the expression (SELECT hwyl FROM Stock) / (SELECT regularPayment

Re: MySQL Indexes

,field_b) is not the same, and is not considered for use, the same way as idx_b(field_b,field_a). -NT Em 07-10-2011 00:22, Michael Dykman escreveu: Only one index at a time can be used per query, so neither strategy is optimal. You need at look at the queries you intend to run against

Re: MySQL Indexes

, Oct 7, 2011 at 4:26 AM, Tompkins Neil neil.tompk...@googlemail.comwrote: Is it normal practice for a heavily queried MYSQL tables to have a index file bigger than the data file ? On Fri, Oct 7, 2011 at 12:22 AM, Michael Dykman mdyk...@gmail.com wrote: Only one index at a time can be used

Re: MySQL Indexes

, schrieb Michael Dykman: When a query selects on field_a and field_b, that index can be used. If querying on field_a alone, the index again is useful. Query on field_b alone however, that first index is of no use to you. On Fri, Oct 7, 2011 at 10:49 AM, Brandon Phelps bphe...@gls.com

Re: MySQL Indexes

:55 PM, Neil Tompkins neil.tompk...@googlemail.comwrote: Can you give more information as to why the second index would be of no use ? On 7 Oct 2011, at 18:24, Michael Dykman mdyk...@gmail.com wrote: No, I don't think it can be called. It is a direct consequence of the relational paradigm

Re: MySQL anemic GIS support

General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: MySQL Indexes

test_table WHERE score 10 AND name Like '%Red%' ORDER BY score DESC How many indexes should be created for these two queries ? Thanks, Neil -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: 4 minute slow on select count(*) from table - myisam type

I am curious.. Are you the only client on this database or or there other connections doing work in the background? A busy insert/update heavy application could cause these effects. - michael dykman On Thu, Oct 6, 2011 at 12:35 PM, Joey L mjh2...@gmail.com wrote: i did google search

Re: MySQL Indexes

that was a bad example. If the query was name = 'Red' what index should I create ? Should I create a index of all columns used in each query or have a index on individual column ? On 6 Oct 2011, at 17:28, Michael Dykman mdyk...@gmail.com wrote: For the first query, the obvious index on score

Re: Query Optimization

will protect you against that, - michael dykman` On Tue, Aug 30, 2011 at 12:45 PM, Brandon Phelps bphe...@gls.com wrote: Hello, I have the following query I'd like to optimize a bit: SELECT sc.open_dt, sc.close_dt, sc.protocol, INET_NTOA( sc.src_address

Re: Arrays

tables with the exact same name with no fear of them conflicting or affecting each other's data. They work like a charm even in high load, multi-concurrency environments. -- - michael dykman - mdyk...@gmail.com May the Source be with you.

Re: a lesson in query writing and (maybe) a bug report

It is a general rule that indexes for columns with low cardinality are not worth it, often making queries more expensive than they would be without said index. binary columns all suffer from this. - michael dykman On Sat, Aug 27, 2011 at 4:52 PM, Dave Dyer ddyer-my...@real-me.net wrote

Re: Arrays

. - michael dykman 2011/8/26 javad bakhshi javadbakh...@yahoo.com Thanks guys for the help. but my problem seems to stand unsolved. From: Johan De Meersman vegiv...@tuxera.be To: Halász Sándor h...@tbbs.net Cc: mysql@lists.mysql.com Sent: Friday

  1   2   3   4   5   >