Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Probably the dumbest suggestion yet, but have you tried "set names utf8" in the client? On 20 March 2018 20:50:08 CET, Roger House wrote: > > >On 03/15/2018 02:06 PM, Roger House wrote: >> >> >> On 03/15/2018 11:30 AM, shawn l.green wrote: >>> Hi Roger, >>> >>> (please note,

Re: Examples of savepoints and transactions

What you're looking for is simple backup and restore :-) Savepoints are, simply put, markers within a transaction; allowing you to rollback only part of a transaction instead of the whole thing. A commit will inevitably commit the ENTIRE transactions, and thus remove the savepoints. A typical

Re: mysqld_multi

He means a database, not a schema. Instance would have been clearer as terminology goes, admittedly, but in a MySQL context the two are identical. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- MySQL General Mailing List For list archives:

Re: Can not add foreign key constraint

----

Re: kill query and prepared statements

Seb, You should log a bug at http://bugs.mysql.com - this is not a developer list. /Johan - Original Message - > From: "Sebastien FLAESCH" > To: "MySql" > Sent: Tuesday, 10 January, 2017 14:55:42 > Subject: kill query and prepared statements > Hi

Re: audit trails

Triggers are not the best way to go about this. Consider: * What is to stop a malicious user from truncating the audit table? * Triggers may fail (corrupt target table, for instance) and a trigger failure may cancel the source statement * Triggers have a performance impact - you're basically

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

- Original Message - > From: "Reindl Harald" > Sent: Friday, 16 September, 2016 00:12:26 > > frankly - mysqld_safe needs to go away and life is beautiful without for > years here and yes taht worked for mysql too before switch to MariaDB > > to say it clear:

Fwd: Update to Percona CVE-2016-6662 Vulnerability Communication

This is probably of interest to many of you, and I've not seen it on the list yet. Kenny Gryp's blog about the vulnerability is at https://www.percona.com/blog/2016/09/12/database-affected-cve-2016-6662/ . For those who use it, there's an ansible playbook to patch the workaround into

Re: MySQL Platform Migration

l Harald" <h.rei...@thelounge.net> > To: "MySql" <mysql@lists.mysql.com> > Sent: Tuesday, 13 September, 2016 13:39:59 > Subject: Re: MySQL Platform Migration > Am 13.09.2016 um 12:13 schrieb Johan De Meersman: >> - Original Message - >>>

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" > Subject: Re: MySQL Platform Migration > > we discussed this multiple times here True; but new people on the list may not have seen that. > when you *copy* the datadir on the target machine nobody eats your data >

Re: MySQL Platform Migration

- Original Message - > From: "Matthias Schmidt" > Subject: Re: MySQL Platform Migration > > I had to make certain adjustements to the config file thou. Interesting - what changes did you have to make? I would expect most things to just keep working as they are, unless

Re: MySQL Platform Migration

- Original Message - > From: "Ryan Coleman" > Subject: Re: MySQL Platform Migration > > Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edge, his technical advice is always solid. What has your

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" > Subject: Re: MySQL Platform Migration > > why shouldn't it when the identical software is running? > it's just a bunch of files used by mysql Little/big endianness, for one, although I seem to recall, and your later

Re: MySql Swapping issues

- Original Message - > From: "Machiel Richards" > Subject: Re: MySql Swapping issues > > When I monitor the MySQL processlists, there is constantly about 30-35 > processes > and half of them never change simply showing as : > > Connect | 124678 | Waiting for

Re: MySql Swapping issues

- Original Message - > From: "Machiel Richards" > Subject: MySql Swapping issues > >I had a look at the settings and the innodb buffer pool on one server > is set to about 70% of the physical memory and the others to about 30% of > physical memory. Not

Re: filename-safe conversion of database-/tablenames

- Original Message - > From: "Simon Fromme" > Subject: filename-safe conversion of database-/tablenames > > I need to convert both the names of databases and tables in a > filename-safe way (escaping "/" and other characters as in [1]). The I don't know what strange

Re: find any row with NULL

- Original Message - > From: "lejeczek" > Subject: Re: find any row with NULL > ok, whereas that fist example was about all (and find > columns' names without knowing) columns - would there be a > simple(r) syntax to find that (not)NULLs in a list of given > column

Re: find any row with NULL

- Original Message - > From: "lejeczek" > Subject: Re: find any row with NULL > > shame NULL won't work as in: > > select user_id,completetion_time from depression where > NULL in(email_me, other_diagnosis); > or does it? No, because NULL != NULL - it is why there

Re: check_mysql_health poll

Useful knowledge, thank you, Shawn. Good to see confirmed that qcache_hits + com_select is the global total - that's not always very clear in the docs. I just noticed that when I copied the list for extra exposure, I didn't actually say what I was exposing :-p Gerhard Laußer, who maintains

check_mysql_health poll

Hey, I just happened upon your poll, so I'm sending you brief mail because I have a different opinion still :-) I'm also CCing the MySQL list, as I feel that more input on this might be a good thing - and it's worth some exposure anyway. I believe there are two distinct measures that can be

Re: find any row with NULL

- Original Message - > From: "Sándor Halász" > Subject: Re: find any row with NULL > > from information_schema.columns where (table_schema, table_name, You could, but information_schema queries can get pretty slow on large databases, especially so with InnoDB. Recent

Re: find any row with NULL

You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those :-) Remember, NULL is a special value that is not the same as zero or the empty string; nor to itself: NULL !=

Re: call the appropriate and correct database

- Original Message - > From: "HaidarPesebe" > Subject: call the appropriate and correct database > How do I call first database table as follows : > > id | country | province | distric | cost > > 1 | USA |

Re: slave to master

> From: "Mahmoud Alshinhab" > Subject: Re: slave to master > I think you should have a look at MariaDB Connector[1]. > It provides Load balancing and failover as Failover occurs when a connection > to > a primary database server fails and the connector will open up

Re: slave to master

- Original Message - > From: "Jason Mallory" > Subject: RE: slave to master > > Master-master with load balancer would be best That's a bit brief, isn't it? :-) It's more than worth pointing out that your loadbalancer should not actually be loadbalancing the

Re: parallel installations of mysql

That works nicely, you just need to make sure that you set up the second instance on a different port, with different data and log directories etc. Do you expect many issues from the upgrade? In most cases, an in-place upgrade should work the same or better than the old version :-) -

