Relational databases are not very suitable for representing
graph-style data. You might want to look into graph databases, or the
OQGraph engine for MySQL: http://openquery.com/products/graph-engine
good luck!
Walter
On Fri, Jan 20, 2012 at 13:54, bruce badoug...@gmail.com wrote:
Hi.
Got a
-5.2.34-1el6.x86_64
python(abi) = 2.6 is needed by
mysql-workbench-gpl-5.2.34-1el6.x86_64
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
To Clarify this a bit: You can only reliably do writes to one server.
Your reads can go to both servers with no problems.
For reads that need to read data that was just written though, you
need to read from the 'active' master, as you can not rely on
replication to be instantaneous.
On Tue, Oct
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
Engineer @
It would be a lot better to make sure your server doesn't turn
OOM-psycho on you. The most common case of this happening is that you
have set the memory-settings in your my.cnf in such a way that it
allows MySQL to use more memory then you have available. Could you
post your my.cnf here by chance?
It kind of depends on your application. If you have an application
like most web applications, it is okay to skip a beat and a half when
a failover occurs. Usually you can lose a very small number of
transactions (the ones that are ongoing when the failure occurs), but
your failover happens
On Thu, Jun 10, 2010 at 07:09, camelia botez
camelia.bo...@weizmann.ac.il wrote:
What can be done to run on both servers mysqld simultaneously and use the
same data base?
You are probably asking the wrong question here. Let's take a step
back and ask you another question: What is it you want to
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
manasi.s...@artificialmachines.com wrote:
Hi All,
I am getting following error when I am trying to run one stored procedure on
table which has 30 rows in
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
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 |
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
jeetendra.ran...@sampatti.com wrote:
Hi,
My MySQL server Aborted_connects status is showing 8692 and is rapidly
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 vegiv...@tuxera.be wrote:
Hey all,
I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
workload based on standard Mysql full query
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:
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles cbr...@bmi.com 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
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, Joemysql@bluepolka.net wrote:
We have an inaccessible MySQL v5.0.45 DB
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
Check out replication.
On Sun, Aug 23, 2009 at 09:00, m. zamil mza...@saudi.net.sa 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://openquery.com)
Bill,
if you use an order by clause in your query, the limit will pick the first
100K rows in that order. That way you can ensure that all rows will be
processed in (wait for it...) order :)
Cheers,
Walter
On Tue, Aug 18, 2009 at 18:44, Bill Arbuckle b...@arbucklellc.com wrote:
I am in need
Hi Imran,
Have a look at MySQL MMM for Multi-Master Replication failover. The project
is currently in refurbishment when ti comes to having a home, but you can
start by looking at : http://mysql-mmm.org for information.
This project is made for exactly what you want to achieve: Having multiple
Hey Tim, all
On Wed, Jun 24, 2009 at 10:03 AM, Little,
Timothytlit...@thomaspublishing.com wrote:
Why, you might ask, index on physmessage_id? Because then the db won't
have to do a fetch on items from the table since it's in the INDEX
itself, saving any unnecessary reads.
FYI: That only
Peter,
On Thu, Jun 18, 2009 at 9:27 PM, Peter
Brawleypeter.braw...@earthlink.net wrote:
For explanation alternatives see The unbearable slowness of IN() at
http://localhost/artful/infotree/queries.php.
you prolly meant to not post a url pointing at your local copy of your
website. This works
It is probably writing to syslog. Try cat /var/log/messages | grep -i
mysqld to search for entries made by mysqld.
Walter
On Tue, Jun 16, 2009 at 11:48 AM, Madan Thapamadan.feedb...@gmail.com wrote:
Hi,
mysqld is not writing to err-log and i do not see any log generated upon
mysql service
Curdate() returns a datetime, which you are pushing into a date field.
It is truncating the time part. Just truncate it and you should be
fine :)
Walter
On Fri, Jun 5, 2009 at 5:56 AM, Keith Edmundsk...@midnighthax.com wrote:
I'm very new to triggers, so I suspect I've done something naive.
You might try and hack something together using NTFS juction points.
Unadvisable though, and probably unsupported.
Walter
On Mon, Jun 1, 2009 at 9:00 PM, Foo JH jhfoo...@extracktor.com wrote:
Hi all,
I'm using MySQL 5.0 on Windows 2003.
Problem background: We use the same server for
Most commonly, you would store all information (including descriptions
in teh database. The amount of data you describe is peanuts for MySQL.
Then, you would probably store a path to an image in the database as
well. You could then store the images on disk outside the database, or
even think about
Start the server with --skip-grants-table. That will disable logins.
Then do delete from mysql.user and restart :)
Walter
On Tue, May 26, 2009 at 6:05 PM, Daevid Vincent dae...@daevid.com wrote:
Now I'm really confused.
I just did this:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM
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 mo...@fastmail.fm wrote:
I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
using MySQL 5.1.30.
In the MySQL
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 mo...@fastmail.fm wrote:
I'm using MySQL 5.1.30 and have several memory tables with indexes on the
appropriate columns.
forgot the list, sorry :)
Walter Heck
-- Forwarded message --
From: Walter Heck - OlinData.com li...@olindata.com
Date: Thu, Mar 26, 2009 at 2:09 PM
Subject: Re: A problem relative ibdata1
To:
Cc: Riccardo Michele Filippone ethern...@gmail.com
Riccardo,
if you're ibdata1 file
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 dirk.bre...@nisc.coop wrote:
Could not find
first log file name in binary log index file
Are you using large blobs by any chance? when max_allowed_packet
(google it ;) ) is set too small, the server will also terminate the
connection with this error message. Remember to set it correctly at
the server and at the client side.
One of the better explanations by monty is found here:
34 matches
Mail list logo