Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and
then use two starts: one on 'a > 0' and one on 'a < 0', taking a union
of the result? Which might make a significant result to something?
Ben.
On 20
E a = TRUE;
This will return the same results, but not use key 'a':
SELECT * FROM t WHERE a;
Is this a bug, or deliberate behaviour, or a missing feature, or perhaps
something else?
Thanks,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
hank you very much for your experience.
And when you make your network link to die (remove cable / ifconfig
down / iptables...) between your master and your slave, how long does
your Binlog Dump process stay up ?
> 2015-06-25 2:48 GMT-03:00 Ben RUBSON :
>>
>> 2015-06-22 13:45 GMT
2015-06-22 13:45 GMT+02:00 Ben RUBSON :
> 2015-06-19 12:08 GMT+02:00 Ben RUBSON :
>>
>> 2015-06-18 22:52 GMT+02:00 shawn l.green :
>>>
>>> On 6/18/2015 2:10 PM, Ben RUBSON wrote:
>>>>
>>>> Hello,
>>>>
>>>> In
2015-06-19 12:08 GMT+02:00 Ben RUBSON :
>
> 2015-06-18 22:52 GMT+02:00 shawn l.green :
>>
>> On 6/18/2015 2:10 PM, Ben RUBSON wrote:
>>>
>>> Hello,
>>>
>>> In order for the slave to quickly show a communication issue between
>>> the
2015-06-18 22:52 GMT+02:00 shawn l.green :
>
> On 6/18/2015 2:10 PM, Ben RUBSON wrote:
>>
>> Hello,
>>
>> In order for the slave to quickly show a communication issue between
>> the master and the slave, I set slave_net_timeout to 10.
>> "show slave
how processlist" and "show slave hosts" take a very long
time to update their status when the slave has gone.
Is there any way to have a refresh rate of about 10 seconds, as I did
on slave side ?
Thank you !
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Dear MySQL,
Using 5.1.56, I have experienced this core dump. Is there anybody out
there qualified to give an opinion on this?
Many thanks,
Ben Clewett.
Thread pointer: 0x7fd5280dbd90
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no
*HAVING typelist = 'x,y,z';
On 22 November 2012 15:25, Ben Mildren wrote:
> Ah read it quickly and misread your requirement. Joins are likely FTW
> here. The alternative would be to do something like this, but I'd opt
> for the joins if you have a reasonably sized
BY id HAVING listid = 'x,y,z';
On 22 November 2012 15:10, Ben Mildren wrote:
> SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
>
> On 22 November 2012 15:01, Neil Tompkins wrote:
>> Michael,
>>
>> Thanks this kind of works if I'm checking
SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
On 22 November 2012 15:01, Neil Tompkins wrote:
> Michael,
>
> Thanks this kind of works if I'm checking two types. But what about if I
> have 5 types ?
>
> On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote:
>
>> response did not go t
the advantage without the disadvantage. But this is a lot
of work to change every query we ever run!)
I am working on reproducing the error, but so far it appears to be random.
Ben
On 2012-10-09 18:44, Rick James wrote:
As for the crash, I don't know. Instead, I recommend either shri
s? Do any users know of a fix?
Thanks!
Ben Clewett.
Thread pointer: 0x7f6ea014cf90
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 410220e8 thread_stack 0x4
/usr/sbin/m
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James wrote:
> That says that your password in not correct. You have not gotten to specific
> privileges.
>
> Did you previously do
> GRANT ... TO myuser@localhost IDENTFIED BY '.
Ben Wiechman
Network Administrator
Wisper High Speed Internet
Office: 866.394.7737
Direct: 320.256.0184
Cell: 320.247.3224
b...@wisper-wireless.com
> -Original Message-
> From: Gary Smith [mailto:g...@primeexalia.com]
> Sent: Friday, March 27, 2009 12:59 PM
> To: mysql@lis
Awesome... that works. Had to add a where clause to limit it to a specific
host.
The explain for that looks... interesting.
Thanks
-Original Message-
From: ddevaudre...@intellicare.com [mailto:ddevaudre...@intellicare.com]
Sent: Tuesday, February 10, 2009 12:47 PM
To: Ben Wiechman
Cc
| Host | LoginTime | LogoutTime |
+--+--+-+-+
| 0010E70A8004 | 172.17.6.100 | 2009-02-09 09:16:24 | 2009-02-10 04:42:08 |
+--+--+-+-+
1 row in set (0.
he host in question the information is
returned. This produces too many results as some of those users have since
migrated to a different access point.
-Original Message-
From: Andrew Wallo [mailto:theme...@microneil.com]
Sent: Tuesday, February 10, 2009 12:05 PM
To: Ben Wiechman
Subject: Re:
I keep hacking at this but haven't been able to get it right yet.
I have two tables
Userinfo contains a login, User's Name, Group Name
Log contains login, host, datetime of last login
What I need to do is return user information (userinfo.name/groupname) of
users that have logged into
---
>The table has to have a ParentID column (call it what you want) that
points, in the case of a
>Friend, to the "Friend Of Whom" UserID column
--
Not sure what you mean as aren't you describing a 1 to 1 relation?
I'll check the site
(i.e. it's two records in the same USER table)
How are relationships between records in the same table usually dealt with
in terms of design? Implementation?
ThanX,
Ben
""Jim Lyons"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Indexes
Does using foreign keys simply enforce referential integrity OR can it also
speed up JOIN queries?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I'm having conceptualizing the correct relationship for what seems a very
simple scenario:
Scenario:
I have a standard "USERS" table...
USERS have a list of "FRIENDS", these can be other members or also non
members... Similar to facebook...
My main issue is conceptualizing the relations
I figured that was what you meant... I guess my table didn't work (see above
message...don't ya' love plaintext :-O)...
Has anyone ever tried to benchmark the difference between utilizing ENUMs
vs. traditional relational databasing? I would think ENUM is ideal for items
I specified at the begin
s simple.
+ (?)
Integrating w/ 3rd party SW or new applications probably like
Relational. Are ENUMS handled/returned via normal SELECT queries? (if so,
just like relational)
-
Would have to write the decodify module for any outside system. Isn't
intuitively port
backend?
I guess what I'm asking is: would this affect web-users in any way?
>
> Thanks
>
> On Mon, 2008-09-22 at 17:12 -0400, Ben A.H. wrote:
>> Hello,
>>
>> We are setting up a relatively common web application which collects
>> "user
>>
utes, 15 of which are Foreign Keys that link to tables that will
likely never change (the users choices for countryID, stateID,
OperatingSystemID, internet_connectionTypeID, internetUserFrequencyID,
industryID, occupationID)...
ThanX in advance
Ben
--
MySQL General Mailing List
For list ar
relatively large database with approx 250,000+ users, not all will
have referrerIDs, I would wager maybe 1-10% of these people will have been
referred. Priorities for us are simplicity/scalability, efficiency (in that
order)
Ben A. Hilleli
Programmer / Analyst
store most of it in XML.
I hope this post makes sense to you. My general preference is to stick to a
normal relational database. Which is the better approach, a big database or
the dbase/xml version.
Ben
; select (now());
+-+
| (now()) |
+-+
| 2008-06-28 22:39:32 |
+-+
1 row in set (0.00 sec)
If anyone knows what could be causing this, I would greatly appreciate
your insight.
Thanks,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
MyISAM.
Check the error.log. If this is the case it will say
Also do a SHOW ENGINS, may show something...
Ben
Stut wrote:
On 5 Jun 2008, at 00:41, Phil wrote:
Just a very quick guess but is innobd engine running ?
SHOW STATUS like '%inno%'
Output shown below. I'v
Is it the same
server? Same config file? Same default engine?
Ben
Stut wrote:
Hi,
I just finished restoring a 22gig SQL dump but the server is not
performing anywhere near where it should be. I'm assuming this is
because it's still rebuilding indexes on the imported tables.
Is t
0 |
+-+--+--+
(All other lines are as same as first two.)
Is there an InnoDB expert who can tell me whether this is indicating a
problem?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
You might be able to do it with the federated engine:
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Fire a trigger on your main tables which update some row in a foreign
MySql database used for accounting. I've not tried this but the theory
is sound.
Ben
A
ect the
partition table?
Any help very welcome!
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nux) using the commands:
# glib-config --cflags
# glib-config --libs
Ben
Neil Tompkins wrote:
Thanks Ben, but I don't appear to have the header file in my
libraries.
Neil
> Date: Wed, 14 May 2008 12:3
If you using C++ then you can use this:
http://developer.gimp.org/api/2.0/glib/glib-Timers.html
I use this in my code, does an excelent job.
Also you may want to look at the 'slow log' in mysql which will show, to
the nearest second, the length of queries
Ben
Neil Tompkins
Table level locking is inherent to MyIsam.
Look into partitioning, as this breaks table into two or more other
tables which will lock separately.
Or use InnoDB:
ALTER TABLE ... SET ENGINE=InnoDB; (I think)
Ben
Krishna Chandra Prajapati wrote:
Hi,
I am looking for a solution to reduce
If you use InnoDB you should not have a problem as it used row-level
locking and isolated transitions.
Other than that you can split your tables into smaller ones using either
partitioning or the federated engine...
Ben
Krishna Chandra Prajapati wrote:
Hi,
Generally, in data modelling
SHOW CREATE TABLE ...
Martijn Tonies wrote:
Hi,
How does one know if ON UPDATE CURRENT_TIMESTAMP was specified when
creating a column? How do I retrieve this bit of info from the metadata
queries?
(also MySQL 4.1)
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB
Thanks for the idea. Unfortunately nothing I can easily use (for
instance in MySql Administrator) to log and monitor the lag in bytes
between log writes and row data writes. :)
Iñigo Medina García wrote:
Hi Ben,
Dear MySql,
I am trying to optimise InnoDB, and trying to find out how
the varaible 'Innodb_data_pending_writes' which may be what I
need. This is zero, I am not sure whether this means I have no
uncommitted data in the log, or something else.
Can't find anything much on Google.
If any member can help me, would be very usesful :)
block size.
Also have a look at the stripe size of your raid system, might work well
aligning them if you can. This URL also gives some tips for an ext3
file system on RAID, look for 'stride':
http://insights.oetiker.ch/linux/raidoptimization.html
Ben
Iñigo Medina García wrote:
Does anyone have a set of MySQL Visio stencils? Does such a beast exist?
Ben Wiechman
You are right, I've tried 5.0.18 and 5.0.45 which work.
There must have been a bug in 5.0.41 with which I used test the question...
I belive the question has been answered by now anyway :)
Ben
Sebastian Mendel wrote:
Ben Clewett schrieb:
Are you sure, I just get:
CREATE TABLE ...
Are you sure, I just get:
CREATE TABLE ...
ERROR 1075 (42000): Incorrect table definition; there can be only one
auto column and it must be defined as a key
On version 5.0.41. What version are you using?
Hiep Nguyen wrote:
hi list,
reading manual on mysql regarding auto_increment with m
oe@'%' IDENTIFIED BY 'whateverpassword';
CREATE USER joe@'localhost' IDENTIFIED BY 'whateverpassword';
GRANT ALL ON db1.* TO joe@'%';
GRANT ALL ON db1.* TO joe@'localhost';
If you see what I mean...
Just remember that a user always has a
Pam Astor wrote:
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE
Check the error.log on both server and client, should show where
connected and disconnected.
Or write a small program to execute SHOW SLAVE STATUS every minute and
log the results. Which I belive is done for you in the MySql dashboard
program suit.
Ben
Kaushal Shriyan wrote:
Hi
Is there
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost
,
KEY (key_from_table),
field_1 ?? ,
field_2 ??,
...
field_n ??
I don't know a way of copying over every field accept long-hand in the
triggers.
Hope this is useful...
Ben
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not ye
ery, which will show the
approximate number of rows you are hitting. Look at SHOW TABLE STATUS
which will give an idea of the size of the rows and indexs.
Marry one to the other and it will give an idea of the cache settings to
get the query into cache. But still depends a lot on the table t
table, and optimise for that...
Ben
Victor Danilchenko wrote:
Hi,
I am trying to optimize our DB server. We have one table which has
1.3M entries, and the keys are GUIDs (so the key space is large).
However, I have it all indexed. The performance was iffy, though, so I
increased
It depends how public your database is. If you ever need to shut off
one client then you might use separate users. Otherwise it's just
annoying complexity, use a single user.
Remember to use a different 'server-id' for each client!
Ben
Krishna Chandra Prajapati wrote:
Hi
y, the query just follows the index. No
temporary tables, no scanning all rows and no sorting before sending,
and the LIMIT now works as you would hope. This is highly scalable.
But you have to maintain the ordering field. If your brave, do it with
a trigger :)
Ben
Richard wrote:
Richard,
No problem, glad it works. But note: this is not scalable. If you have
more than a few hundred rows, you may want to think about a better
solution, like storing the order field permanetly and giving it an index :)
Ben
Richard wrote:
Thanks, it works like a charm :)
Ben Clewett
A modification to my last email, try:
SELECT
*, IF(update != '', update + 10, date) AS o
FROM
my_table
ORDER BY o DESC;
+-+--++--+
| num | date | update | o|
+-+--++--+
| 5 | 40 | 90 | 100 |
| 2 | 10 | 60 | 70 |
| 6 | 50 |
pdate DESC, date DESC.
Which when I try it gives:
+-++--+
| num | date | update |
+-++--+
| 5 | 40 | 90 |
| 2 | 10 | 60 |
| 6 | 50 | NULL |
| 4 | 30 | NULL |
| 3 | 20 | NULL |
| 1 | 1 |
ce comparison between these two solutions at
http://www.xaprb.com/blog/2007/04/05/mysql-table-sync-vs-sqlyog-job-agent/
Hope this is helpful.
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;read-only':
CREATE USER dmz@'%' IDENTIFIED BY ...;
GRANT SELECT ON *.* TO dmz@'%';
Then you can have a 'dba' user which can still work on the database:
CREATE USER dba@'%' IDENTIFIED BY ...;
GRANT ALL ON *.* TO dba@'%';
Ben
David R
-database joins considered good practice?
Thanks in advance for any help.
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience
trying to make it work with MySQL Cluster?
Ben Wiechman
Network Admin
Wisper High Speed Internet
[EMAIL PROTECTED]
privileges for normal db-users.
rights should be limited to own db.
Thanks
Andre
- Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]>
To: "Andre Hübner" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 20, 2008 9:46 AM
Subject: Re: external mysql
Try:
> mysql -u root -p
mysql> GRANT SUPER ON *.* TO myuser@'%';
mysql> GRANT SUPER ON *.* TO myuser@'localhost';
Andre Hübner wrote:
Hi List,
i wrote this alrready in mysql-forum a few days ago, but did not get any
answer. :(
i try to do backup with mysqldump from external host with
# mysqldump --help
look for the flag --no-data
Ben
Esbach, Brandon wrote:
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can think of is to restore a backup to
Try:
SELECT DISTINCT Colour FROM table;
Or, if you want to do it correctly:
SELECT Colour FROM table GROUP BY color;
Richard wrote:
Hello,
I don't know if it is possible to do this with mysql alone ...
Here goes :
I've got a database list which is like to following :
Num|Name|
ver-writing the 'mysql' database, restart MySql. If you have not
over-written this database, then you have lost your users and
permissions. But you should be able to log in as 'root' with no password.
Also check your error.log. Chances are this will tell you what is wrong :)
ntial read and write.
If any members can suggest what might be appropriate, I would be
interested in knowing :)
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
put the CPU load at 100%?
If four of my ten MySql servers are doing this regularly, I can't be the
only person with this problem. Can somebody from MySql please let me
know that on earth you are doing to my CPU's??
Regards,
Ben
BTW, who controls InnoDB? Is it Oracle or Sun?
ich are replication slaves and masters at the same time who
tend to do this 100% CPU thing for hours on end...
Kind regards,
Ben
Kevin Hunter wrote:
At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote:
I need to know why MySql does this. If any person knows how I an
identify the problem, plea
= db.site
replicate_do_table = (etc)
Ben
Paul Berry wrote:
hey guys - is it possible to have a lightweight slave setup? so that you
only take X amount of tables from the DB
curious what good solutios are out there
--
MySQL General Mailing List
For list archives: http
way for minutes or hours, or until it is restarted.
This load cannot be accounted for by the processlist.
I need to know why MySql does this. If any person knows how I an
identify the problem, please let me know!
Thanks!
Ben Clewett.
# top
top - 08:19:50 up 5 days, 9:52, 1 user, load
)
VALUES ( NULL , '35126600409511509' , '2007-12-18 23:59:58' ,
'5.150556400501e+01' , '-3.696216681689e-01' ,
'8.00016653e-02' , '1.0
Many thanks!
Ben Clewett.
--
MySQL General Mailing List
For list archive
n 0; hex ; asc ;; 13: len 0; hex ;
asc ;; 14: SQL NULL; 15: len 4; hex 8000; asc ;; 16: len 4; hex
8001; asc ;; 17: len 1; hex 80; asc ;; 18: len 4; hex 64626d73;
asc dbms;; 19: len 1; hex 00; asc ;;
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archive
x27;d like to insert a row into the second
with a set value.
I tried this but it is not working. I'm not very familiar with subqueries as
you can see.
insert into table_2 ( id, value ) values ( (select id from table_1), '1' );
Ben Wiechman
[EMAIL PROTECTED]
# nice 10 mysqld --defaults-file=low_priorty_1
# nice 10 mysqld --defaults-file=low_priorty_2
# nice 10 mysqld --defaults-file=low_priorty_3
# nice 10 mysqld --defaults-file=low_priorty_4
Or is there a better way that people use?
Thanks in advance...
Ben
--
MySQL General Mailing List
For lis
151 chars, when fully populated.
Ben
Cathy Murphy wrote:
I am limiting text to 50 chars in mysql field by varchar(50) ( UTF-8
enabled)
but what if the user enters 50 japanese chars, does mysql accomodate it OR
we have to consider some buffer during design ?
--
MySQL General Mailing List
For l
Ravi,
Got it, thanks!!
Ben
Ravi Prasad wrote:
Make sure each of the replication slaves uses different server_id.
--Ravi
Ben Clewett wrote:
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64
bit Linux.
In the error.log on all four replication servers I keep
used another master server on
AIX, same version, which does the same thing. The servers are side by
site on the same gigabit switch.
The replication does work, but it's a bit messy.
Any ideas how to get round this problem?
Ben
--
MySQL General Mailing List
For list archiv
Can Mysql 4.20 use an index where like 'xx%' is in the where
clause against the column.
i.e. index table1(col1)
from table1
where table1.col1 like 'something%'
Regards,
Ben
--
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.u
.
via a log file) are/have been run against the database. If it counts
how may times/how much resources each query uses that would be good.
The icing on the cake would be a prog that told us what queries were
doing full table scans and other expensive operations.
Regards,
Ben
--
Ben Edwards
break this file using defined table space, as with Oracle.
Then have as many/few files as we like.
Ben
Thanks
Olaf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
we really need to
be able to break this file using defined table space, as with Oracle.
Then have as many/few files as we like
Ben
Olaf Stein wrote:
Hi all,
Are there any reasons why one would NOT use separate ibd files for each
table (--innodb_file_per_table). It seems logical to me
7;2007-06-15' = '2007-06-15 00:00:00' is True.
This has caused us a few problems. Is this the way things should be,
because this change does not seem right?
I am also very worried that this behaviour revert when we role out 5.1?
Does any member know whether this is a bug, or jus
h I'm pretty sure it's
covered in the manual.
On 6/14/07, Ben Liu <[EMAIL PROTECTED]> wrote: I'm trying to
delete a subset of items in a table. The problem is, I don't
want to query for the subset first, store the results and then run
a series
of delete queries. I
query for #1.
I've tried:
DELETE FROM order_items WHERE order_items.ord_id=orders.ord_id AND
orders.cust_id=-1
DELETE FROM order_items LEFT JOIN orders ON
order_items.ord_id=orders.ord_idWHERE
orders.cust_id=-1
Neither of them seem to work.
Thanks for any help.
~Ben
nstalled 5.0.41 and have found that the 'hostname' variable does
report the hostname of the physical server. I have no idea how it does
it :)
I have my solution, thanks for the help,
Ben Clewett.
Baron Schwartz wrote:
Gerald L. Clark wrote:
Baron Schwartz wrote:
Gerald L. Clark w
Baron,
Thanks for the fast reply.
I like the idea of piping in the servername to a small table on startup.
Since this will only change on startup, sounds like an excellent idea.
Or I may upgrade to above 5.0.41...
Regards,
Ben
Baron Schwartz wrote:
Hi,
Ben Clewett wrote:
Dear MySQL
eport the server host
name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from MySQL?
Many thanks,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
key constraint fails"
Of course I may be doing something wrong.
Would any person have a better idea of getting a consistent snapshot
with correct coordinates?
Many thanks,
Ben.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
se it even more, if I sort the query, it gives a different
amount depending on what its sorted by!! For example, if I sort it by 'url'
it seems to generate 569 elements!
Can anyone please spot the undoubtedly obvious error I've made here?! I've
been scratching my head for days, to no avail!
Many thanks in advance,
Ben Benson
Hi Scott,
Thanks for the information. I'll look into linux-ha seriously.
Regards,
Ben
Scott Tanner wrote:
Ben,
Check out Linux-ha ( http://linux-ha.org). We are using version 1 at my company, which is fairly easy to set up and there are a lot of good articles on it. With this yo
I forgot to mention that I am running Linux.
If anybody has some idea of software which can do this, I'd be very
interested.
Regards,
Ben
Ben Clewett wrote:
Dear MySql,
I'm looking into availability and wonder if any member might be able to
help me.
I have two databases, o
e any software they can
recommend which:
- Stops the replication daemon.
- Sets the replication server to Read/Write.
- Shuts down the primary.
- Routes traffic to the replication.
Any advise or ideas would be very useful...
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list arc
Can anyone tell me how i can get it or where I can find it? I am using
sparc solaris 10.
Thank you very much,
Ben
--prefix=/usr/local/mysql --enable-assembler \
--with-mysqld-ldflags=-all-static
Then I went ahead and tried a make, i get this:
make[3]: *** [libedit.a] Error 1
make[3]: Leaving directory
`/tmp/ben/mysql-5.0.37/cmd-line-utils/libedit'
make[2]: *** [all-recursive] Error 1
m
?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What does a `show innodb status show`?
On 07/12/2006, at 2:44 AM, James Neff wrote:
Greetings,
I've got 6 Java client applications (running on 6 different PC's,
including one of them on the database server) reading data from a
flat file and inserting data into a table on my database:
m
rce code directories...
Regards,
Ben
Chris wrote:
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks for the reply.
I'm looking in the home directory, as well as the other directories
used by mysql and I can't see any files which I do not recognise. (I
am UNIX so t
Hi Mohsen,
I see, the difference between the home of mysql and the mysql home...
As you asked:
mysql:*:204:1::/home/mysql:/usr/bin/ksh
# ls -la /home/mysql
4 -rwxr- 1 mysqlstaff 254 14 Feb 2005 .profile
Regards,
Ben
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote
1 - 100 of 385 matches
Mail list logo