Re: dump, drop database then merge/aggregate

- Original Message - > From: "lejeczek" > Subject: Re: dump, drop database then merge/aggregate > > today both databases are mirrored/identical > tonight awkward end will dump then remove all the data, then > collect some and again, dump then remove > and these dumps

Re: my.cnf authencication

- Original Message - > From: "Harrie Robins" > Subject: my.cnf authencication > > mysqldump --defaults-file dbase > c:\sql\dbase.sql 2>> c:\log.tct Might just be a typo in your mail, but you'll need to actually pass the defaults-file, too:

Re: Query optimizer-miss with unqualified expressions, bug or feature?

- Original Message - > From: "Shawn Green" > Subject: Re: Query optimizer-miss with unqualified expressions, bug or > feature? > > On a more serious note, indexes with limited cardinality are less useful > than those with excellent cardinality. Cardinality is

Re: When to create a new database

- Original Message - > From: "Ron Piggott" > Subject: Re: When to create a new database > > I would lean towards keeping it all together because of the speed > decrease between connecting to different databases. Heh, that consideration is a matter of

Re: When to create a new database

- Original Message - > From: "Reindl Harald" > Subject: Re: When to create a new database > > it makes zero sense since you can use different users for the same > database down to table and even column permissions No, it does make some sense in the case where

Re: table desin question

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

Re: Changing storage engine in dump file.

- Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Changing storage engine in dump file. Is there any implications in doing so. Is this approach correct? Will I face any problem in syncing the slave? The first thing that occurs to me, is that the

Re: MySQL 5.5 Slow performance to insert

- Original Message - From: Camilo Vieira camilo.vie...@gmail.com Subject: Re: MySQL 5.5 Slow performance to insert $ ./mysqltuner.pl --user root --pass abril@123 Thank you for that password :-) I don't particularly like MySQLtuner myself, it makes assumptions about your workload

Re: Unable to start mysql after power Failure

Just to be sure, is that first sentence supposed to be reading node-2 and not node-1? The datafiles should not be in use anywhere, on any node, or disaster will be your share. Additionally, what is your shared filesystem? Is it possible that there is still a lock on the datafiles at that

Re: server-side logging of query errors?

