ent for
MySQL with much better performance for any query optimiser related
things (which I'm pretty sure the nested joins are also part of).
--
Walter Heck
--
Check out my startup: Puppet training and consulting @ http://www.olindata.com
Follow @olindata on Twitter and/or 'Lik
1, 2012 at 18:01, Ralf W. wrote:
> build from source, or if you have .deb's use alien to create rpm's
>
> Best, ralf
>
> The problem with troubleshooting is that trouble shoots back.
> - Ralf Wiegand 1999
> ____
> From: Walter Heck
&g
this area, let's talk.
>
> Thanks
>
> -bruce
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
--
Walter Heck
--
Founder @ OlinData (http://olindata.com)
Co-founder @ Tribily (
python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64
> [root@ws-test Desktop]#
>
> Is there is a any detailed link to install it with dependencies.
>
> Thanks
>
> Walter Heck - OlinData.com wrote:
>
> You can try MySQL Workbench instead. It's FOSS t
Take a look at mmm for mysql. Easy and robust.
sent from my mobile phone
On Mar 22, 2011 12:07 PM, "Adarsh Sharma" wrote:
> Dear all,
>
> I researched on a link that describes that Mysql to use with scalr for
> fault-tolerance and high availability.
>
>
http://scottmartin.net/2009/07/11/creating-
d have much better advice that is not limited to this scope.
Other companies that do similar services include Percona, SkySQL and
FromDual to name a few :)
Have fun!
--
Walter Heck
Engineer @ Open Query (http://openquery.com)
Exceptional services for MariaDB and MySQL at a fixed budget
--
Follow @openquery on Twitter to stay up to date
for the quick response
>
> just to answer one of the things here, the load is mostly reads as
> writes only happen in batches every so often.
>
> When I am saying reads I am talking of up to 2000-5000 concurrently at
> any given time during high load.
--
Walter Heck
Engine
ave it in use at many of our
customers and wouldhave a much harder time managing them (and
failures) without it. Don't try to do failovers by hand, use MMM
instead.
Cheers,
--
Walter Heck
Engineer @ Open Query (http://openquery.com)
Exceptional services for MariaDB and MySQL at a fixed budget
, so it's a combination of
> stuff I read and an understanding of how things work - or don't.
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
Walter Heck
F
Unless you have a very good reason, you probably shouldn't go with
cluster in the first place. If it is HA you want to have, check out
other options like MMM for MySQL (http://mysql-mmm.org), DRBD
+Heartbeat and others.
Can you tell us a bit more about your goals/desires?
Walter Heck
Eng
hance?
Walter Heck
Engineer @ Open Query (http://openquery.com)
On Fri, Aug 6, 2010 at 02:43, Евгений Килимчук wrote:
> Hello!
>
> I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL use
> 75% (100% = 8GB) of memory. When cgi programs use more than 25% of memory
&g
VM's, you put your masters on different
physical machines
3. make sure that ARP traffic can flow freely between your machines.
EC2 doesn't support thatfor instance, so you'll either have to stick
with MMM 1 or patch MMM 2.
That's the most important part I think :)
Walter H
master-master is probably more like what you want to
achieve. For that, you can use a tool like MMM (http://mysql-mmm.org)
for instance, which will make your life much easier.
hope this helps!
===
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For lis
This kind of error usually means you ran out of disk space on your
tmp_dir drive.
Walter
On Mon, May 31, 2010 at 13:30, Manasi Save
wrote:
> Hi All,
>
> I am getting following error when I am trying to run one stored procedure on
> table which has 30 rows in it. Table Type id MyIsAM.
>
> ERR
regs and am trying to accomodate them. Our
> process requires that the card information is available on both servers so it
> is more a question of how than if.
>
> Thanks,
>
> Carl
> - Original Message -
> From: John Daisley
> To: Carl
> Cc: Walter Heck
sql.com/doc/refman/5.1/en/replication-solutions-ssl.html
cheers,
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Depending on the "seriousness" of your environment you can read the
changelogs and upgrade if you don't see any showstoppers. I have
hardly ever seen any problems with minor version upgrades of mysql.
Of course what Rob says is true, and it is a good idea to test things
out in a test environment fi
Ah, if you are single-user and updating really is a special occasion
that is completely in your control, you could even use compressed
MyISAM. That makes the table read-only though, but it does give
performance benefits:
http://dev.mysql.com/doc/refman/4.1/en/myisampack.html
good luck!
Walter
Take a look at haProxy. It can be combined with some scripts to
loadbalance mysql.
http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/
We use it at Open Query for a similar case.
Cheers,
Walter Heck
Engineer @ Open Query
http://openquery.com | http
That message usually means you ran out of space in your temp folder location.
cheers,
Walter Heck
--
Engineer @ Open Query
http://openquery.com | http://openquery.com/blog
On Thu, Mar 11, 2010 at 02:16, Zakai Kinan wrote:
> Is there a way to know exactly which table is corrupted with such
Bad idea. Sotring images is what a file system is for. Create an NFS
or other networked storage and store your images there. I don't see
the problem?
good luck,
Walter Heck
Engineer @ Open Query (http://openquery.com)
On Sat, Jan 30, 2010 at 18:54, Vikram A wrote:
> Hi,
>
> I
ght?
cheers,
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Random shot in the dark: I've seen this happen with some monitoring
tools that just check to see if the database is up.
Walter
On Wed, Dec 30, 2009 at 17:13, Jeetendra Ranjan
wrote:
> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increasing.
>
> What are reaso
take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html
Walter
On Fri, Nov 13, 2009 at 22:33, Johan De Meersman wrote:
> Hey all,
>
> I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
> workload based on standard Mysql full query log files. The i
Sudhir: do yourself a favr and split the blobs (=body) off to a
different table. Most fo the time bodies are not used, only when the
actual email needs to be shown. That means that you can keep the
frequently used fields together in a table for much quicker access.
cheers,
Walter
On Mon, Nov 2,
The GUI tools are horrible, and I probably wouldn't recommend them to
my worst enemy :)
Take a look at workbench. It is getting better with every release,
especially now that they added SSH tunneling into it. It is still
beta-status though, but it might work for you:
http://dev.mysql.com/downloads/
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles wrote:
> Questions Folks:
> (1) What do you about un-index searches. How can one report and monitor them?
> (2) What do you do with the slow-query log. Are there any utilities or
> s
Is there a specific reason you cannot do it with --skip-grant-table?
You should theoretically also be able to overwrite the files user.*
(there should be 3) in /var/lib/mysql/mysql/ (replace everything up to
and including teh first mysql in that path with your mysql data dir)
when the server is st
Hey Joe,
stop the server, start it with --skip-grant-tables, change the root
entry in mysql.user to your liking, and then restart the server
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joe wrote:
> We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
> nee
Check out replication.
On Sun, Aug 23, 2009 at 09:00, m. zamil wrote:
> Hello all,
> due to connection state, I need to keep an updated copy of the database on
> the client.
> How can I accomplish this?
> TIA
> Mos
--
Walter Heck, Engineer @ Open Query (http://openque
ion is are new rows
> added to the end of the table or will they randomly appear in my queries?
> If they are added to the end of the table, that is fine because I will pick
> them up in my final pass.
>
>
>
> I hope this is clear enough. If not, let me know and I will provide m
Imran Chaudhry
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com
>
>
--
Walter Heck, Engineer @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related technologies
Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
rue for InnoDB, not for MyISAM.
cheers,
--
Walter Heck, Engineer @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related technologies
Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
--
MyS
orks better for most of us:
http://www.artfulsoftware.com/infotree/queries.php ;)
Walter
--
Walter Heck, Engineer @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related technologies
Follow our blog at http://openquery.com/blog/
OurDelta: free enhan
r...@server[~]#
>
>
>
> Please advise what i can look for to fix this issue.
>
--
Walter Heck, Engineer @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related technologies
Follow our blog at http://openquery.com/blog/
OurDelta: free
--
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com
>
>
--
Walter Heck, Engineer @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL &am
gt; MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com
>
>
--
Walter Heck, Consultant @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related
using amazon S3 for that. Takes away your need for
administering a file server :)
Walter
--
Walter Heck, Consultant @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related technologies
Follow our blog at http://openquery.com/blog/
OurDelta: free enha
x27;
>
> Also, is there a way to just "wipe" all the grants so that I can add them
> one at a time and get rid of the cruft? Obviously this has a risk of blowing
> away the "root" user you're adding grants with. Does this also mean that if
> I ungrant my current user, does that change take effect immediatly and I
> won't be able to grant anymore? Or as long as I stay logged into the mysql
> shell I am "safe"?
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com
>
>
--
Walter Heck
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Try putting in a full existing pathname the server has write access to
as opposed to just a file name.
Walter Heck
On Sun, May 17, 2009 at 12:13 PM, mos wrote:
> I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
> using MySQL 5.1.30.
>
>
Blatantly assuming you are using PuTTy because of your question:
click-and-drag the mouse to select text. Then, press Shift+Ctrl+C to
copy to the clipboard. Press Shift+Ins to insert text back into the
console at the current carot-position.
Hope that helps..
Walter Heck
On Thu, May 14, 2009
Memory tables use hash indexes by default instead of b-tree. Try
changing the index, that should help significantly.
regards,
Walter
On Tue, Mar 31, 2009 at 6:47 PM, mos wrote:
> I'm using MySQL 5.1.30 and have several memory tables with indexes on the
> appropriate columns. When I try and join
Most likely something is wrong in your AMSCD2-relay-bin.index file.
Check this out:
http://forums.mysql.com/read.php?26,9390,242387#msg-242387
Walter Heck
On Thu, Mar 26, 2009 at 10:02 PM, Dirk Bremer wrote:
> Could not find
> first log file name in binary log index file
--
MySQL G
forgot the list, sorry :)
Walter Heck
-- Forwarded message --
From: Walter Heck - OlinData.com
Date: Thu, Mar 26, 2009 at 2:09 PM
Subject: Re: A problem relative ibdata1
To:
Cc: Riccardo Michele Filippone
Riccardo,
if you're ibdata1 file is growing fast, it means yo
://bugs.mysql.com/bug.php?id=2110
regards,
Walter Heck
On Tue, Mar 24, 2009 at 8:12 PM, Jesse wrote:
> I thought that the # of connections might be a problem at some point too.
> The last time this happened, there were a lot of connections. Right now,
> there are 19 connections.
>
Configuring and optimising a MySQL server is highly dependent on your usage
of it. The most important question for you now is probably: which storage
engines do you use? Based on that, you should start configuring MySQL to
assign memory to optimise the usage of each as good as possible.
Have fun!
Maybe this could help you:
http://blog.olindata.com/2008/11/testing-environment-setting-up-virtualbox-for-easy-vm/
http://blog.olindata.com/2009/02/testing-environment-installing-centos-52-on-virtualbox/
No need for a separate machine :)
regards,
Walter
OlinData: Professional services for MySQL
The 'AS' keyword for tables is just to give a table an alias by which
you can then use it in the rest of the query. In your case, when you
say 'book as b' in your query, it means that you can use b in places
where you need to refer to the book table. eg. 'b.id' refers to the
'id' field of the 'book
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock wrote:
> This is on a Mac OS X (v10.5.6) s
Sorry, sorry, sorry. that was supposed to be a forward to a colleague :(
Shame on me :(
On Tue, Feb 17, 2009 at 10:25 AM, Walter Heck wrote:
> Really? less then a week after we upgraded? Tough luck, haha :)
>
> Walter
>
> OlinData: Professional services for MySQL
> Su
Really? less then a week after we upgraded? Tough luck, haha :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Tue, Feb 17, 2009 at 9:21 AM, Joerg Bruehe wrote:
> Dear MySQL users,
>
> my sincere apologies for the noise -
> th
essional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Mon, Feb 16, 2009 at 7:48 AM, Jason Davis wrote:
>
>
> On Sun, Feb 15, 2009 at 4:07 PM, Walter Heck wrote:
>>
>> http://bugs.mysql.com/bug.php?id=26081
>
> Walter,
>
> Th
http://bugs.mysql.com/bug.php?id=26081
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Feb 15, 2009 at 9:43 PM, Martin Gainty wrote:
>
> Jason-
>
> can we see the schema and a few data rows for
> `soapware_charts_xmldocumentitems
It actually depends on your table types. With MyISAM it is no problem,
but with InnoDB you are looking at a dump-and-restore..
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 13, 2009 at 6:23 PM, Kurt Cypher wrote:
> O
I haven't looked into it in detail an don't have time right nw, but it
is also hardcoded in mysqld_safe. I have seen a case where it had to
be changed there to make it work. try that and please report back :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
h
/var/lib/mysql is the standard loation for the data_file_path, the
data directory. change it in my.cnf.
var/log is the default location for log files, also changeable in the
config file.
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.co
I think it would be good to think about scaling a bit more. What if
your requirements change from 500 application instances to 5000
instances? It is good to go with a solution now that can easily scale
over to multiple servers. Also, it would probably be good if you could
move databases over to oth
:
> Walter Heck writes:
>
>> Might be a bit late,
>
> Better late than never.
>
>> but on the naming issue: why not rename the tables on the old database
>> before doing the dump? that would save you from potentially messing
>> with your data due to parsing problems
You could bring it down, but the real question is if you really want
to do that? Making the buffers and caches smaller will reduce the
memory used, but it also reduces performance.
Could you tell us what you are hoping to use MySQL for and why you
wanna bring the memory usage down?
Walter
OlinDa
Might be a bit late, but on the naming issue: why not rename the
tables on the old database before doing the dump? that would save you
from potentially messing with your data due to parsing problems.
Just a thought :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Admini
> creating product tablesdone (273 sec).
Can you tell us what queries this code actually executes? This doesn't
tell us too much ;)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Jan 30, 2009 at 3:32 PM, lance raymond
OK
> mysql.time_zone_name OK
> Running 'mysql_fix_privilege_tables'...
> OK
>
> So, you want me to
> 1. Stop the server
> 2. Remove /var/lib/mysql/mysql right?
> 3. Restart the server
> Correct?
>
>
>
> Walter Heck wrote:
&g
3306 MySQL
> Community Server (GPL) by Remi
>
> So, how do I fix those errors about 'mysql.plugin' and mysql.db and
> mysql.user
> For that matter why does it even have a mysql.user ??? Should it not be
> mysql.root?
>
>
>
>
>
> Walter Heck wrote:
&
Ah, try this:
"chmod ug+rw ibdata1" and the same for your iblogfile0 and iblogfile1 files..
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 12:48 AM, JD wrote:
> ls -altr /var/lib/mysql
--
MySQL General
I don't think so unfortunately. He says in his first mail:
> I'm using an excel library that accepts a SELECT as input and generates an
> XLS file with the records as output.
So, probably csv is not going to help him, which is a shame :)
Walter
OlinData: Professional services for MySQL
Support
He's using Delphi according to his first post. You might wanna use a
TClientDataSet if you're not doing so already. It provides a bit more
flexibility and won't keep the select query open for longer than is
necessary.
Have fun!
Walter
OlinData: Professional services for MySQL
Support * Consultin
Well, you could diff the old and the new conf and see if any of the
changes point you in the right direction. You could even post the diff
here so we can help you think :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Jan
Have you compared my.cnf files? Is the system you installed it on the
same? I mean, did you reinstall the OS or anything? If not, we can
rule that out :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
On Sun, Jan 18, 2009 at 5:19 PM, Baron Schwartz wrot
t the SQL level (using the PREPARE statement)
and those processed using the binary client-server protocol (using the
mysql_stmt_prepare() C API function). "
Kind regards,
Walter Heck
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
You can only copy files liek that for MyISAM tables. Are you sure you didn't
accidentally convert to INNODB somewhere along the line? If so, go back to
your old install and dump everything so you can import it in the new
install, or convert everything back to MyISAM in the old install before
moving
One optimization I see quickly is changing the left join to an inner join.
You always look for records that exist in tag_ad_map (by checking for
tm.is_active) so the left join is not necessary. That should at least speed
this query up considerably.
Walter
Need MySQL advice?
OlinData.com is the pl
71 matches
Mail list logo
