On Fri, Jul 16, 2010 at 7:35 PM, Paul McCullagh paul.mccull...@online.dewrote:
Hi Johan,
I understand what you are saying, but this is certainly not the
announcement of a commercial product.
It is also not spam, because the announcement of the release of a open
source MySQL Storage Engine
On Mon, Aug 2, 2010 at 8:35 PM, Johnny Withers joh...@pixelated.net wrote:
Now when i run the same show table status command, the comment field says:
InnoDB free: 6144 kB
Is that telling me that I only have 6MB of storage left even though I
increased the table space by 8GB?
I seem to
You don't want to mess with OOM too much - you risk it killing off other
useful/critical things, like SSH daemons, the Apache root, what have you.
Add more memory to the box or split the webserver off to another system, I'd
say.
2010/8/5 Евгений Килимчук ekilimc...@gmail.com
I can't write my
1. Make sure it works
2. Make sure it's secure
3. Make sure you have backups
On Mon, Aug 16, 2010 at 7:58 AM, Kranthi kranthi_penty...@iicindia.comwrote:
Hi all,
Please send sample mysql best practice document.
Thanks Regards,
Kranthi kiran
--
Bier met grenadyn
Is
You may want to split of your or conditions into a separate query, and use
UNION.
On Tue, Aug 17, 2010 at 11:22 AM, Влад Р vul...@gmail.com wrote:
The main problem - if add in Join on `OR`-condition, select become
VERY slow. I realy
have to use this condition.
--
Only if you want to see duplicate rows :-)
On Tue, Aug 17, 2010 at 2:21 PM, Ananda Kumar anan...@gmail.com wrote:
use UNION ALL ..instead of UNION for better performance...
On Tue, Aug 17, 2010 at 5:01 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
You may want to split of your
2010/8/20 Elim PDT e...@pdtnetworks.net
There are so many versions of 5.1, Is there some review or recommendations
for a stable one? thanks
As far as I know, 5.1 is considered a stable branch, and you can safely take
the most recent release as it should contain mostly fixes.
--
Bier met
If you're looking at the string 10,23,15,10 in a single field, you'll have
to do it the hard way. If you have an int field, and four rows with those
values, you can do a group by that field and select the count() of it.
On Tue, Aug 24, 2010 at 3:53 PM, Tompkins Neil neil.tompk...@googlemail.com
are held with a varchar field.
On Tue, Aug 24, 2010 at 2:56 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
If you're looking at the string 10,23,15,10 in a single field, you'll
have to do it the hard way. If you have an int field, and four rows with
those values, you can do a group
it in separate tables so that it can easily be computed.
On Tue, Aug 24, 2010 at 3:01 PM, Johan De Meersman vegiv...@tuxera.bewrote:
Then you're pretty much on your own, I'm afraid. Not a very good way to
store data :-)
You could maybe build a stored procedure, or do it in the app; but it's
gonna
Is the code you use to get the data out in the same charset as the code you
use to put the data in ? Both should ideally also match your database
setting. Have you tried explicitly setting the connection to UTF8 ?
Just swinging in the dark, here, really.
On Sat, Aug 28, 2010 at 8:04 AM, Andreas
1. Find out what is slow
2. Fix it
3. GOTO 1
On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran
kranthikiran@gmail.comwrote:
Hi All,
In performance tunning what are the steps can follow,please help
me
Thanks Regards,
Kranthi kiran
--
Bier met grenadyn
Is als mosterd by den
I suspect he is talking about the Temp Tablespace concept from Oracle, which
is different from a temporary table or a memory table.
MySQL will allocate a memory table for sort operation and the like, up until
that table exceeds a preset limit, at which point it will automatically (and
costly !)
From the mysqldump manpage, on the -T option:
Note
This option should be used only when mysqldump is run on the same machine
as the mysqld server. You must have the FILE privilege, and the server must
have permission to write files in the directory that you specify.
In other words, you've
On Thu, Sep 2, 2010 at 1:10 PM, Jangita jang...@jangita.com wrote:
Hi Guys,
We have a system that has been running along nicely for the past three
months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal
system; slightly 2 hits per minute but growing exponentally as customers
On Thu, Sep 2, 2010 at 5:12 PM, Neil Aggarwal n...@jammconsulting.comwrote:
If server 1 and 2 are on the same local network, I would use
a cluster.
As in NDB ? I've no personal experience with it - save for a sales talk by
MySQL guys some years back where we decided it was useless to us - but
On Thu, Sep 2, 2010 at 5:51 PM, a.sm...@ukgrid.net wrote:
Quoting Jangita jang...@jangita.com:
Simply put: I want a solution that ensures that server 2 has all the data
at server 1 at any point in time; say server 1 suddenly fell into a pond :)
. I wouldnt want to open server 2 and find the
No, don't worry. Default values are only applied when you create a new
object without specifying a value for that setting.
All your MyISAM tables will keep working fine - although finding a good
tuning balance between the two engines might be some work - but every new
table you create, also in
Correct. To verify this, simply create a select with the same structure as
your delete - the execution plan will be similar.
I do not believe limit will help you, however, as it is only applied after
execution, when the full dataset is known.
On Thu, Sep 9, 2010 at 8:06 AM, Ananda Kumar
On Thu, Sep 9, 2010 at 4:12 PM, Nunzio Daveri nunziodav...@yahoo.comwrote:
So.. I am trying to mimic replaying production like queries so joins, temp
tables etc... are stuff I am trying to test as well. Just doing a dump and
import is no more than export and importing, I also want to test
And still, nobody answered the man's actual question: can a Linux mysqld
read mac datafiles ?
I'd say make a copy and try it. As long as you always keep a copy of the
original files, you're not risking anything. You might run into things
varying from incompatible MySQL versions to different
On Fri, Sep 10, 2010 at 1:56 PM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
He already did! Those are the logs he needs to replay. He has the logs
already but needs tools to extract the commands and repeat them as a load
test.
Do you have any techniques you can share?
Alas, no. I
On Sun, Sep 12, 2010 at 9:45 PM, Kiss Dániel n...@dinagon.com wrote:
offset + increment thingy is good if you know in advance that you'll have a
limited number of servers. But if you have no idea that you will have 2,
20,
or 200 servers in your array in the future, you just can't pick an
off from the
other
databases. The primary purpose is not load distribution.
On Mon, Sep 13, 2010 at 12:03 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
On Sun, Sep 12, 2010 at 9:45 PM, Kiss Dániel n...@dinagon.com wrote:
offset + increment thingy is good if you know in advance
On Mon, Sep 13, 2010 at 4:32 PM, Steve Staples sstap...@mnsi.net wrote:
From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.
Are there any other ways?
On Mon, Sep 13, 2010 at 8:59 PM, Johnny Withers joh...@pixelated.netwrote:
This sounds like a good job for a 'NoSQL' system. Maybe?
I can't help but blink at that. How exactly is NoSQL going to fix issues
that are related to topology, not inherent SQL limitations ? Which
particular
On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent dae...@daevid.com wrote:
You do know you can use ssh tunnels and such to connect to your server from
your desktop right? I do it all day long. It's pretty easy to do and built
in to these programs.
You can't multi-jump, though. Yes, that's
On Wed, Sep 15, 2010 at 3:39 PM, george larson george.g.lar...@gmail.comwrote:
I commonly set up a tunnel to the SSH server at the office and then
another tunnel from that server to my development rig, so I can run
MySQL WB at home on my database at work. Is that what you mean?
Pretty much,
On Thu, Sep 16, 2010 at 2:35 PM, Todd Lyons tly...@ivenue.com wrote:
On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
I commonly set up a tunnel to the SSH server at the office and then
another tunnel from that server to my development rig, so I can run
MySQL
On Fri, Sep 17, 2010 at 3:51 AM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
So if 10 rows of A match your conditions, 1 row from B match your
conditions, and 10 rows from C match your conditions, then this query
produces 10*1*10 total row combinations.
Umm. It's friday, so I may
This is a correct description of behaviour. Did you have a question ? :-)
On Fri, Sep 17, 2010 at 5:52 AM, win.a win@gmail.com wrote:
I fond my mysql db os time was not correct so i sync with ntpdate
,when testing my app which depend on the date was not the current os
time .After
Simply base64-encode the returned binary string before offering it to your
client.
On Fri, Sep 17, 2010 at 1:22 PM, Tompkins Neil neil.tompk...@googlemail.com
wrote:
Hi,
I need to encrypt a string like 'hello world', using a passkey. But I also
need to be able to decrypt the encrypted
Not the way he does it :-)
If you use --databases, mysqldump will add create database and use
database statements. if you specify the db without that parameter, it
won't.
On Mon, Sep 20, 2010 at 11:34 AM, Ananda Kumar anan...@gmail.com wrote:
The dump file has to be edited to replace old db
:19 PM, Johan De Meersman vegiv...@tuxera.bewrote:
Not the way he does it :-)
If you use --databases, mysqldump will add create database and use
database statements. if you specify the db without that parameter, it
won't.
On Mon, Sep 20, 2010 at 11:34 AM, Ananda Kumar anan...@gmail.com wrote
On Mon, Sep 20, 2010 at 12:48 PM, Uwe Brauer o...@mat.ucm.es wrote:
On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman
vegiv...@tuxera.be wrote:
He did suggest doing mysqladmin create :-p
The only thing which is not clear to me is whether
db_org and db_clone
should have the same
On Tue, Sep 21, 2010 at 12:49 PM, Willy Mularto sangpr...@gmail.com wrote:
Hi,
I got this result on InnoDB Buffer Pool Status:
Free pages 1
Dirty pages 2,040
Pages containing data 31,359
Pages to be flushed 457,083,205
Busy pages 1,408
Read requests 31,348,288,497
Yep. There's rather extensive documentation on http://www.mysql.com. You'll
need to read it and compare to the metrics you're taking off your own
server, draw conclusions and apply them to your setup.
You *are* pulling metrics, aren't you, and not hoping for some magic wand to
make it all happen
On Tue, Sep 21, 2010 at 4:03 PM, a.sm...@ukgrid.net wrote:
Quoting Johan De Meersman vegiv...@tuxera.be:
Your raid controller is lying to you - you can't have RAID10 with just
two
disks :-p Don't worry about that, though - it's a good enough config.
Good enough? If he is genuinely
Also, mailing list doesn't want to distribute attachments :-) Here's a link
to the metrics view I was on about earlier:
http://www.tuxera.be/mysqlstats.zip
On Tue, Sep 21, 2010 at 4:08 PM, Johan De Meersman vegiv...@tuxera.bewrote:
On Tue, Sep 21, 2010 at 4:03 PM, a.sm...@ukgrid.net wrote
If there are two, you will return two.
On Tue, Sep 21, 2010 at 5:33 PM, Tompkins Neil neil.tompk...@googlemail.com
wrote:
Hi
With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how can I
return two records for the record_id 3 ? Is it possible ?
Cheers
Neil
--
Bier met
of 3
only exists once in the table my_table. However, because 3 exists twice
within (3,4,5,6,7,3), I want it to return two records for record_id 3.
Is it possible ?
Cheers
Neil
On Tue, Sep 21, 2010 at 4:40 PM, Johan De Meersman vegiv...@tuxera.bewrote:
If there are two, you will return
On Thu, Sep 23, 2010 at 12:39 AM, Camilo Uribe camilo.ur...@gmail.comwrote:
On Fri, Jul 9, 2010 at 12:03 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
This will mostly depend on your OS, really. Assuming you're running a
64-bit
flavour of *nix on that box, I don't think you have to worry
At a guess, because you use @team in an if statement before you actually
define it.
On Sun, Sep 26, 2010 at 12:35 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi,
I've the following query
SELECT teams_id AS teams_id ,SUM(rating) AS total_team_rating FROM (SELECT
teams_id
, but still the same ?
Cheers
Neil
On Mon, Sep 27, 2010 at 7:58 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
At a guess, because you use @team in an if statement before you actually
define it.
On Sun, Sep 26, 2010 at 12:35 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi
Both have benefits.
Application level:
- data is encrypted during transmit, too
- processing is offloaded from your hard-to-scale database server
- decrypt keys don't pass your database, so dba or other users can't peek
DB
- Guaranteed consistent implementation regardless of client
On Tue, Sep 28, 2010 at 10:23 AM, Vokern vok...@gmail.com wrote:
2010/9/28 Jangita jang...@jangita.com:
I do not think there is anything wrong with having one huge file is
there?
We have one innodb file of 85GB on ext3.
In and of itself, there is no problem with that. You may, however,
On Mon, Sep 27, 2010 at 3:43 PM, Vikram A vikkiatb...@yahoo.in wrote:
Normally, If i need to store an integer value i have to define it as int,
If I
encrypt this, i must define its type as string of different size[it depend
upon
the encryption output] than its original size. It increases
That's a very good point, actually, as that will also immediately free the
space from tables you delete.
My instincts say that it's marginally slower, though; although honestly I
don't have any data to support that. Does anyone have benchmarks about that
?
On Tue, Sep 28, 2010 at 1:26 PM,
On Tue, Sep 28, 2010 at 1:46 PM, Vokern vok...@gmail.com wrote:
Can I upgrade to innodb_file_per_table smoothly?
When you activate it, the db will keep reading and using your existing
innodb datafiles. All new tables will be created using .ibd files.
Converting your existing tables is done
If Cal_NO is a recurring value, then yes, that is the way it should be done
in a relational schema.
Your index cardinality of 15.000 against 1.3 million rows is reasonable,
although not incredible; is your index cache large enough to acccomodate all
your indices ?
On Tue, Sep 28, 2010 at 5:02
On Tue, Sep 28, 2010 at 6:24 PM, Jan Steinman j...@bytesmiths.com wrote:
From: Jangita jang...@jangita.com
I do not think there is anything wrong with having one huge file is
there?
There is if you're doing incremental back-ups, in which case adding one
byte to that file costs you 50GB
Correct. I assume the thinking behind it, is that you use that kind of table
for huge amounts of inactive data, so it doesn't matter if your selects are
a bit slower. Also, keep in mind that because it is a compressed file
format, you will be scanning much more data per physical read than with a
Simply activate the full log (log directive in my.cnf) - this will provide
you with logon, logoff and every command sent by every session.
Keep in mind that this is a LOT of data; so you want to keep this on a
separate set of spindles. It will also. obviously, make for some overhead,
but if your
I suggest you put your glasses on, then. Getting of that horse might help,
too.
default-time-zone='*timezone*'
If you have the
SUPERhttp://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_superprivilege,
you can set the global server time zone value at runtime with
this
On Mon, Oct 4, 2010 at 3:03 AM, monloi perez mlp_fol...@yahoo.com wrote:
1) While inserting and connection lost, what will happen? Is the query
going to be there forever?
No. Depending on the timing of the connection loss, the statement may
complete or be rolled back. it will not just
convert to unixtime, convert your interval to unixtime, creatively combine
with integer division to get a base number for each period, group by that
and count().
2010/10/6 Pascual Strømsnæs pasc...@egoria.no
Hi!
How would one go about to construct a query that counts items within an
Two people already who suggested a text-based approach vs. my numeric
approach.
Analysing, my method takes a single function call per record (to_unixtime);
Travis' takes 4 (concat, date_format, truncate, minute) and Hank's 3
(concate, left, date_format).
Someone feel like benchmarking ? :-D
)%6) as dtime ,count(*)
from table
group by dhour,dtime;
-Hank
On Wed, Oct 6, 2010 at 4:22 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
Two people already who suggested a text-based approach vs. my numeric
approach.
Analysing, my method takes a single function call per record
Do keep in mind that what you get there is going to be useless if your
database doesn't already contain all the previous data. The inserts will
work, of course, but any data modification may fail because the rows you
modify aren't there when you restore.
Make sure you know exactly what you want
Part of your answer is the offset column, which seems to be relative to the
abbreviation used. This implies, to me, that each particular abbreviation
has it's own way of specifying the starting point of the time. Added is
the DST flag, which (probably) tells you that your app needs to keep
The root cause is another query that has tables locked that your locked
queries want. Behind that may be, for example, an inefficient but
often-executed query, high I/O concurrency that has a cumulative slowing
effect, or maybe simply a long-running update that might be better scheduled
during the
On Thu, Oct 14, 2010 at 9:19 AM, monloi perez mlp_fol...@yahoo.com wrote:
Does this happen if your table is InnoDB?
That depends on the type of lock. If no lock type is specified, InnDB will
prefer row locks, while MyISAM will do table locks.
That may help, unless all your queries are trying
On Tue, Oct 19, 2010 at 9:48 AM, short cutter shortcut...@126.com wrote:
2010/10/18 Brent Clark brentgclarkl...@gmail.com:
Hiya
I run MySQL Master - Master Replication. Ive had an interesting situation
whereby I failed over using heartbeat but whats is interesting is that
via
the
That's pretty much it, indeed. You need to make absolutely sure that no more
connections can be made to the old, broken master, though - even if you have
to physically pull the network or power cable. Failover services refer to
this as STONITH: Shoot The Other Node In The Head.
Don't think but it
On Tue, Oct 19, 2010 at 1:03 PM, Carl c...@etrak-plus.com wrote:
Johan,
You state that master - master is not reliable in dual active environments.
I am in the process of setting up just such an environment (moderate active
on the primary server, lighter activity on the other server.) Do
On Wed, Oct 20, 2010 at 1:37 AM, Walter Heck - OlinData.com
li...@olindata.com wrote:
To Clarify this a bit: You can only reliably do writes to one server.
Also not *entirely* true: nothing prevents you from using the two masters
for distinct databases - or even tables - and just having them
Hmm. You might be able to hack this up using the if() function, but it's not
gonna be a beauty to look at, and possibly not terribly performant, either.
You may need to look at external data query tools - I think a number of
fulltext search tools provide match percentages in their results.
On
Changes to global variables will indeed not affect the instantiated local
session variables. You can, however, also explicitly change those by using
set local *variable* - that should eliminate the need for most reconnects.
On Sat, Oct 23, 2010 at 7:19 PM, Sander de Bruijne
Regardless of that, it would be nice to know what the parameters are that
cause this slowdown - some people may be stuck with the default version -
companies with a support contract come to mind.
On Sat, Oct 23, 2010 at 10:46 AM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi Willy,
The idea of a foreign key is that is is, well, a *foreign key* :-) It's
meant to match up data that is in one table with data that is in another
table, and a constant obviously isn't data in your table. To be precise,
what you specify in your constraint are not even fields, but *indices* - and
a
On Mon, Oct 25, 2010 at 6:25 AM, mos mo...@fastmail.fm wrote:
At 06:12 AM 10/24/2010, you wrote:
Regardless of that, it would be nice to know what the parameters are that
cause this slowdown - some people may be stuck with the default version -
companies with a support contract come to mind.
On Mon, Oct 25, 2010 at 7:56 AM, wroxdb wro...@gmail.com wrote:
Hello,
We are a company for gaming.
Our main db is mysql 5.1 installed on Linux.
Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four
disks).
Now we have the plan to replace the disks with SSD for better
I merely skimmed it, but your comment that you pay the query compilation
cost on every request suggests to me that you're not using prepared
statements. If you can, you should :-)
Also, MySQL *does* support SPs, from 5.0 onwards or something. You could
split into separate modules for pre- and
*shrug*
Enter the settings right the first time, or delete and recreate your
connector.
It'll probably get fixed, but this annoys me is not the same as this is a
critical bug and the people whom I pay nothing whatsoever should jump for
me. I can perfectly imagine them having more important
Out of your 4 gigabyte of memory, you allocate 2G to the innodb pool.
Assuming you're using mostly innoDB, that's good. Say there's also about
300M allocated to the OS - assuming a dedicated server; that leaves about
1.7G for non-InnoDB operations.
You have configured your server for 500
If your sites are busy with *writes*, you're kind of stuck. Replication
means that every write that happens on one side, also MUST happen on the
other side, so you win nothing. Well, you win a little delay on half of your
writes, which is, to most people, really a downside, not an upside.
Your
You may want to read that again, but with your glasses on :-)
Subscription means roughly commercial support. The (1) subscript means
Features only available in Commercial Editions, and is noted *only* for
Workbench SE, Enterprise Monitor, Enterprise Backup and Cluster Manager.
I will join you in
Standard Edition can be purchased online at
http://shop.mysql.com
Honestly, would a little googling kill you ?
On Thu, Nov 4, 2010 at 10:25 AM, Johan De Meersman vegiv...@tuxera.bewrote:
You may want to read that again, but with your glasses on :-)
Subscription means roughly commercial
On the other hand, they've only with this release managed to implement live
log shipping, among other things :-)
Both are bound to have pros and cons.
On Thu, Nov 4, 2010 at 2:17 PM, Carlos Mennens carlosw...@gmail.com wrote:
On Thu, Nov 4, 2010 at 5:13 AM, Christoph Boget
No, this is in and of itself safe. I didn't realise you could change the
InnoDB datafiles on the fly, though - thanks for that hint :-)
MySQL will never write the config file itself, so you're not at risk of
conflict there. You are at risk of putting something in the configfile which
messes up
Indexes typically only work on the left-hand-side. Rewrite as
select * from ip_test where startNum = 3061579775 and endNum = 3061579775;
Magic will happen.
2010/11/9 wroxdb wro...@gmail.com
Hello,
I have a query below:
mysql select * from ip_test where 3061579775 between startNum and
as our security point. We found
it
is giving better performance in all cases.
Can i have your advise please?
Thank you in advance!
Vikram A
From: Vikram A vikkiatb...@yahoo.in
To: Johan De Meersman vegiv...@tuxera.be
Cc: MY SQL Mailing list mysql
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz je...@gii.co.jp wrote:
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
The way I parse that, you're saying that there is a way to reattach ibd
files to another database ?
--
Bier met
From the OP:
I have a copy of the INNODB files for these two tables - is there a way
to extract the table contents from these files short of a full import?
I have to agree, that's quite ambiguous. Andy, is it a copy of the innoDB
datafiles, or a database dump that you have ?
In the latter
My quick suggestion for such a process would be to use SQL*NET formatting
commands to create a well-formed CSV file, which you then import into MySQL
using LOAD DATA INFILE.
I'm not aware of any Oracle-specific import tools in MySQL. If anything,
after the merger I would rather expect something
I suspect that that is because this is not a security list, but a general
help list. If you want those things, you'll get them from either your
vendor, bugtraq, or the mysql security-specific mailing list that
undoubtedly exists somewhere. Don't ask me where, though - I'm not on it
either :-)
On
I do hope you're not suggesting your database servers are publicly
accessible.
Mine are behind the firewall, completely blocked off from anything but the
application servers; and in most cases even behind a second firewall that
shields the backend network from the DMZ.
While any vulnerability is
On Wed, Nov 17, 2010 at 1:43 AM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
On 11/16/2010 15:14, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I
need
to pass the data to oracle, just so the data can be transfered.
I have
On Wed, Nov 17, 2010 at 2:26 PM, who.cat win@gmail.com wrote:
Maybe you can dump as a csv format,then create table all tables in oracle
.After that you can write a script program format the csv to oracle which
can be recognized.
MySQL's select into outfile may well be good enough to
Given that even spacing is important, it's a safe bet that it takes comments
into consideration, too.
Easily tested, though: grab one of the heaviest queries you have from your
slowlog, and execute with identical and different comments.
On Thu, Nov 18, 2010 at 8:31 AM, Daevid Vincent
On Thu, Nov 18, 2010 at 9:00 AM, andrew.2.mo...@nokia.com wrote:
I think you will probably find that the code you write isn't what MySQL
executes or stores in the cache.
it is indeed not quite what it executes, but as I understand it the QC index
is *exactly* the string you send (well, hashed
On Thu, Nov 18, 2010 at 2:54 PM, Sydney Puente sydneypue...@yahoo.com wrot
a mysqldump might do that job too, but the output from mysqldump
--compatible
was rejected by oracle.
Hmm. Interesting, you might want to file an issue about that - now that
MySQL is oracle-owned, you'd expect at
AND Substring(a.mob, 1, 4) = b.mob_series
There's what is probably the major problem with your query: your join
condition. Indices (you *do* have them on your join fields, don't you ?)
only work on the entire field you've indexed.
Function indices are not supported in MySQL, so you'll
On Mon, Nov 22, 2010 at 11:55 AM, Machiel Richards
machiel.richa...@gmail.com wrote:
In this event I will need to manually alter each table, and I am
concerned about the impact of this on the system performance.
That will indeed make for quite some locking time, depending on the size
That would work, yes.
You could also try to upgrade in place - the upgrade scripts *should* take
care of everything between those versions, I think. Make sure you have a
backup in any case :-)
On Mon, Nov 22, 2010 at 12:57 PM, Machiel Richards machi...@rdc.co.zawrote:
Hi All
Sorry
On Mon, Nov 22, 2010 at 2:08 PM, John Daisley daisleyj...@googlemail.comwrote:
The replicated database should not be accepting writes, if it is then you
haven't set it up correctly
*shrug*
I never bother. The slave is way too useful to fuck around with
optimisations and whatnot, reporting
Another option, if your data hasn't changed in the mean time (I know, rare
scenario) could be to set up a secondary instance from the same binaries and
changing only the datafile location and the port in the config,
re-importing, shutting both instances down and switching out the datafiles.
?
-Original Message-
*From*: Johan De Meersman
vegiv...@tuxera.bejohan%20de%20meersman%20%3cvegiv...@tuxera.be%3e
*To*: Machiel Richards
machi...@rdc.co.zamachiel%20richards%20%3cmachi...@rdc.co.za%3e
*Cc*: mysql mailing list
mysql@lists.mysql.commysql%20mailing%20list%20%3cmy
IIRC, localhost is seen by the client as a magic word to mean use the
UNIX socket, not 127.0.0.1.
So, yes, that would make the connection not show up in netstat :-)
On Tue, Nov 23, 2010 at 11:11 AM, Brent Clark brentgclarkl...@gmail.comwrote:
Hiya
Is there a difference if someone had to make
On Tue, Nov 23, 2010 at 7:55 PM, Jerry Schwartz je...@gii.co.jp wrote:
IIRC, localhost is seen by the client as a magic word to mean use the
UNIX socket, not 127.0.0.1.
[JS] IF it is enabled in my.cnf.
Hmm, didn't know that bit. What's the option called ?
--
Bier met grenadyn
Is als
201 - 300 of 809 matches
Mail list logo