From: Singer X.J. Wang w...@singerwang.com Subject: Re: server-side logging of query errors? You could log all queries using the audit plugin, 15% hit.. Fair point, though: maybe one of the different audit plugins has the capability to specifically log faulty requests. Have a look through

Re: server-side logging of query errors?

None that I'm aware of. It would be a mild security risk; a malicious (or just stupid, see Hanlon's razor) user could spam your server with malformed requests until the logging disk runs full, at which point the daemon would suspend operations until space is freed. Maybe one of the proxies

Re: server-side logging of query errors?

- Original Message - From: Tomasz Chmielewski man...@wpkg.org It would be a mild security risk; a malicious (or just stupid, see Hanlon's razor) user could spam your server with malformed requests until the logging disk runs full, at which point the daemon would suspend operations

Re: create_time

That sounds logical. I have, however, also had Martin's experience where create_time seemed improbable; - Original Message - From: Pothanaboyina Trimurthy skd.trimur...@gmail.com To: Martin Mueller martinmuel...@northwestern.edu Cc: MySql mysql@lists.mysql.com Sent: Friday, 1 May,

Re: create_time

important to me at the time. I'll be monitoring this thread with interest :-) - Original Message - From: Johan De Meersman vegiv...@tuxera.be To: Pothanaboyina Trimurthy skd.trimur...@gmail.com Cc: Martin Mueller martinmuel...@northwestern.edu, MySql mysql@lists.mysql.com Sent: Monday, 4

Re: duplicate rows in spite of multi-column unique constraint

Please do select id, customer_id, concat('-', group_id, '-') from app_customergroupmembership where customer_id ='ajEiQA'; I suspect one of those group IDs has a trailing space or similar 'invible' character that makes it not identical. - Original Message - From: Chris

Re: ssh basics

- Original Message - From: Thufir hawat.thu...@gmail.com Subject: Re: ssh basics On Mon, 09 Mar 2015 16:00:08 +0100, Johan De Meersman wrote: All in all, you've done the opposite of what I asked - you've told me what you know and tried, but not what you were trying to figure out

Re: ssh basics

- Original Message - From: Lucio Chiappetti lu...@lambrate.inaf.it I may like a way to have a program (namely RSI IDL) to connect (bypassing the line mode mysql client) to the mysqld socket and issuing commands to it (essentially I want to issue a select into a table, and read back

Re: LISTMASTER: remove @naver.com addresses

- Original Message - From: Reindl Harald h.rei...@thelounge.net Subject: LISTMASTER: remove @naver.com addresses i am really pissed of by get backscatters from hip...@naver.com or webmas...@naver.com after each mail to this list over years containing japanse crap and Your mail was

Re: ssh basics

- Original Message - From: Thufir hawat.thu...@gmail.com Subject: Re: ssh basics Thank you for explaining that. I can't quite tell wether you're being sarcastic or not, so I'm going to give you the benefit of the doubt :-) Can you explain what you're trying to accomplish, without

Re: Remote Access to MySQL

- Original Message - From: Rafael Ribeiro rafaelribeiro...@gmail.com Subject: Remote Access to MySQL After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost the ability to connect to mysql remotely, from external IPs. It doesn't work is not a helpful comment

Re: ssh basics

- Original Message - From: Emil Oppeln-Bronikowski e...@fuse.pl Subject: Re: ssh basics Please, people, do we need that kind of thread? Most action this list has seen since we had a thread about how little action this list sees... :-p -- The idea that Bill Gates appeared like a

Re: ssh basics

- Original Message - From: Thufir hawat.thu...@gmail.com Subject: Re: ssh basics I was being serious, I always appreciate a reply. I know it was worded oddly, but, yes, just take it at face value, please. Oh, I didn't see anything wrong with wording, but text doesn't convey a lot

Re: Users and Groups

That reminds me, this may be of interest: http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/ - Original Message - From: Lucio Chiappetti lu...@lambrate.inaf.it To: MySql mysql@lists.mysql.com Sent: Wednesday, 4 March, 2015 12:39:01 Subject: Re:

Re: Capturing milestone data in a table

- Original Message - From: Phil pchap...@nc.rr.com Subject: Capturing milestone data in a table user_credits where metric1 $mile and (metric1 - lastupdate) $mile) That second where condition is bad. Rewrite it as metric1 ($mile + lastupdate). Better yet, combine them into a

Re: Users and Groups

- Original Message - From: Reindl Harald h.rei...@thelounge.net Subject: Re: Users and Groups Am 01.03.2015 um 20:07 schrieb Steffan A. Cline: Has anyone seen a plugin for MySQL that will allow you to set up users and groups for access where you can have a user who can login, create

Re: Merging multiple SQL requests

- Original Message - From: Jay Ess li...@netrogenic.com Subject: Re: Merging multiple SQL requests UNION is used to combine the result from multiple SELECT statements into a single result set. Yes, but only if your queries return the same number of fields; and you get a single

Re: is a .sql file transactional

- Original Message - From: thufir hawat.thu...@gmail.com Subject: is a .sql file transactional when you run a .sql file, which modifies a schema, is it transactional? Specifically, is it an all-or-nothing proposition? Or, can some commands get executed, some fail? A file is nothing

Re: Merging multiple SQL requests

...it sounds to me like you're trying to figure out the small things when there's probably an elephant standing around somewhere :-) You can quickly see if your network is troublesome using: * traceroute * ping * network copy (ssh/nfs/samba/whatever) of a large file Usually, however, it's

