Cameron Mann cybera.ca> writes:
>
> Hi all,
>
> I've encountered a problem with MySQL 5.6.23 on CentOS 7.0 and would
> greatly appreciate any advice on what to do next.
>
> Synopsis:
>
> 1. Fresh install of CentOS 7.0 using minimal install ISO
> 2. yum update -y
> 3. rpm -i http://dev.mysql.c
Thank you this is very helpful and was what I was looking for.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
http://www.thunder-rain
plish this?
MySQL version: 5.5
Thank you,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
http://www.thunder-rain.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
MySQL General Mai
I am using graphite, but what exactly do you want to graph?
For mysql graphing I actually use nagios plugin called
check_mysql_health along with check_mk/pnp4nagios
That works really well.
On Fri, Feb 22, 2013 at 2:24 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Adars
HI Trimurthy,
Just curious won't it make that data inconsistent on the slave?
Thanks
On Fri, Feb 22, 2013 at 12:15 AM, Trimurthy wrote:
> Dear Mike Franon,
>
> i have also faced the same problem while setting up the replication. by
> that time i have added the error n
otherwise
> a master may write instructions in the binlog the older
> slave does not undersatdn at all, but as said normally
> both should have the same version
>
> Am 21.02.2013 18:03, schrieb Mike Franon:
>> So I created a new test box on AWS, and just did one upgrade fr
was curious if anyone had any ideas?
Thanks
On Wed, Feb 20, 2013 at 5:51 PM, Mike Franon wrote:
> This is on a slave, i only upgraded on one box which is the slave i
> have not touched master
>
> On Wed, Feb 20, 2013 at 5:41 PM, Reindl Harald wrote:
>>
>>
>> Am
So I successfully upgraded a test db server from 5.0.96 all the way up to 5.6
Replication as the slave, where the master is 5.0.96, started working
for about 10 minutes and then got the following error:
[ERROR] Slave SQL: Error 'Duplicate entry 'data' for key 'PRIMARY'' on
query. Default database
ce the downtime to a few seconds
>
> Am 20.02.2013 20:29, schrieb Mike Franon:
>> OK I got it to work.
>>
>> I dumped the tables that it was complaining about first, and then
>> dumped the triggers.
>>
>> I then uninstalled anything to do with mysql, a
This is on a slave, i only upgraded on one box which is the slave i
have not touched master
On Wed, Feb 20, 2013 at 5:41 PM, Reindl Harald wrote:
>
>
> Am 20.02.2013 23:27, schrieb Mike Franon:
>> So I successfully upgraded a test db server from 5.0.96 all the way up to 5.6
>&
full mysqldump.
I am now going to go from 5.1 to 5.5
On Wed, Feb 20, 2013 at 12:54 PM, Mike Franon wrote:
> I am pretty sure I did, and when I did I got the following errors:
>
>
> Error: Table Upgrade Required, Please dump/reload to fix it
>
>
> I got that on 10 tab
eb 20, 2013 at 12:43 PM, Reindl Harald wrote:
>
>
> Am 20.02.2013 18:26, schrieb Mike Franon:
>> So I did a full mysqldump over the weekend for a second time and this
>> time it is 220GB, no clue what happened last time, I should have
>> realized looking at the file size some
So I did a full mysqldump over the weekend for a second time and this
time it is 220GB, no clue what happened last time, I should have
realized looking at the file size something was wrong, but since I got
no errors did not think about it, and this time I timed it, took 7
hours to do a complete mys
han a 400:1 ratio. Maybe the dump isn't
> working correctly or your data set is much smaller? If the dump output is
> less than a gig I would just edit it with something like vi and look at the
> offending line.
>
> Keith
>
> On Feb 15, 2013 3:55 PM, "Mike Franon&q
out to a wider audience.
>
> Upgrade to 5.5 (through 5.1) first as it is quite proven. Slave 5.6 off it
> and test. Be patient. Save yourself some heartache. Just my two cents.
>
> Keith
>
> On Feb 15, 2013 9:27 AM, "Mike Franon" wrote:
>>
>> Thanks everyone for s
ang.com]
> Sent: Thursday, February 14, 2013 3:41 PM
> To: Rick James
> Cc: Mihail Manolov; Mike Franon; Akshay Suryavanshi;
>
>
> Subject: Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6
>
>
>
> Its a very pedantic case, but we had a few instances where it was an
Great thanks for the info, I guess the best way to do this is take a
spare server, set it up with our standard setup, and then start the
upgrade as you said 5.0 -> 5.1 -> 5.5, test and then upgrade to 5.6
and test.
On Thu, Feb 14, 2013 at 4:22 PM, Akshay Suryavanshi
wrote:
> Mike
y to protect
> data which can not be only hashed
>
> somewhere you need the information how to encrypt them
>
> Am 05.02.2013 15:18, schrieb Mike Franon:
>> I tried all these methods and you are right this is not going to work for us.
>>
>> I am not a developer, do
to store 3 tables that have
email address, ip address, and personal info.
On Sun, Feb 3, 2013 at 12:57 PM, Reindl Harald wrote:
>
>
> Am 03.02.2013 18:52, schrieb Mike Franon:
>> Hi,
>>
>> I was wondering what type of encryption for linux would you recommend
>>
Hi
To me it looks like quantity is being multiplied by the price and then added to
total.
Try something like this
SELECT total,(quantity*price) as QP from sales where total !=QP AND salesid=122
On 2012-12-29, at 7:25 AM, Trimurthy wrote:
> hi,
> i am working with mysql 5.1.36 and i wro
Hi Neil
Would something like this work.
SELECT DISTINCT id,type from your_table WHERE type=2 OR type=5;
Mike
- Original Message -
From: "Neil Tompkins"
To: "[MySQL]"
Sent: Thursday, November 22, 2012 9:30 AM
Subject: Basic SELECT help
Hi,
I'm struggli
You might not know about proxy services. I am in Canada and can watch
hulu.com etc if I am proxied in.
Currently I use HotSpot shield from anchorfree.com and they have a free
version.
Mike
- Original Message -
From: "Claudio Nanni"
To: "Paul Vallee"
Cc:
On Wed, Mar 28, 2012 at 2:56 PM, Rich Jones wrote:
> Hey folks!
>
> This gig just popped up on our system, thought it could be some easy money
> for anybody out there who knows Ruby/Rails and how to optimize queries!
>
> http://gun.io/contracts/67/improve-site-speed-for-startup
Normally I wouldn'
Thank you Simon exactly what I was looking for. Appreciate the assistance.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Orig
Hi Patrice
I would try some brackets.
Something like this should work
SELECT * FROM listings WHERE listing_state = 'DC' AND listings.listing_show
='y' AND ( listings.cat1 = 23 OR listings.cat2 = 23 OR listings.cat3 =
23 )
Mike
- Original Message -
From: &q
Rong,
On the server, we are using the following RPMs (from MySQL):
- MySQL-server-5.5.11-1.rhel5.x86_64
- MySQL-client-5.5.11-1.rhel5.x86_64
On the clients, we are using the following RPM (from Red Hat):
- mysql-5.0.45-7.el5.x86_64 RPM
Mike
On 11/09/2011 10:49 AM, Rong Chen wrote:
Javier
you think.
Thanks In Advance,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
only time I let types intrude on names is with booleans, which I try to
> name with a state-of-being verb, such as "has_paid", "is_member",
> "has_children", etc.
>
> > On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl wrote:
> >> Well, while we're
e, or is it
just me?
Looking forward to your input.
Mike.
On Thursday 04 August 2011 6:43:55 am David Lerer wrote:
> I agree. I use the same column name in all tables where it has the same
> function - but I consistently add a suffix or prefix. And yes, it is the
> old fashion way Davi
f if needed, to another
"remote" server.
My system isn't under heavy load, but it simply can not be down... if at all
possible.
That said, Mysql Proxy and HA Proxy seem to be the front-runners.
Any additional comments are certainly welcome.
Mike.
On Monday 13 June 2011 3:16
might be too http-centric. Would it work for Mysql?
Any comments/pointers would be most appreciated.
--
Take care and have fun,
Mike Diehl.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
/password from them,
I have a similar situation. What I do is store a random number in their
record, which I also include in the url. Access to the record is gained by
the combination of id, and tag. Just a thought.
--
Take care and have fun,
Mike Diehl.
--
MySQL General Mailing L
I have two of Paul's books and they are excellent.
- Original Message -
From: "Paul DuBois"
To: "[MySQL] Mysql list"
Cc: "MikeB" ; "Philip Riebold"
Sent: Thursday, October 28, 2010 1:45 PM
Subject: Re: SQL book recommendation?
On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:
Hi Steve
Your statement will allow you to SELECT from any table in the pet_calendar
database. You need to add INSERT, UPDATE, DELETE, CREATE etc to your GRANT
statement. If you would like to have a super user, just GRANT ALL
Mike
- Original Message -
From: "Steve Marquez&
On Fri, 2010-09-10 at 15:57 +0200, Uwe Brauer wrote:
> >>>>> On Fri, 10 Sep 2010 04:43:39 -0400, Mike McMullin
> >>>>> wrote:
>
>> On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
>>>
>>> Good luck!
>&g
On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
> We do nightly backups at work just by taring the mysql directory. In
> my environment, that is /var/lib/mysql.
>
> Like this:
>
> service mysql stop
> cd /var/lib/mysql
> rm -rf *
> tar zxvf file.tar
> rm -rf ib_logfile*
> chown -R mysql.
- Original Message -
From: "Christoph Boget"
To: "Mike Blezien"
Cc: "MySQL List"
Sent: Tuesday, August 31, 2010 1:06 PM
Subject: Re: Even or Odds numbers
is there a function, using MySQL 5.0v, that can detect if a numerical value
is either an Ev
Hello,
is there a function, using MySQL 5.0v, that can detect if a numerical value is
either an Even or Odd number
Thanks,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
http://www.thu
,
Mike Spreitzer
From: Jaime Crespo Rincón
To: Nunzio Daveri
Cc: Guifre Bosch Fabregas ,
mysql@lists.mysql.com
Date: 08/13/2010 04:07 AM
Subject:Re: RHEL Auto Start / stop mysql???
2010/8/12 Nunzio Daveri :
> Hi Guifre, thanks for answering. I already have mysql instal
0.00
0.000.00 0.00 0.00
dm-1 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.000.00 0.00 0.00
Thanks,
Mike Spreitzer
From: Mike Spreitzer/Watson/i...@ibmus
To: Dan Nelson
Cc: MySql
Date: 08/11/2010 01:30 PM
Subject:Re: idle query
Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT
JOIN".
Thanks!
Mike Spreitzer
-+
2 rows in set, 1 warning (0.00 sec)
mysql> explain extended select * from fldrcv straight join fldsndm on
(fldrcv.q=fldsndm.p AND fldrcv.qboot=fldsndm.pboot and
fldrcv.msgid=fldsndm.msgid);
ERROR 1054 (42S22): Unknown column 'fldrcv.q' in 'on clause'
mysql>
Thanks,
Mike Spreitzer
t(*) |
+--+
|29036 |
+--+
Thanks,
Mike Spreitzer
oking into
better server&disk and rewriting my query along the lines you suggested.
Thanks!
Mike Spreitzer
SMTP: mspre...@us.ibm.com, Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
s.
Thanks,
Mike Spreitzer
Sure, `wc` is different from mysql --- but different enough to account for
a 16000:75 ratio?
Will iostat give a good utilization metric for GPFS?
If I want to try to actually hold a 2GB table in RAM, is there anything I
need to set in my.cnf to enable that?
Thanks,
Mike Spreitzer
SMTP: mspre
suggestions.
Thanks!
Mike Spreitzer
this
query run about as fast as can be expected, right? It did not take
anywhere near 9 hours to make the fldrcv table ... so why is it taking so
long to do this join to make the fldpar table?
/etc/my.cnf is based on the distribution's my-huge.cnf, with only minor
customization.
Thanks,
Mike Spreitzer
-1el6.x86_64
libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by
mysql-workbench-gpl-5.2.25-1el6.x86_64
libzip.so.1()(64bit) is needed by
mysql-workbench-gpl-5.2.25-1el6.x86_64
python-paramiko is needed by
mysql-workbench-gpl-5.2.25-1el6.x86_64
Thanks,
Mike Spreitzer
Are there any publicly available data on how the size of some (or better
yet, many) particular "real" database(s) changed over time (for a longish
period of time)? How about data on how the throughput (in any interesting
terms) varied over time?
Thanks,
Mike Spreitzer
If you are using v4 of php this will never work
On Tue, Jun 1, 2010 at 10:24 AM, memo garcia wrote:
> Hi all,
>
>
>
> I have the following script:
>
> Load data
>
> Local infile ‘myData.csv’
>
> Into table myTable
>
> Fields terminated by ‘,’
>
> Enclosed by ‘’
>
> Lines terminated by ‘\r\n’
>
>
On Wednesday 14 April 2010 7:39:03 pm Dan Nelson wrote:
> In the last episode (Apr 14), Mike Diehl said:
> > On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote:
> > > Lines is a reserved keyword (e.g. like in "LINES TERMINATED BY"), so it
> > >
KEY)
> ENGINE=InnoDB; Query OK, 0 rows affected (0.20 sec)
Yup, that was it. I'm migrating from Postgres, so it never occured to me
that "lines" might be reserved.
Thanks.
--
Take care and have fun,
Mike Diehl.
--
MySQL General Mailing List
For list archives:
across replication.
Any ideas?
--
Take care and have fun,
Mike Diehl.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I have two of Paul's books. They are both fantastic.
Mike O'Krongli
President and CTO
Acorg Inc
519 432-1185
- Original Message -
From: "Claudio Nanni"
To: "Ken D'Ambrosio"
Cc: "mysql"
Sent: Monday, December 28, 2009 10:33 AM
Subject:
I'm not sure whether the following will meet your needs. Have you
considered
SELECT title FROM Title WHERE NOT EXISTS (SELECT * FROM Keyword,
TitleKeyword WHERE Keyword.kw='A' AND Keyword.id=TitleKeyword.keyword_id
AND TitleKeyword.title_id=Title.id)
Regards,
Mike Spreit
These are names&titles of Americans. This web app and database do not
exist now (the current procedure is done with more primitive tech), and so
I can make plausible adjustments to the plan.
Thanks
Mike Spreitzer/Watson/IBM
09/21/09 04:10 PM
To
"Jerry Schwartz"
cc
&q
this going to fly, in terms of latency for the incremental lookups and
overall load at the hosting site?
Thanks
"Jerry Schwartz"
09/21/09 03:47 PM
To
"'Michael Dykman'" , Mike Spreitzer/Watson/i...@ibmus
cc
Subject
RE: incremental name search?
SoundEx doe
Suppose I have a table of a few thousand people, with a FirstName field
and a LastName field. Sadly, my people are not so regular. Some names
have three parts (e.g., due to marriage) crammed into the two fields
("Hillary Rodham Clinton"). Some even have titles ("Dir, gastroent.
dept., Fubar
Hello, all.
Can any of you share with me the names of any third-party tools or
appliances that you are using to encrypt your MySQL databases? I am
doing a search and would like to narrow down the initial search list.
Thanks!
Mike
Today's instance finished shortly after I sent the email below. BTW, here
are some specifics on the table (which uses MyISAM). Thursday's instance
has 11 GB of data and 0.78 GB of index. Today's instance has 26 GB of
data and 1.8 GB of index.
Thanks,
Mike Spreitzer
Mike S
_created | 4 |
| Threads_running | 2 |
| Uptime| 202522 |
| Uptime_since_flush_status | 202522 |
+---++
Thanks,
Mike Spreitzer
mos
06/25/09 01:05 PM
To
mysql@
Actually, my characterization of the current state is wrong. It appears
that one core is completely busy, I suppose MySQL does this indexing work
in a single thread. Is it reasonable for indexing to be CPU bound?
Thanks,
Mike Spreitzer
Mike Spreitzer/Watson/i...@ibmus
06/25/09 01:30 AM
nf, expanding key_buffer to 8G,
myisam_sort_buffer_size to 256M, and putting tmpdir on the fiber channel
disk.
Thanks,
Mike Spreitzer
(size of T) * (avg num
integers per string)^2 ) to O( (size of T) * (avg num integers per
string)^1 ). That's great. We have saved about a factor of 100 in my
real application (a given string is paired with something on the order of
100 different integers). But we could sa
be paired with several
strings.
Thanks,
Mike Spreitzer
SMTP: mspre...@us.ibm.com, Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
Peter Brawley
06/20/09 03:59 PM
Please respond to
peter.braw...@earthlink.net
To
Mike Spreit
did NOT say a given integer I is
associated with only one string S):
SELECT a.s, a.i, MIN(b.i) AS j
FROM t AS a
JOIN t AS b ON b.i > a.i AND a.s = b.s
GROUP BY a.i
Thanks,
Mike Spreitzer
Peter Brawley
06/20/09 12:39 PM
Please respond to
peter.braw...@earthlink.net
To
Mike Spreit
Yes, for each (S, I) pair the goal is to efficiently find the next largest
integer associated with S in T. For the highest integer I associated with
S in T, there is no next larger.
Thanks,
Mike Spreitzer
Peter Brawley
06/20/09 08:56 AM
Please respond to
peter.braw...@earthlink.net
To
times the size of T. There has to be
a better way!
Thanks,
Mike Spreitzer
number,
your column might have a large start number. Some new companies don't like
invoicing starting out at record 1. I have no experience in ndbcluster but
I would assume that it has some kind of column limit for performance gains
in indexing.
Mike O'Krongli
Acorg Inc
http://www
ine (and I
am not using replication) if necessary; is there a faster way to do that
than uninstall and reinstall?
Thanks,
Mike Spreitzer
Mike Spreitzer/Watson/i...@ibmus
06/12/09 12:57 PM
To
Michael Dykman
cc
mysql@lists.mysql.com
Subject
Re: Mysterious progress after recovery in MySQL
g it. The
server continued working on that statement for a while. I then tried
`/usr/share/mysql/mysql.server stop`; that has been in progress for a
while now, has printed about 320 dots so far. What is the fastest way to
get this thing aborted?
Thanks,
Mike Spreitzer
SMTP: mspre...@us.ibm.com, L
l
restart, the best I could hope for would be to quickly delete the
partially loaded data and start loading it all over again, right? (Now I
see why it was suggested I break this data file up into smaller pieces.)
Thanks,
Mike Spreitzer
SMTP: mspre...@us.ibm.com, Lotus Notes: Mike Spreitzer/
bin/mysqld: ready for connections.
Version: '5.1.34-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Server (GPL)
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
Thanks,
Mike Spreitzer
I find my MySQL Community Edition 5.1.34 server running out of space on
/tmp (which is indeed small). Why is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different location
instead of /tmp?
Thanks,
Mike Spreitzer
fool my package management system (RPM on RHEL) into
doing multiple installations?
Thanks,
Mike Spreitzer
Thx's Jerry, appreciate the info, very helpful. ;)
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===
- Original Message -
From: "Jerry Schwart
or storage engine, in
order to enter data like this or can this be handled with our programming, Perl?
Where using MySQL 5.0.51
Thx's,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.t
I have seen a few Windows-based utilities that proport to do this but I
am looking for something I can run on Linux.
Thanks for any help you can offer!
-Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;mysql' driver for Aubit4GL could probably do with some attention from
someone who knows their way around)
On Tuesday 07 October 2008 13:10:18 walter harms wrote:
> Mike Aubury schrieb:
> > Excellent - this seems t
e wrote:
> Hi Mike, all,
>
> Mike Aubury wrote:
> > I'm probably being a bit stupid - but I'm trying to determine (in code)
> > the length of the string in the schema for a given table.
> >
> > So - for example :
> >
> >
> > create tabl
I'm probably being a bit stupid - but I'm trying to determine (in code) the
length of the string in the schema for a given table.
So - for example :
create table a (
blah char(20)
)
I want to return '20', but I'm getting '60' when I use mysql_list_fields..
(Al
Hi all,
I'm just throwing something out ...
How about:
select a.id,b.id from dataset a left join dataset b
on a.id=b.id+1
where b.id is null;
This should find single gaps. It won't find larger gaps.
Just my $.02.
Mike.
On Thursday 18 September 2008 10:44:4
As your table grows your inserts will start to get slower and slower. You
run into the issue of locking a table due to re-creating the indexes. Also
wasted space for indexes
On 9/5/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I am looking for, is there any specific re
15 01:30 /e5servers.txt
-rwxr-xr-x 1 mysql mysql 178746 Aug 15 01:30 /e5subscribers.txt
-rwxr-xr-x 1 mysql mysql 627939 Aug 15 01:30 /e5topics.txt
[EMAIL PROTECTED] mysql]# rpm -q -a | grep -i mysql
mysql-query-browser-5.0r12-1rhel4
mysql-gui-tools-5.0r12-1rhel4
MySQL-server-community-5.0.51a-0.rh
accumulated so far. Then run "change master to master_host='192.168.1.161',
master_user='slave2', master_password='slave2;"
that is assuming your user name and password work. This will start over
again but since you at position 98. You will catch up to the master in
Do you have the original mysql> show slave status\G; off the master?
I have a feeling you have the position wrong. I about 100% sure you have
the position wrong because it happened to me.
if you don't have it do a show slave status\G; and try to remember which one
you took.
Mike
On
Did you start from position Exec_Master_Log_Pos 1? Can you tell us the
command you used to get this going?
Mike
On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine <[EMAIL PROTECTED]> wrote:
> I'm having an issue setting up a slave Where it doesn't seem to start:
>
>
On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Mike,
> Since i have done a fresh backup from master (with master db down), and
> copied over the same to slave. Then why is the slaving looking for old
> relay-log. I also did the "RESET SL
>
> regards
> anandkl
>
>
> On 5/23/08, Mike <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>> On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>>
>>> Files is owned by mysql, but the point is, these relay-log f
On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Files is owned by mysql, but the point is, these relay-log files are not
> present.
> Before setting up the slave, i cleaned up all files.
>
If you want the logs back you could use RESET MASTER maybe.
http://dev.mysql
On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud <
[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I have 2 MySQL servers.
> One master and one slave.
> In order to add new slave server, and because i can't stop the master one,
> i
> have tried this:
>
> http://forums.mysql.com/read.php?26,99846,102058
=mysql
>
> so i would have thought it would not try and replicate that db ? Although i
> did not need that in my previous configuration.
>
> Any thoughts ?
>
>
Well if your master ever fails and you make the slave your new mater you
will be missing your mysql database. User mostly will be missing, which
might not be a big thing in your situation. Are there any other logs
before and after?
Mike
On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <[EMAIL PROTECTED]>
wrote:
> Hi all!
> I must be stupid or something. I can't find what my problem is.
>
> I searched this list, and did find a couple of hits, but nothing that
> seemed fully relevant. This one in particular was interesting:
On Thu, May 22, 2008 at 9:20 AM, Tom Brown <[EMAIL PROTECTED]> wrote:
>
> Hi
>>
>> I had master-master working fin in dev - i move them to prd now and so
>> change the hostnames, on starting i see this error
>>
>> 080522 11:53:40 mysqld started
>> 080522 11:53:40 InnoDB: Started; log sequence n
e a dump, you can do it table by table, you will have
> > some
> > downtime though.
> >
> > One option might be to use a 64bit slave and make that the master and
> > then
> > add more 64 slaves.
> >
> > On 4/25/08 11:57 AM, "Mike" <[EMAIL
olumns but I
> would not try it.
> Why cant you take a dump, you can do it table by table, you will have some
> downtime though.
>
> One option might be to use a 64bit slave and make that the master and then
> add more 64 slaves.
>
>
>
> On 4/25/08 11:57 AM, "Mike&
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> As long as you use dumps to restore your databases on the new 64bit system
> (instead of the binary files) you should be fine
>
> Olaf
>
I have so much data that we can't take a mysqldump of our database. The
directory tar
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add a 64bit slave t
http://gentoo-wiki.com/HOWTO_MySQL_Replication
On 3/31/08, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> Is there a documentation on replication of MySQL Database on Gentoo
>
> Thanks and Regards
>
> Kaushal
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/my
1 - 100 of 1477 matches
Mail list logo
