- Original Message -
From: Mr. Left hdch...@163.com
Subject: Set session binlog_format need SUPER privileges???
When i want to set session binlog_format, I got error which means i should
have the SUPER privileges,
So i want to know, why i need such privileges just for the session
- Original Message -
From: geetanjali mehra mailtogeetanj...@gmail.com
Subject: Re: New to MySQL
use
rpm -i --replacefiles MySQL-server*.rpm
While that will work, it really shouldn't happen. I'm a Debian man myself, so I
don't know wether it's a problem with the packages or if you
- Original Message -
From: Asma rabe asma.r...@gmail.com
Subject: Install mysql server using RPM
rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm
rpm -i MySQL-client-5.6.16-1.el6.x86_64.rpm
I seem to recall that Oracle's Debian -server package included the clients
already. You may
- Original Message -
From: Iqbal Aroussi iq...@aroussi.ca
Subject: Re: New to MySQL
If you are new to MySQL and/or Linux.
Start with Ubuntu + MySQL.
Iqbal,
Please don't start distro wars on this list. Everyone chooses the platform he
or she wants.
Rabe,
The RPM bundle is a
- Original Message -
From: Asma rabe asma.r...@gmail.com
Subject: Re: New to MySQL
so,Is it recommended to install RPM bundle which has compatlibs, MySQL
serveretc rather than installing the server only?
The Server should suffice; the Bundle is merely a convenient way to
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
Subject: Mysql into outfile problem
- when we run an explain on the query it shows that it is
using indexes and the amount of rows it accesses is about 165000 rows
out of a 90mil+ rows table
Not
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
Subject: Re: Mysql into outfile problem
I have checked now and there is nothing in the Slow logs.
It may be turned off, then. Depending on your version you can change the
settings without having to restart the
___
| Nodes |
|---|
| id| ---
| [more fields] | |
| parent_id | --
|___|
And then you join the table with itself as needed. Do note that you'll need a
self-join for every level you query, and that every self-join incrementally
--databases, methinks.
- Original Message -
From: Daevid Vincent dae...@daevid.com
To: mysql@lists.mysql.com
Sent: Thursday, 21 November, 2013 10:44:39 PM
Subject: How do I mysqldump different database tables to the same .sql file?
I'm working on some code where I am trying to
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'GROUP BY t.AccountID,
I suspect your query has never
- Original Message -
From: Andrew Moore eroomy...@gmail.com
Subject: Re: binlog_format and pt-table-checksum?
pt-table-checksum will set binlog_format to statement for it's own
session.
To clarify, that means it sets it on the host where it's running; but the set
statement does not
On my phone now, but it smells of file-based sorting, making disk access the
bottleneck. Can you provide the explain?
Brad Heller b...@cloudability.com wrote:
Hey list, first time posting here so apologies if this is the wrong
forum
for this but I'm really out of options on how to solve this
|
+--+-++---+++-+---+-+---+
*Brad Heller *| Engineering Lead | Cloudability.com | 541-231-1514 |
Skype:
brad.heller | @bradhe http://www.twitter.com/bradhe |
@cloudabilityhttp://www.twitter.com/cloudability
On Sun, Aug 11, 2013 at 8:45 AM, Johan De Meersman
vegiv...@tuxera.be
wrote:
On my phone now, but it smells
performance boost.
Thanks
for your help!
*Brad Heller *| Engineering Lead | Cloudability.com | 541-231-1514 |
Skype:
brad.heller | @bradhe http://www.twitter.com/bradhe |
@cloudabilityhttp://www.twitter.com/cloudability
On Sun, Aug 11, 2013 at 1:32 PM, Johan De Meersman
vegiv...@tuxera.bewrote
Rick James rja...@yahoo-inc.com wrote:
When writing a random block, RAID-5 does not need to touch all the
drives, only the one with parity. Suitable XORs will update it
correctly. So, a write hits 2 drives, whether you have RAID-5 or -10.
Only if the other blocks happen to be in the cache,
Rick James rja...@yahoo-inc.com wrote:
For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is
optimal. (The default, 'cfq', is not as good.)
I should look into those again at some point. Do you have a brief word as to
why they're better?
A RAID controller with multiple drives
Hey Chris,
I'm afraid that this is not what databases are for, and the first thing you'll
likely run into is amount of concurrent connections.
This is typically something you should really tackle from a systems
perspective. Seek times are dramatically improved on SSD or similar storage -
-
From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of
Chris Knipe
Sent: Friday, July 26, 2013 12:30 AM
To: Johan De Meersman
Cc: mysql
Subject: Re: hypothetical question about data storage
Hi All,
Thanks for the responces, and I do concur. I was taking a stab
What's the MySQL error log have to say?
- Original Message -
From: Luis H. Forchesatto luisforchesa...@gmail.com
To: Johan De Meersman vegiv...@tuxera.be
Sent: Tuesday, 23 July, 2013 3:39:55 PM
Subject: Re: InnoDB problem.
Yep, I do backup of /home/mysql/ib* files too :D
What
-
From: Luis H. Forchesatto luisforchesa...@gmail.com
To: Johan De Meersman vegiv...@tuxera.be
Sent: Tuesday, 23 July, 2013 6:34:47 PM
Subject: Re: InnoDB problem.
The error log:
130723 10:04:23 [ERROR] Plugin 'InnoDB' init function returned error.
130723 10:04:23 [ERROR] Plugin 'InnoDB
- Original Message -
From: Luis H. Forchesatto luisforchesa...@gmail.com
Subject: InnoDB problem.
Permission and owner of the table files (.frm files) are ok, since it
recognizes MyISAM tables (they have the same permission).
Oops. You should always read the fine manual.
You took
Qcache_queries_in_cache
-- Meaning: Queries cached
(Com_select + Qcache_hits) / (Com_insert + Com_update + Com_delete +
Com_replace)
-- Meaning: Read to write ratio
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Monday, July 15, 2013 11:53 PM
To: shawn green
- Original Message -
From: J Gao j...@veecall.com
Subject: Transfer ENCRYPT password field to another server
So, is there a way to make the MySQL encrypted password string
2I6JOeg.JukJ. convert to MD5 hash $1$.?
Nope. Encrypt() calls unix crypt(), which is really
Shawn,
I can't help but wonder wether that first paragraph means there are concrete
plans to redo the qc?
shawn green shawn.l.gr...@oracle.com wrote:
Hello Egoitz,
On 7/15/2013 1:35 PM, Egoitz Aurrekoetxea wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 15/07/13 17:27, Reindl
- Original Message -
From: Egoitz Aurrekoetxea ego...@ramattack.net
Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?.
Yep, spot on. I tend to keep 200MB caches for some webservers, and that's
already considered fairly large.
The
- Original Message -
From: Hartmut Holzgraefe hart...@skysql.com
Subject: Re: Mysql cache issues???
can, and *will* ... see also http://dom.as/tech/query-cache-tuner/
Absolutes are never right.
The query cache is a very useful tool, even though it's implementation leaves
something
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
I would like to change the layout of my production database, I would
like to add a column to an existing table. As I think before the ALTER
TABLE statement all access to the database should be denied/ended, then the
Hmm. Can't sleep, but also can't work a mail client, apparently :-)
The thought was related to being in a transaction, but I tested it in the
meantime, and it's not that. Ignore :-)
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
To: Andy Wallace awall...@ihouseweb.com
You can't actually move innodb tables around until 5.6 where you have
transpotable tablespaces.
I suggest having a good hard look at pt-online-schema-change or whatsitcalled.
Jay Ess li...@netrogenic.com wrote:
On 2013-06-26 18:31, nixofortune wrote:
What would be the best way to convert BIG
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165 Gig to 70
Gig. I understand that during repair process MySQL creates temp file and
Oops, totally missed that, thanks.
Reindl Harald h.rei...@thelounge.net wrote:
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command
Mysql assigns its session IDs sequentially as they come in. I suspect, however,
that you're looking for session IDs as used by websites -generation of those is
entirely not a mysql issue, it is only a potential store for them.
Steven Siebert smsi...@gmail.com wrote:
Hello all,
I've looked
As a matter of dumb questions, what versions are the old and new mysqld; and
are they running on the same platform (OS, 32/64 bit, ...) ?
- Original Message -
From: Peter one2001...@yahoo.com
To: Reindl Harald h.rei...@thelounge.net, mysql@lists.mysql.com
Sent: Friday, 21 June, 2013
- Original Message -
From: Steven Siebert smsi...@gmail.com
Subject: Re: Session ID Generation
I am indeed looking for MySQL session ID's, not an HTTP session ID.
I'm doing a defense in depth audit and reviewing potential threats
to each remote connection - in this case session
Assuming Linux, check where it's listening using netstat -lptn.
lx lxlenovos...@gmail.com wrote:
hi all:
I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
mysql -h 192.168.27.72 -u root -p
the ERROR message is:
ERROR 2003 (HY000):
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
You can dynamically enable the Slow Query Log with long_query_time=0
Except when you have persistent connections on a stock mysqld. The recent
Percona ones do have a way to change the settings of existing connections,
- Original Message -
From: h...@tbbs.net
I wish to join two tables on likeness, not equality, of character
strings. Soundex does not work. I am using the Levenstein edit
distance, written in SQL, a very costly test, and I am in no
position to write it in C and link it to MySQL--and
- Original Message -
From: Rick James rja...@yahoo-inc.com
Subject: RE: Mysql server - which filesystem to choose? Is it really that
important nowadays?
ext does less well with simultaneous IOPs than xfs.
Possibly, but how much less (and which ext)? Without numbers that's not very
- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergames.com
Subject: Doubt with stored procedures
I have a doubt with stored procedures functionality. Is possible that
a stored procedure works with all databases form the server? I have
created a stored
- Original Message -
From: Bharani Kumar bharanikumariyer...@gmail.com
How to enable mail agent service in MYSQL. and what are the necessary
steps to send mail.
I suspect you're in the wrong place - the Mail Agent is an MS SQL service,
iirc. MySQL is a different database entirely,
- Original Message -
From: h...@tbbs.net
Subject: Re: error-log aging
man logrotate
Not Unix!
So get unix :-)
In any case, I take this to mean that this is not done within MySQL,
right?
Half and half - rename the file, then issue flush logs in mysql to close and
reopen the
- Original Message -
From: Lucky Wijaya luckyx_cool_...@yahoo.com
To: mysql@lists.mysql.com
Sent: Thursday, 4 April, 2013 10:51:50 AM
Subject: Re: Join query returning duplicate entries
Hi, sorry i tried to help but i hardly understand the use of join in
your query since the
- Original Message -
From: Ananda Kumar anan...@gmail.com
Subject: Re: Re: Retrieve most recent of multiple rows
select * from tab where anwer_timestamp in (select max(anwer_timestamp) from
tab where q_id in (select distinct q_id from tab) group by q_id);
This is entirely
- Original Message -
From: Norah Jones nh.jone...@gmail.com
Subject: Retrieve most recent of multiple rows
4 10Male3 1363091019
5 11Male3 1363091020
6 12Male3 1363091020
7 11
- Original Message -
From: Ananda Kumar anan...@gmail.com
Subject: Re: Retrieve most recent of multiple rows
select qid,max(atimestamp) from kkk where qid in (select distinct qid
from kkk) group by qid;
What use is that where statement? It just says to use all the rows in the
table.
- Original Message -
From: Neil Tompkins neil.tompk...@googlemail.com
Subject: MySQL Cluster Solution
I've used in the past MySQL Community Server 5.x. Everything is
fine, however I'm now wanting to implement a new High Availability solution
and am considering MySQL Cluster.
- Original Message -
From: Alexander Mordach amord...@wirelessanalytics.com
Subject: Recordset item becomes malformed / truncated
I’m working through a weird issue that revolves around LONGTEXT
fields in our DB. For some strange reason whenever we add any type of server
side
Hey list,
Another little conundrum, here; although I do have the feeling that I'm missing
something very obvious.
In a MySQL 5.5.24, I have these global variables:
| open_files_limit | 8520 |
| table_definition_cache | 4000 |
| table_open_cache | 4000 |
and these global statuses:
|
- Original Message -
From: Rick James rja...@yahoo-inc.com
Hey Rick,
Thanks for your thoughts.
* Smells like some huge LONGTEXTs were INSERTed, then DELETEd.
Perhaps just a single one of nearly 500M.
I considered that, too; but I can see the on-disk size grow over a period of a
- Original Message -
From: Adarsh Sharma eddy.ada...@gmail.com
Anyone has any idea about this.
Unless someone else here is using Graphite (I've never even heard of it, tbh) I
think this may be something for the Graphite support channels, instead.
--
Unhappiness is discouraged and
- Original Message -
From: ZhangFangXue zhangfang...@sogou-inc.com
well, the problem is that I used it like this:
prep_stmt = con - prepareStatement (INSERT INTO City (CityNumber)
The statement in your original mail used CityName, which sounds like it should
be a string. Fieldname
- Original Message -
From: ZhangFangXue zhangfang...@sogou-inc.com
Hi, when I use PreparedStatement in c++ connector, I find some
unexcepted error,
Well, first of all, you don't actually say what the error is that you're
seeing. This tends to be on the rather helpful side when
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
pt-table-checksum performs an online replication consistency check by
executing checksum queries on the master, which produces
different results on replicas that are inconsistent with the
master. - It should be
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
3) drop mysql and app databases;
4) restore them from backup;
Instead of dropping the DBs, simply restore to another database or server. That
will also allow you to perform a comparison using some graphical tool, or if
- Original Message -
From: Alex Keda ad...@lissyara.su
mysql SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 for the first
row and 0
- Original Message -
From: Alex Keda ad...@lissyara.su
To: mysql@lists.mysql.com
Sent: Friday, 15 February, 2013 12:16:18 PM
Subject: Re: MySQL 5.1: incorrect arithmetic calculation
sorry, I'm too many work... =)
Heh :-) I was thinking, why would that not be correct? It's exactly
Hey list,
I've got another peculiar thing going on :-) Let me give you a quick summary of
the situation first: we host a number of Drupal sites, each site and it's db on
separate VMs for reasons that are not important to this scenario. MySQL is
5.0.51a-24+lenny4-log (Debian); I don't have
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
does this also affect MyISAM or is the engine only a unloved child
since the switch to innodb as default engine?
Both, I suspect :-)
While MyISAM has certainly become the unloved child of late, from the point of
view
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
Seconds_Behind_Master: 364
So if I have rpl_semi_sync_master_timeout=5000 (5s) and semisync
why is it possible on the slave to fall behind the master?
Semi-sync only guarantees that the slave has *received* the
- Original Message -
From: Fred G bayespoker...@gmail.com
I googled around a bunch but couldn't find a good answer to this
question.
Then either your google fu isn't up to it, or you don't like the right answer
:-)
How do I open the ERD diagram I made in MySQL WorkBench 5.2CE,
I noted earlier that I'm currently in an Oracle tuning course, and to my
amusement, I just learned that Oracle has now also implemented an SQL result
cache :-)
--
What's tiny and yellow and very, very dangerous?
A canary with the root password.
- Original Message -
From: Akshay Suryavanshi akshay.suryavansh...@gmail.com
I am not sure, but if its a MyISAM table, it should be ordered by the
records insertion order, and in case of InnoDB it should be ordered
by the clustered index, not necessarily it should be a defined one.
- Original Message -
From: Akshay Suryavanshi akshay.suryavansh...@gmail.com
I was referring to a condition when there is no index on the tables,
not even primary keys.
If you have a lot of data in there, may I suggest you (temporarily) add a
unique index and benchmark both methods?
Hey you lot,
I'm currently being brainwashed with Oracle internals, so to keep a semblance
of sanity I'm throwing this out here :-)
I'd just like to thank the nice Percona people for successfully throwing
together the second edition of Percona Live London. It was, if anything, even
more
- Original Message -
From: Néstor rot...@gmail.com
I spoke to soon!!!
Here is the error about 1.5 hours after replication has started.
121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897'
for
Yes, that's what you get for running SQL_SLAVE_SKIP_COUNTER
- Original Message -
From: divesh kamra kamra.div...@gmail.com
slave-skip-errors=1062 --- in my.cnf and restart mysql
Really? Just like that? Without even knowing what it does or what the problem
is?
If you have replication errors, this kind of stuff is only going to break
- Original Message -
From: Anthony Pace anthony.p...@utoronto.ca
I have heard that due to Oracle taking over, the OS community is
shifting to other type of DB's .
I think the question has long been answered. However, out of curiosity (and
because they are the questions you should
- Original Message -
From: Andrés Tello mr.crip...@gmail.com
showed the usage of the index, then, some time later, it show, for
the same query, the usage of no index...
Look at the rows field. It's obvious that this table is live and rather on
the active side; and the data has
- Original Message -
From: Eric Bergen eric.ber...@gmail.com
Anger and OS religious arguments the real answer is that is just how
the option parsing code works. It doesn't always have to make sense.
Ye gods, it's an outbreak of common sense! Someone quarantine that man before
it
- Original Message -
From: Cabbar Duzayak cab...@gmail.com
Is there a way of looking at how mysql builds the query plan and
executes it for a given query? EXPLAIN is definitely a useful tool, but it is
not exact (shows approximations as far as I can see), furthermore I want
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
i do not trust any FS snapshot in this context
Why? I am completely unaware of any functional difference between an rsync and
a snapshot, everything else being equal.
--
Linux Bier Wanderung 2012, now also available
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
Am 17.10.2012 12:26, schrieb Johan De Meersman:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
i do not trust any FS snapshot in this context
Why? I am completely unaware of any
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
as far as i understodd the dameon was NOT down
a pretty sure indication was his log:
121016 10:40:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace
- Original Message -
From: Markus Falb markus.f...@fasel.at
With a low timeout the connection will be terminated sooner, but if
the application retries another connection is taken. I could have raised
the timeout with the same effect on the db side (1 process is waiting)
but maybe
- Original Message -
From: trimurthy skd.trimur...@gmail.com
hi sir even i also have a doubt regarding the connections. suppose if
there is an existing connection to the server with the user name
xxx and password if i send another request with the same user name
and password
- Original Message -
From: Markus Falb markus.f...@fasel.at
But why is retrying better than raising the value?
So what is better, adjusting the timeout or retrying application side
and why?
Well, raising the timeout would probably help, but may cause more concurrent
connections
- Original Message -
From: Anupam Karmarkar sb_akarmar...@yahoo.com
How to monitor individual session number of rows selected or updated
by sessions, number of bytes sent and reviewed by session in a given
time period, sessions connects runs command and then disconnects,
SHOW GLOBAL
- Original Message -
From: Singer Wang w...@singerwang.com
2) use a init-connect to log logins but that doesn't work for users
with super privileges as Keith mentioned below (thanks Keith for actually
trying to help!)
That is indeed quite the nifty trick. Thanks, Keith :-)
3)
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
this makes pretty no sense and is NOT the job of a RDBMS
implement it in your application / db-abstraction-layer
I notice no specification of what kind of users, so I'm assuming DB users.
There *is* such a thing: you
- Original Message -
From: Reindl Harald rei...@thelounge.net
it does not matter what kind of users
I'm happy for you that you still have all the answers anyone could ever want,
Harald. Regardless of having any background knowledge on the circumstance of
the question, even. You
- Original Message -
From: Rajeev Prasad rp.ne...@yahoo.com
I am considering using cryptic username for accessing and working on
a database on my MySQL installation. can anyone with experience
provide some suggestion pl?
Why would you make your life hard by using cryptic
- Original Message -
From: indrani gorti indrani.go...@gmail.com
Later I changed it to SET GLOBAL connect_timeout=60;
However, I still find that the query loses the connection to mysql
server after about 10 mins( 600.495 secs)
I see that the connect_time is 60 though.
If I recall
Yo,
Just a little heads-up in case anyone on the list uses Zmanda ZRM for MySQL:
There seems to be a bug in the cleanup script - I suspect it ignores the
per-backupset retention time and always uses the default one (but that is to be
confirmed yet by support).
The particular symptoms I'm
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
The particular symptoms I'm seeing, is that I've lost all my archives
from no-longer existing hosts. All hosts that are still being backed
up are fine, but the old archives are irrevocably lost, with the
exception
- Original Message -
From: Rick James rja...@yahoo-inc.com
There is a section on German Sharp-s in
http://mysql.rjweb.org/doc.php/charcoll
I agree with dirty.
Yes, seen it, but thank you. I'm not having character set issues, everything is
nicely UTF8. I'm merely running into the
- Original Message -
From: Raphael Bauduin rbli...@gmail.com
And the query_cache_min_res_unit is 4096 .
I'm not sure what the meaning of a block is. For the query cache size
What you calculated is the *average* block size, which is fairly useless :-)
The query cache is not
Hey,
We're upgrading MySQLs from 5.0 to 5.5, and running into the predictable
utf8_general_ci bu^Wwe-meant-to-do-that with german ß and similar characters.
The server swallowed the existing datafiles (thank god for that) so we're up
and running, but check table does whine about needing a full
- Original Message -
From: MID.night 693893...@qq.com
Like select * from table where name’A’ is just
The same as select * from table where name’B’.
The execution plan for both statements is indeed likely (but not guaranteed!)
to be the same. As far as I'm aware, though, MySQL
- Original Message -
From: Incarus Derp icarusd...@gmail.com
I have a complex field named Inventory in a table named Table1 that
can be different every time and is not guaranteed to contain what I need to
replace.
- Original Message -
From: Zhigang Zhang zzgang2...@gmail.com
I haven't read the source code of mysql ,but as I know ,the slave get
I think there is a timer to do this.
You have also not read the documentation, then. There is not. Replication is
continuous: the slave opens a
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
impossible with innodb
* dump
* delete
with myisam you could stop the server and move the databasedir
do not try this with innodb even with innodb_file_per_table!
Mmh, it should be pretty easy to write a small
Hey all,
Apologies for this mostly-off-topic mail, but I would like to draw interested
parties' attention to the yearly Linux Bier Wanderung - the Linux Beer Hike -
that I'm helping organise this year in Diksmuide, Belgium :-)
In brief, it's more of a holiday than it is a convention, with
- Original Message -
From: Gary Aitken my...@dreamchaser.org
surprising as the source did not enforce uniqueness. My problem is
the load data simply dies without indicating which line of the input
file was in error; the error message refers to line 3, which is not
even the SQL
- Original Message -
From: Rick James rja...@yahoo-inc.com
A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is
a brief discussion near the end.
Aha, also a very good bit of information, thank you.
- Original Message -
From: Shawn Green shawn.l.gr...@oracle.com
The other tactical move has been to jump 5.1 and upgrade directly
from 5.0 to 5.5 where that problem is resolved. Sure, it's a bit more
work (full dump/restore is highly recommended) but it avoids the collation
bug
- Original Message -
From: Joey L mjh2...@gmail.com
It sounds like you are all consultants.
Hehe. I'm not :-p
A lot are, though, because the combined technical knowledge on this list draws
in consultants looking for stuff, and having experienced consultants on the
list in turn
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
@Johan, you say I'm having trouble with clients aborting, but for
some reason they don't get logged.
Ah, it *did* start logging, now, and they come from multiple applications, too.
120612 12:19:09 [Warning] Aborted
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
Sigh. Because the application gets unstable when the connection falters, the
Unix boys have a kill-and-restart script in place - so any number of the
messages in the log may be due to that. Don't you love these complex
- Original Message -
From: Manivannan S. manivanna...@spanservices.com
Hi all,
[lots of data]
[slow reports]
[wooo NoSQL magic]
Not that I want to discourage you, but my standard first question is why do
you think NoSQL (let alone any specific product) is the right solution?
Yo,
I'm having trouble with clients aborting, but for some reason they don't get
logged.
The documentation at http://preview.tinyurl.com/27w9a4x clearly states If a
client successfully connects but later disconnects improperly or is terminated,
the server increments the Aborted_clients
101 - 200 of 809 matches
Mail list logo