RE: io thread very slow copying binlogs

e like you 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 -Origin

Re: Query Summary Help...

On Oct 22, 2015, at 2:41 PM, Michael Dykman 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 > > the primary table in the query. > > Yeah I

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 > p.pk_ProductID, > p.De

Re: Very strange issue while trying to login remotely

.8 -uroot db_name > ERROR 1045 (28000): Access denied for user 'root'@'1.2.3.4' (using > password: NO) > > > I am at complete loss, I have done all that I could find from google. > I will be really, really grateful for ideas that could help me recover from >

Re: time stamp specific to columns

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 the Source be with you.

Re: ssh basics

gt; > > -- > 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: Help with REGEXP

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: update and control flow

eif WORD like 'b%' SET COMMENT = 'b' > > END IF > > > > > > But this gives me an error message. What am I doing wrong? > > > > MM > > > > Martin Mueller > > > > Professor emeritus of English 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 exp

Re: MySQL dying?

> much mail in this list that there was no time to answer trolls... the > real trolls? > > You have a bad attitude man, and it sucks. > > Now, back to business.. > > Ruben > > -- > 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: 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" wrote: > maybe try 'order by sort_id desc'? > > > On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland wrote

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

#x27;/home/thufir/make_year_model.csv' not found >(Errcode: 13) >mysql> >mysql> quit >Bye >thufir@dur:~$ >thufir@dur:~$ cat /home/thufir/make_year_model.csv >make1,model1,2012,604,buy now >make2,model2,2013,780,need to sell >ma

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

r application does not send such queries to the DB. I have searched > through my entire code and we dont run 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...@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: multilple mysql engines, one set of shared table spaces?

conditions? 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/

Re: Decode Json in MySQL query

t;18" >> } >> ] >> >> and after query, I want result as: >> NameAge >> Abc 20 >> Xyz 18 >> >> >> Would this be possible, I greatly appreciate any help regarding this >> matter. >&

Re: Precedence in WHERE clauses.

cessed first, but I can't really find any useful information > about this . > > Is there any performance impact on query processing, about the order of > WHERE clauses ? > > Regards, > Christophe. > > > -- > MySQL General Mailing List > For list archives: http:/

Re: regexp in conditional

> SELECT (IF r REGEXP '^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 be with you.

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

hat's pretty much > standard SQL convetion of db.table.column format. And even more baffling is > why it wouldn't dump out the "USE" statement always even if there is only > one DB. It's a few characters and would save a lot of headaches in case > someone tried to dump their .sql file into the wrong DB on accident. > > Plus it's not easy to edit a 2.6GB file to manually insert these "USE" > lines. > > Is there a way 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" wrote: > I prefer your s

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" wrote: > Hi Shawn > > Thanks for your reply. Maybe my example wasn't detailed enough. Basically > the snippet of the UPDATE statement I provide

Re: restore problem

; > MySQL retourneerde: > > > > #1100 - Table 'pma_tracking' was not locked with LOCK TABLES > > > > Since I do a full restore I'm processing the younameit.SQL file > > > > I'm bad in interpreting the error messag, don't understand what it > exactly mens and what I can do to cure this problem. > > > > Anyone 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!!!!!

+---+ > | @@global.sql_mode | > +---+ > | | > +---+ > > Not sure why I am getting this error. > > > 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

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

Re: string-likeness

te it in C and link >> it to MySQL--and joining on equality takes a fraction of a second, and >> this takes hours. Any good ideas? >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://

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

> > What am I doing wrong? > > Regards, > > Miguel > > -- > 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 Sourc

Re: Bug in BETWEEN same DATETIME

thout me manually appending the time portion)? > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity > to which it is addressed. If the reader of this e-mail is not the intended > recipient or hi

Re: auto-increment more than one field

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

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

Re: Chain Replication QUestion

e first lines of the mysqldump where you'll find > > the position and logfile those slaves need to start the replication from. > > You 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

get around 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 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 wrote: > hi list, i

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 w

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 wrote: > > On Thu, November 22, 2012

Re: Basic SELECT help

On Thu, Nov 22, 2012 at 11:58 AM, Neil Tompkins 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 Source be with you. --

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 t

Re: Basic SELECT help