Re: command is not allowed with this MySQL version

- Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was,

Re: Xml data import

- Original Message - From: Sayth Renshaw flebber.c...@gmail.com Subject: Xml data import I have an xml data feed with xsd, it's complex in elements not size. Wray are the best way to get data into mysql, do I have to hack with xquery? That's going to depend on the complexity of

Re: forum vs email

- Original Message - From: Sándor Halász h...@tbbs.net Subject: Re: forum vs email Something more sophisticated than grouping messages by trimmed subject-lines? maybe involving such header lines as were used in the old netnews (if e-mail is That's only a single level. Fora are more

Re: How to retrieve next record?

- Original Message - From: Wm Mussatto mussa...@csz.com Subject: Re: How to retrieve next record? Related what is the form of the prmary key. If its numeric something like $sDBQuery1 = SELECT * FROM kentekenlogtest WHERE kenteken '$sActueelkenteken' limit 1 might work. No,

Re: command is not allowed with this MySQL version

- Original Message - From: Christophe t...@stuxnet.org Subject: command is not allowed with this MySQL version 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discouraged and will be

Re: forum vs email

- Original Message - From: Sándor Halász h...@tbbs.net Subject: Re: forum vs email I believ that one could both by e-mail and through a webbrowser comment on a Google group. True; and before that there was yahoo groups, and others. Those are not fora, however, merely web interfaces

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

- Original Message - From: Jigal van Hemert ji...@xs4all.nl Subject: Re: forum vs email [was: Re: table-for-column] On typo3.org there used to be mailing lists only in a distant past. Later on newsgroups were set up which communicate with the mailing lists (newsgroups are the

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

- Original Message - From: Johan De Meersman vegiv...@tuxera.be Sent: Wednesday, 10 December, 2014 09:02:45 Subject: Re: forum vs email [was: Re: table-for-column] Hmm. That sounds interesting, I'll have a look. I don't suppose the software is available under a foss license? :-p

Re: signal handling in mysql cli

- Original Message - From: Sebastien FLAESCH s...@4js.com Subject: Re: signal handling in mysql cli Nobody concerned by this case? Simple question: is it safe or not to do a KILL QUERY in a SIGINT signal handler? I don't see what the extra risk would be as opposed to doing so in any

Re: Specking a small MySQL server

- Original Message - From: Richard Reina gatorre...@gmail.com Subject: Specking a small MySQL server somewhat of an energy hog and is due to be replaced. I was considering replacing it with a lap-top so as to conserve energy and because a laptop has a built in battery backup.

Re: forum vs email

- Original Message - From: Sándor Halász h...@tbbs.net Subject: Re: forum vs email That is, this list, right? What does it lack (besides readers)? This list interacts with the forums on mysql.com? Every thread here matches one on there, and vice versa? (Honest question; I hardly ever

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

- Original Message - From: Jan Steinman j...@ecoreality.org Subject: Re: forum vs email [was: Re: table-for-column] There actually seem to be a lot of these around. I'm on several that send me email when there are new forum postings. Yes, that bit is pretty standard functionality;

Re: table-for-column

- Original Message - From: Shawn Green shawn.l.gr...@oracle.com Subject: Re: table-for-column My problem is a lack of time. I can monitor the mailing lists or the forums but rarely both while still doing my regular job of handling the official service requests. I've long wanted to

Re: signal handling in mysql cli

- Original Message - From: wharms wha...@bfs.de Subject: signal handling in mysql cli when i use CTRL-C to break a query that works fine in interactive mode. but when i use the noninteractive mode i looks like that but show full processlist; shows otherwise and that is true

Re: table-for-column

- Original Message - From: peter brawley peter.braw...@earthlink.net Subject: Re: table-for-column I wonder if anyone knows why sites like Stack Overflow and those of ours I mentioned are seeing more volume, while this list and all MySQL fora are seeing much, much less. The major

Re: MySQL dying?

- Original Message - From: Ruben Safir ru...@mrbrklyn.com Subject: Re: MySQL dying? Well, this mailing list is dead. This is a mailing list that used to handle 70+ questions a day, or more. Is that why you feel the need to troll on posts from two years ago? If you think it's

Re: Which replication solution should I choose?

From: Walter Heck walterh...@olindata.com Subject: Re: Which replication solution should I choose? Hi Johan, it'll be a good ol' war story of the transition of a large 130k QPS MMM cluster to PXC, so come visit for sure. Here's the link to the session:

Re: Multi-Master Asynchronous Replication

- Original Message - From: Rodrigo Ferreira rodrigof_si...@yahoo.com Subject: Multi-Master Asynchronous Replication Hi, Is that a way to make multi-master asynchronous replication with mysql ou external lib? I know galera cluster but it is synchronous. The problem is a set of

Re: MySQL dying?

- Original Message - From: Ruben Safir ru...@mrbrklyn.com Subject: Re: MySQL dying? abandoned. What would you have done in those days when we handled so much mail in this list that there was no time to answer trolls... the real trolls? We? You mean the two mails you sent back in

Re: MySQL dying?

- Original Message - From: Ruben Safir ru...@mrbrklyn.com Subject: Re: MySQL dying? where were you in 2000, youngerman? Busy writing WAP backends powered out of MySQL and Oracle, if I remember correctly :-) But, indeed, not on this list; and if you were here back then I may have

Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

- Original Message - From: Zbigniew zbigniew2...@gmail.com Subject: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access? What about using ENUMs? They have nearly the performance of INTEGERs, but you don't have to maintain a string mapping in your programming

Re: Which replication solution should I choose?

- Original Message - From: Walter Heck walterh...@olindata.com Subject: Re: Which replication solution should I choose? If you happen to be at the Percona Live conference next week in London I'm speaking about Galera in a high performance setup as well. Ooo, very interested,

Re: Need a short directive

- Original Message - From: Trianon 33 triano...@gmail.com Subject: Need a short directive Values from yearanddate look like this: 2013-12-11 00:00:00. I want to That's only a display format; internally it's an integer (well, presumably a struct time_t) counting the seconds since

Possible bug with event and delete...limit ?

Hey list, I noticed a table that was trying to fill the disk before the weekend, so I quickly set up an event to gradually clean it out. Yesterday, however, I returned to find 400+ jobs in state updating. I disabled the event, but the jobs hadn't cleared up today, so I had to kill them. I

Re: converting numeric to date-time?

- Original Message - From: Jan Steinman j...@ecoreality.org Subject: RE: converting numeric to date-time? I don't think the OP has a Unix timestamp. OP explicitly says epoch including milliseconds - so it's going to be three digits too long :-) divide by 1000; split off decimal;

Re: fragmentation in innodb index

Senior Oracle and MySQL DBA Corporate Trainer and Database Security Am I the only one worried about that line, then? -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Stored procedure debuggers

- Original Message - From: Larry Martell larry.mart...@gmail.com Subject: Stored procedure debuggers Does anyone know of any debuggers for stored procs that run on Mac and/or Linux? Not aware of native ones, but I seem to remember that I managed to get the one that occasionally

Re: sql syntax error

- Original Message - From: florent larose florent.lar...@hotmail.com Subject: sql syntax error near ''membres2' WHERE [...] FROM 'espace_membre2'.'membres2' WHERE You were on the right path - mysql is wibbly about quotes. Either remove the quotes entirely (

Re: Avoiding table scans...

- Original Message - From: Chris Knipe sav...@savage.za.org To: mysql@lists.mysql.com Sent: Thursday, 24 July, 2014 11:17:50 AM Subject: Avoiding table scans... mysql SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber '2118806';

Proxy / connected failover question

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

Re: Proxy / connected failover question

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

Re: Doubts tuning MySQL Percona Server 5.5

- Original Message - From: Antonio Fernández Pérez antoniofernan...@fabergroup.es Subject: Re: Doubts tuning MySQL Percona Server 5.5 ​I was checking MySQL performance ... Sometimes my database could be working slow. I have some queries that spend 9-10 seconds updating some columns

Re: Doubts tuning MySQL Percona Server 5.5

I'm missing something rather essential in your mail... are you actually experiencing performance problems, or are you just looking at variables and randomly deciding you don't like their value? Always remember the golden rule: if it ain't broken, don't fix it. On July 4, 2014 8:00:31 PM

Re: Optimizing InnoDB tables

- Original Message - From: Antonio Fernández Pérez antoniofernan...@fabergames.com Subject: Re: Optimizing InnoDB tables I would like to know, if is possible, why after execute an analyze table command on some fragmented table, after that, appears fragmented again. Simple question:

Re: Optimizing InnoDB tables

- Original Message - From: Antonio Fernández Pérez antoniofernan...@fabergames.com Subject: Re: Optimizing InnoDB tables I have enabled innodb_file_per_table (Its value is on). I don't have clear what I should to do ... Then all new tables will be created in their own tablespace

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

- Original Message - From: Johan De Meersman vegiv...@tuxera.be Subject: Re: SHOW FULL COLUMNS QUERIES hogging my CPU In any case, this is nothing that can be fixed on the database level. I may or may not have to swallow that :-p I've been hammering a munin plugin that graphs

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

- Original Message - From: Jatin Davey jasho...@cisco.com Subject: Re: SHOW FULL COLUMNS QUERIES hogging my CPU Certain part of our code uses DataNucleas while other parts of the code A data persistence product... there's your problem. Persisting objects into a relational database

Re: access problem for a particular table

- Original Message - From: Bernd Lentes bernd.len...@helmholtz-muenchen.de To: mysql@lists.mysql.com Sent: Wednesday, 28 May, 2014 10:10:33 AM Subject: access problem for a particular table we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't access one

Re: blob data types

- Original Message - From: Reindl Harald h.rei...@thelounge.net To: mysql@lists.mysql.com Sent: Monday, 26 May, 2014 11:56:26 AM Subject: Re: blob data types Am 26.05.2014 11:40, schrieb geetanjali mehra: I want to know where does MyISAM and innodb stores its BLOB data ; inside

Re: Case sensitivity

- Original Message - From: Reindl Harald h.rei...@thelounge.net Subject: Re: Case sensitivity ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; Purely from memory, doesn't that change the table but add the old setting to individual text columns? I

Re: Big innodb tables, how can I work with them?

- Original Message - From: Manuel Arostegui man...@tuenti.com Subject: Re: Big innodb tables, how can I work with them? noSQL/table sharding/partitioning/archiving. I keep wondering how people believe that NoSQL solutions magically don't need RAM to work. Nearly all of them slow

Re: Advices for work with big tables

- Original Message - From: Antonio Fernández Pérez antoniofernan...@fabergroup.es Subject: Advices for work with big tables Hi, I write to the list because I need your advices. I'm working with a database with some tables that have a lot of rows, for example I have a table with

Re: Performance boost by splitting up large table?

You've already had some good advice, but there's something much more simpler that will also give you a significant boost: a covering index. Simply put, the engine is smart enough to not bother with row lookups if everything you asked for is already in the index it was using. You'll need to

Re: Performance boost by splitting up large table?

- Original Message - From: Larry Martell larry.mart...@gmail.com Subject: Re: Performance boost by splitting up large table? This table is queried based on requests from the users. There are 10 different lookup columns they can specify, and they can provide any or That makes it

Re: mysql Access denied error

- Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the

Re: Things to be considered before/after the OS patch or upgrade

- Original Message - From: Dimitre Radoulov cichomit...@gmail.com Sent: Tuesday, 15 April, 2014 12:17:54 PM for major release upgrades - 5.x to 6.x - we'll use a different hosts. I would like to point out that where MySQL is concerned, the minor versions are a major upgrade -

  1   2   3   4   5   6   7   8   9   >