Procedure error handling Best Practice

@p4), 'pop_comm_summary', 1003, 1003); end; So, what if the insert (shown above) throws a sqlexception? 1) What happens? 2) Is there a better way to do this? Perhaps I should not have DML in my error block? Michael Moore

RE: Automated SQL checker?

Use MySQL workbench. Add query to the editor, execute, check results. Then, use the "Execution plan" feature to see how things are executing and look for bad things (Cartesian products, stupid loops, etc...) See also: Query stats. Michael Munger, dCAP, MCPS, MCNPS, MBSS High Po

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: Mystery error in GRANT statement

Nothing. But you opened your quote 27th a " and tried to close it with a ' Quote mismatch. Get Outlook for Android On Mon, Oct 3, 2016 at 9:45 PM -0400, "James Moe" mailto:ji...@sohnen-moe.com>> wrote: opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I ha

Init script fails.

TLDR = /etc/init.d/mysql start fails after the following line (line 22), and I would like to fix it so that init starts mysqld automatically. Problem line: |./lib/lsb/init-functions| This is included in nearly all init scripts, and other init scripts work just fine. Putting breadcrumbs in th

Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.

If you execute the script below, you will get the following error: 'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist" delimiter // CREATE TABLE Test( id int not null primary key auto_increment, name varchar(255) )// CREATE TRIGGER TEST_TRIGGER BEFORE INSERT ON Test FOR EACH R

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.

After long semaphore waits MySQL becomes unresponsive.

Same problem here... happens about once a month, since recent MySQL version update http://qnalist.com/questions/4209635/after-long-semaphore-waits-mysql-becomes-unresponsive

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: libmysql.lib

http://dev.mysql.com/doc/mysql-sourcebuild-excerpt/5.0/en/windows-source-build-cmake.html step 4: From the work directory, execute the win\build-vs8.bat or win\build-vs71.bat file, depending on the version of Visual Studio you have installed. The script invokes CMake, which generates the mysql.

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.

Slow inserts after moving to new system

old server with no change in the results. I’ve also allocated more RAM to InnoDB with also no change in insert time. I’m not sure what to try looking at next. Does anybody have any ideas? Cheers, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

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: Date comparison help

Thanks Sam. It turns out that if I put the DATE_ADD.. within DATE(), it works as expected. That is sufficient for my goals, but it would be nice to understand this issue in case there may be other cases that I need to watch out for. Cheers, Michael On Oct 22, 2013, at 6:18 PM, kitlenv

Date comparison help

I recently upgraded a local MySQL installation to 5.5.32 and am trying to figure out why the following query won't work as expected anymore. I'm just trying to compare a set of dates to NOW() but since the upgrade, these don't seem to work as expected. SELECT DATE_ADD(STR_TO_DATE('2013-350-00:

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: replication newbie questions

Hi! > "Ed" == Ed L writes: Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave Ed> replication. Here's my scenario... Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via Ed> master-slave configuration to a new, beefier server running same mysql

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

Using deductive reasoning one would surmise that Effiong wants to install the MySql Database on a laptop, But then the question to Effiong is: What Operating System is running on your LapTop? NOTE: You'll need a MySql Server and a MySql Client, and maybe a Gui Interface/WorkBench? You can do

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

it allows an index 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` B

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.

Problems compiling 5.6.10 under CygWIN for Windows

7; failed make[2]: *** [storage/innobase/CMakeFiles/innobase.dir/handler/ha_innodb.cc.o] Error 1 CMakeFiles/Makefile2:755: recipe for target `storage/innobase/CMakeFiles/innobase.dir/all' failed make[1]: *** [storage/innobase/CMakeFiles/innobase.dir/all] Error 2 Makefile:146: recipe for target `all' failed make: *** [all] Error 2 Best regards, Michael

Re: Animation studio asset management

Database performance (like system performance) is always driven by a give and take process, a trade-off between resources (this includes design expertise) available, and the required results. How many records are you dealing with? How often are records are being added and/or updated? How many u

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

Keep joining I think. In the absence of intersect (which incurs the cost of a query per type anyhow ), this join pattern is the only option I can think of. On 2012-11-22 10:01 AM, "Neil Tompkins" wrote: Michael, Thanks this kind of works if I'm checking two types. But what ab

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: InnoDB vs. other storage engines

Hi! > "Manuel" == Manuel Arostegui writes: Manuel> 2012/9/19 Mark Haney >> I hope this doesn't end in some kind of flame war. I'm looking to >> optimize my tables (and performance in general) of the DB my web app is >> using. I'm tweaking things a little at a time, but I'm curious as to

re: ignore-db-dir

Hi! > "Noel" == Noel Butler writes: Noel> Shaun, Noel> Is this option planned for backport into 5.5.x ? Another option is to provide a patch and suggest to have it included in MariaDB 5.5. You can of course also consider to sponsor this so that we can do this for you... Regards, Monty Cr

Re: Machine Learning

I think it was the HAL-9000 in the movie 2001: A Space Odyssey On 08/20/2012 06:25 PM, Martin Gainty wrote: When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is running the show constantly admonishing its creator to "take another stress pill" Sounds like a fun project

Re: real Time

Look at Nodejs, asynchronous server-side programming environment. That combined with some basic MySql triggers could do it for you. On 08/13/2012 04:07 PM, Rafael Valenzuela wrote: Hi all, i've a question about the mysql configuration, in my project, we need use data in real time (read and ins

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

Hi! > "Fred" == Fred G writes: Fred> Thanks Dhaval. Putting the join condition before INTO outfile doesn't seem Fred> to work, either. Fred> When I try to use the same outfile name 'test123.csv' I get Error Code: Fred> 1086 File 'test123.csv' already exists. But then when I try to find

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: Query help...

the first non-NULL value in the list, or NULL if there are no non-NULL values. URL: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html Examples: mysql> SELECT COALESCE(NULL,1); -> 1 Michael Heaney JCVI -- MySQL General Mailing List For list archives: http://lists.my

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

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://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html - michael

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

He did mention that there was another field he was updating, which implies that the state of the date field was not the only condition. - michael On Thu, Feb 9, 2012 at 9:22 AM, Johnny Withers wrote: > So, add your "other criteria" to the where clause, you failed to say >

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?

code will tend to behave differently between different servers. - michael On Sun, Feb 5, 2012 at 11:07 PM, Rajeev Prasad wrote: > thx Michael, > > but the page says: > >        * date_format > This variable is unused. >        *    datetime_format >

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: Chinese characters not displaying in Workbench latest version

I think what he was asking is, Are you running the Mysql workbench on the same machine? You may not have the correct Fonts. Being replicated the character sets of the two dbs should be the same have you checked that they actually are set to the same? On Monday, November 21, 2011 9:20:10 PM N

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

  1   2   3   4   5   6   7   8   9   10   >