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, this is a bottom-pos
em snapshots will require
your database to be stopped and started, though.
/Johan
- Original Message -
> From: "Lars Nielsen"
> To: "MySql"
> Sent: Tuesday, 23 January, 2018 23:19:29
> Subject: Re: Examples of savepoints and transactions
> Den 22-01
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: http://lists.mysql.com/mysql
----
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
>
the "userspace", has lower
performance impact (parallelism) and cannot cause originating statements to
fail. Additionally, I would assume that some of these, if not all, can also log
towards an external target (file, network, ...).
/Johan
- Original Message -
> From: "
- 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: running *any* code as root fo
workaround into
mysqld_safe at https://github.com/meersjo/ansible-mysql-cve-2016-6662 .
/Johan
- Forwarded Message -
From: "Percona"
To: perc...@tuxera.be
Sent: Wednesday, 14 September, 2016 00:42:18
Subject: Update to Percona CVE-2016-6662 Vulnerability Communication
Earlier yes
l Harald"
> To: "MySql"
> 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 -
>>> From: "Ryan Coleman"
>>> Subject: Re:
- 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
> on the old one away and he
- 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 you were using som
- 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 contribution been, outside of in
- 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 mail
confirms, that that
- 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 an event from Coordinator
1
- 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 unreasonable, especially given
- 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 table names you're
- 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 names? Or it has to be
- 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 are dedicated operators
maintains the check_mysql_health nagios plug-in, is
currently re-factoring the code and has a poll open about whether to change the
logic behind the query cache hit rate, and to what. The poll (and check) are at
https://labs.consol.de/nagios/check_mysql_health/ .
/Johan
- Original Message --
e high - if it's close to 1, it may mean you spend more time
inserting and clearing than you save by the occasional cache hit.
So, my suggestion would be to certainly use the latter option for the
check_mysql_health check; but it may be useful in some scenarios to have a
separate check fo
- 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 versions support ex
'I have not counted this product yet' (count
IS NULL).
/Johan
- Original Message -
> From: "lejeczek"
> To: "MySql"
> Sent: Friday, 8 July, 2016 14:27:45
> Subject: find any row with NULL
> hi there,
>
> I've been searching the va
- 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 | Alanama | distrik | 20
> 2 | US
> 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 a connection to
> another dat
r configuration; in that case you'll just treat the slave as the new
primary after failover; and will manually reconfigure the broken master to be a
slave (and adapt the loadbalancer config accordingly) as repair.
There does exist software that can do those reconfigurations by itself, M
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 :-)
- Orig
- 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 should reconstruct th
- 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: --defaults-file=c:\sql\dump.cnf .
I think the
ty is an approximation
> (or calculation. It depends on your storage engine) of how many unique
> values there are in the index.
On a related note, are there any plans (and could you offer a rough timeframe?)
to include bitmap indices in MySQL?
Thanks,
Johan
--
Unhappiness is discouraged
my particular environment, we have quite a few of these generic databases;
although from similar design ideology, they are also accessed only through
their own REST interfaces, and not directly.
/Johan
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
MySQL General
- 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 semantics, and I'd guess you're used t
- Original Message -
> From: "Richard Reina"
> 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 think it would
- Original Message -
> From: "geetanjali mehra"
> 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 maximum key lenght for MyI
- Original Message -
> From: "Camilo Vieira"
> 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 that are, imo, false m
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 l
> From: "Singer X.J. Wang"
> 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 the slides from
- Original Message -
> From: "Tomasz Chmielewski"
>> 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 s
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 out
h, as it wasn't important to me
at the time. I'll be monitoring this thread with interest :-)
- Original Message -
> From: "Johan De Meersman"
> To: "Pothanaboyina Trimurthy"
> Cc: "Martin Mueller" , "MySql"
>
> Sent: Monday
That sounds logical. I have, however, also had Martin's experience where
create_time seemed improbable;
- Original Message -
> From: "Pothanaboyina Trimurthy"
> To: "Martin Mueller"
> Cc: "MySql"
> Sent: Friday, 1 May, 2015 17:13:27
> Subject: Re: create_time
> If you run any DDL (ad
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
- Original Message -
> From: "Thufir"
> 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 wha
- Original Message -
> From: "Lucio Chiappetti"
>
> 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 the
> output in a
- Original Message -
> From: "Thufir"
> 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 of
inflexions :-
- Original Message -
> From: "Rafael Ribeiro"
> 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 :-) What error mess
- Original Message -
> From: "Thufir"
> 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 referencing sites
- Original Message -
> From: "Emil Oppeln-Bronikowski"
> 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 knight in
y your
adress or domain is not accepted by their mailserver, too?
/johan
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
- Original Message -
> From: "Phil"
> 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 between compariso
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"
> To: "MySql"
> Sent: Wednesday, 4 March, 2015 12:39:01
> Subject: Re: Users and Groups
> When several years
- Original Message -
> From: "Reindl Harald"
> 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 db etc but
>
- Original Message -
> From: "Jay Ess"
> 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 resultset out of i
- Original Message -
> From: "thufir"
> 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 more than just
...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 no
- Original Message -
> From: "Sayth Renshaw"
> 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 your XML and how mu
- Original Message -
> From: "yoku ts."
> 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, too.
> Mayb
- Original Message -
> From: "Christophe"
> 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 corrected with kitt
If you *must*
re-query time after time, do a speed comparison with and without prepared
statements; otherwise do go for the fetch_next loop.
Now, you've got documentation to read, I believe. Off you go :-)
/johan
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
- Original Message -
> From: "Sándor Halász"
> 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 often
- Original Message -
> From: "Sebastien FLAESCH"
> 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 other
- Original Message -
> From: "Johan De Meersman"
> 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
> availabl
- Original Message -
> From: "Jigal van Hemert"
> 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 central sour
- Original Message -
> From: "Sándor Halász"
> 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 to maili
- Original Message -
> From: "Sándor Halász"
> 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 visit th
7; a
sample of one, of course :-)
One thing to keep in mind for your particular usage, though, is that consumer
drives, and, especially, laptop drives, are not designed for 24/7 operation. I
would strongly recommend to go for SSD storage even if you don't need the
speed, as those at least
- Original Message -
> From: "Jan Steinman"
> 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; but usually they
- Original Message -
> From: "Shawn Green"
> 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 - but never quite
u sent to continue, on the
off chance that it's something that it does not damage, or only does things
that you can reverse afterwards. If you really want to kill that query, you
always have the option of logging into the server and shooting it yourself.
/johan
--
Unhappiness
- Original Message -
> From: "peter brawley"
> 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 benefit I see on StackO
- Original Message -
> From: "Ruben Safir"
> 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 severly misjudged
- Original Message -
> From: "Ruben Safir"
> 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 2011 tryin
- Original Message -
> From: "Rodrigo Ferreira"
> 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 eventually disconecte
> From: "Walter Heck"
> 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:
> ht
- Original Message -
> From: "Ruben Safir"
> 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 dead, unsubscri
- Original Message -
> From: "Zbigniew"
> 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 logic.
>
> But a
- Original Message -
> From: "Walter Heck"
> 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, especially if you're
- Original Message -
> From: "Trianon 33"
> 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 epoch. Not especi
kill them.
I noticed, however, that the LIMIT statement I specified in the event wasn't
present in the actual queries... Could that be a parser bug, or does the limit
simply not show up in the process lists? Has anyone seen this before ?
This is 5.5.30-1.1-log on Debian 64-bit.
Tha
- Original Message -
> From: "Jan Steinman"
> 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; from_unixtime(
> 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:htt
- Original Message -
> From: "Larry Martell"
> 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 gets advertised on t
k is Alt-Gr
plus the rightmost key (right next to return) on the middle row. Enjoy
spraining your fingers :-p
/johan
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
- Original Message -
> From: "Chris Knipe"
> 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';
You're putti
end is gone, it can simply establish a
new connection to the same or a different host without having to break the
connection with the client.
It's a simple idea that works extremely well with stateless protocols like
HTTP; but for a stateful procotol like MySQL it's rather more complex
mply reconnect and go on with business, so it doesn't
even *have* to take improbably loads.
Thank you for any and all suggestions and information,
Johan
--
What's tiny and yellow and very, very dangerous?
A canary with the root password.
The best advice I can give you is to set up Munin, Cacti or another tool to
monitor server status and performance over time; that way you will get a
baseline for what's "normal"; see any behaviour that deviates from the
baseline, *and* can meaningfully see the impact over time of any changes you
make.
/johan
--
Unhappiness is discouraged and will be corrected with kitten pictures.
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 CEST,
- Original Message -
> From: "Antonio Fernández Pérez"
> 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: why do you believe this i
- Original Message -
> From: "Antonio Fernández Pérez"
> 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 now. It's easy to
convert a
- Original Message -
> From: "Johan De Meersman"
> 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 th
- Original Message -
> From: "Jatin Davey"
> 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 is like fitt
- Original Message -
> From: "Bernd Lentes"
> 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 particular table.
> Automysqlb
- Original Message -
> From: "Reindl Harald"
> 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
> > the tabl
- Original Message -
> From: "Reindl Harald"
> 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 seem to recall run
- Original Message -
> From: "Manuel Arostegui"
> 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 down to a craw
- Original Message -
> From: "Antonio Fernández Pérez"
> 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 8GB of data.
>
> H
- Original Message -
> From: "Larry Martell"
> 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 rather more of a both
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
kee
- Original Message -
> From: "Reindl Harald"
>
> 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 second scenario, I
- Original Message -
> From: "Dimitre Radoulov"
> 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 - 5.0->5.1, 5.1->5.5 a
1 - 100 of 983 matches
Mail list logo