22, 2012 at 10:09 AM, Neil Tompkins 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 wrote: >> >> Keep joining I think. In the absence of intersect (which incurs the cost >> o

Re: Basic SELECT help

out if I have 5 types ? On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote: > > > > response did not go to the list.. > > > > > > I assume that you mean the id must be associated with bo... > > > > > > > -- > > - mic

Fwd: Basic SELECT help

e' where type=2 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 wrote: > Hi, > > I&#

Re: Re: UDF behaves non-deterministic

page 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 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 *, udf(column,'value'

Re: index

> false > false > > EN-US > X-NONE > AR-SA > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

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

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 thi

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" 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 access file, too. On

Re: Odd Behavior During Replication Start-Up

load data from master never worked for innodb. On 2012-10-16 3:52 PM, "Tim Gustafson" 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; that's why I rsy

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

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" wrote: Will do. mysql> SHOW GLOBAL VARIABLES LIKE '%log%'; +---

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 2012-1

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 safe

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 th

Re: user not able to login from localhost

create and grant privileges to that user? Did 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

Re: Mysql cluster installation error

he 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 wrote: > > If all you need to ...

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" wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : Ho

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 wrote: > I don't think I can use a linking exception when I license my

Re: Licensing question about mysql_com.h

would necessarily be GPL. - michael dykman On Sat, Apr 7, 2012 at 6:52 PM, James Ots 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 unde

Re: OT: SQL Question

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

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 wrote: > Charles, > > You should run "SELECT @@version" on both nodes

Re: does the number of column affect performance

e 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 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 c

Re: two 5.1 servers, different behaviour

. > > Gee, thanks for those words of encouragement - NOT!   :-) What I meant to say 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: two 5.1 servers, different behaviour

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 wrote: > According to Michael Dykman on Fri, 02/24/12 at 12:58: >> >> I see your p

Re: two 5.1 servers, different behaviour

iam Bulley wrote: > According to Michael Dykman 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 op

Re: two 5.1 servers, different behaviour

7;d rather > not have to do that unless that is the called for solution. > > I would be greatful for any hints or suggestions as to how I might go > about correcting this problem.  Thank you in advance. > > Regards, > > web... > > -- > William Bulley              

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 wrote: > Hi all, > > As you probably now, we created "Data

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,

Re: conditional updating

gt; > > -- > 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

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

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 wrote: > Micheal, > > I have the feeling that no one on this planet uses raw devices with mysql, > I might be

Re: Filesystem choice

ween xfs and ext4; ext4 with >> >> noatime,nodiratime,data=writeback,barrier=0,nobh,commit=100,errors=remount-ro >> >> and formatted with >> -b 4096 -E stride=16,stripe-width=32 >> >> is right choice or nobarrier is too unsafe? Only for mysql partition, non &

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 wrote: > Ext4 is faster to me. > > > LS > > > > - Origi

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

archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql > I haven't seen it mentioned, so I'll give it a shot: Have you checked the permissions on your data directory? If you are getting no message in your .err file thhat is often 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?

This variable is unused. > > > - Original Message - > From: Michael Dykman > To: mysql mailing list > 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 discus

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

refer. Refer 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 : >>>>> 2012/02/04 19:13 -0800, Rajeev Pras

Re: MYD, MYI and TMD files

ller than > 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 alrea

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 wrote: > > > hey. this list used to be pretty ac

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 wrote: > * Michael Dykman [120118 13:00]:

Re: Editing/form interface

ySQL 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Aborted connection 102

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 wrote: > Hi everybody, > I have this notice , > 111214 11:55:53 [Warning] Aborted connection 102 to db: 'proninop_proninop'

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

initialization step you may have missed. - michael dykman On Tue, Nov 15, 2011 at 4:21 PM, Martin Mueller 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 (Error 1045).

Re: PID and LOG file

efman/5.1/en/mysqld-safe.html - michael dykman On Tue, Nov 15, 2011 at 7:31 AM, javad bakhshi 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/downloa

Re: Cleaning up old files

> > Thanks. > > > Rob Tanner > UNIX Services Manager > Linfield 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.

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

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

credit where due

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

Re: Starting up the server

MySQL. - michael dykman On Sat, Oct 15, 2011 at 8:24 PM, AndrewMcHorney wrote: > 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 but it

Re: MySQL-devel.tar.gz Availability

only able to find rpm 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 wrote: > Hi, Folks: > > Have any idea how to monitor Locked queries with Nagios? > > Thanks -- - michael dykman

Re: optimizer in function

[NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } - michael dykman 2011/10/8 Halász Sándor > Does the optimizer look into function called from query? > > In my queries the expression (SELECT hwyl FROM Stock) / (SELEC

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

Re: MySQL anemic GIS support

I'd rather not have to. > > …Rene > -- > MySQL 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

- md On Fri, Oct 7, 2011 at 2:55 PM, Neil Tompkins wrote: > 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 wrote: > > > No, I don't think it can be called. It is a direct consequence of the

Re: MySQL Indexes

ardinality of each field; > >>> > >>> There is a tool "Index Analyzer" that may give you some hints, and I > >>> think it's maatkit that has a tool to run a "query log" to find good > >>> candidates - I've seen it somewhere,

Re: MySQL Indexes

, Oct 7, 2011 at 4:26 AM, Tompkins Neil wrote: > 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 wrote: > >> Only one index at a time can be used per query

Re: MySQL Indexes

query log" to find good >> candidates - I've seen it somewhere, I believe >> >> Just remember that idx_a(field_a,field_b) is not the same, and is not >> considered for use, the same way as idx_b(field_b,field_a). >> >> -NT >> >> >>

Re: MySQL Indexes

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 wrote: > > For the first query, the obvious index on score

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 wrote: > i did google search - myisam is faster.

Re: MySQL Indexes

> 10 > ORDER BY score DESC > > > SELECT auto_id, name, score > FROM 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: Query Optimization

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

Re: Arrays

opped when that connection closes,. Concurrent connections can create temporary 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 wrote: > > The "innoc

Re: Arrays

. - michael dykman 2011/8/26 javad bakhshi > > > Thanks guys for the help. but my problem seems to stand unsolved. > > > > > From: Johan De Meersman > To: Halász Sándor > Cc: mysql@lists.mysql.com > Sent: Friday, Augu

  1   2   3   4   5   >