Cameron Mann cameron.mann at 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
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 Mailing List
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.com
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 vegiv...@tuxera.be wrote:
- Original Message
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 trimur...@tulassi.com wrote:
Dear Mike Franon,
i have also faced the same problem while setting up the replication. by
that time i have added the error
was curious if anyone had any ideas?
Thanks
On Wed, Feb 20, 2013 at 5:51 PM, Mike Franon kongfra...@gmail.com 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 h.rei...@thelounge.net wrote:
Am
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 from
5.0.96 to 5.1, like I did before
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
, 2013 at 12:43 PM, Reindl Harald h.rei...@thelounge.net 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 something was wrong
a 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 kongfra...@gmail.com 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 tables, and also
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 h.rei...@thelounge.net 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
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, and installed 5.1
Then imported the tables and triggers, and and able to run
mysql_upgrade
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
PM
To: Rick James
Cc: Mihail Manolov; Mike Franon; Akshay Suryavanshi; mysql@lists.mysql.com
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 issue
at my last job. It basically involved multi-table deletes
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 kongfra...@gmail.com wrote:
Thanks everyone for suggestions.
I am doing this on a test
. That is better than 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 kongfra...@gmail.com wrote:
I am
...@gmail.com wrote:
Mike,
5.6 is GA now, so its stable release. Also you should not jump to 5.6
directly, atleast from 5.0.
There are many bug fixes and changes in 5.1, so you should consider this
way.
5.0--5.1--5.5 (all slaves first, and then the master)
And further 5.5 -- 5.6 (again all slaves
to store 3 tables that have
email address, ip address, and personal info.
On Sun, Feb 3, 2013 at 12:57 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 03.02.2013 18:52, schrieb Mike Franon:
Hi,
I was wondering what type of encryption for linux would you recommend
to encrypt the database
there is no way 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, does anyone have any good links
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
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 neil.tompk...@googlemail.com
To: [MySQL] mysql@lists.mysql.com
Sent: Thursday, November 22, 2012 9:30 AM
Subject: Basic SELECT help
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 claudio.na...@gmail.com
To: Paul Vallee val
On Wed, Mar 28, 2012 at 2:56 PM, Rich Jones r...@gun.io 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
Thank you Simon exactly what I was looking for. Appreciate the assistance.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Original
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: Biz-comm b...@biz
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
.
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
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 mdi...@diehlnet.com wrote:
Well, while we're on the subject of SQL style, can anyone tell me why
I'm always seeing people prefixing the name
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 David.
-Original Message-
From
. 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
, 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:26 pm Johan De Meersman wrote
. 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 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 and they are excellent.
- Original Message -
From: Paul DuBois paul.dub...@oracle.com
To: [MySQL] Mysql list mysql@lists.mysql.com
Cc: MikeB mpbr...@gmail.com; Philip Riebold p.rieb...@ucl.ac.uk
Sent: Thursday, October 28, 2010 1:45 PM
Subject: Re: SQL book
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 smarq
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.mysql
On Fri, 2010-09-10 at 15:57 +0200, Uwe Brauer wrote:
On Fri, 10 Sep 2010 04:43:39 -0400, Mike McMullin mwmcm...@mnsi.net
wrote:
On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
Good luck!
G
While this sounds like an idea, does anyone know
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.thunder
- Original Message -
From: Christoph Boget christoph.bo...@gmail.com
To: Mike Blezien mick...@frontiernet.net
Cc: MySQL List mysql@lists.mysql.com
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
,
Mike Spreitzer
From: Jaime Crespo Rincón jcre...@warp.es
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: Guifre Bosch Fabregas guifre.bo...@gmail.com,
mysql@lists.mysql.com
Date: 08/13/2010 04:07 AM
Subject:Re: RHEL Auto Start / stop mysql???
2010/8/12 Nunzio Daveri nunziodav
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 dnel...@allantgroup.com
Cc: MySql mysql@lists.mysql.com
Date: 08/11/2010 01
|
++-+-+--+---+--+-+-+---+-+
BTW, here are the table sizes:
mysql select count(*) from fldrcv;
+--+
| count(*) |
+--+
| 13785373 |
+--+
1 row in set (0.00 sec)
mysql select count(*) from fldsndm;
+--+
| count(*) |
+--+
|29036 |
+--+
Thanks,
Mike
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
Yes, that's it. I should be typing STRAIGHT_JOIN instead of STRAIGHT
JOIN.
Thanks!
Mike Spreitzer
serverdisk 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
,
Mike Spreitzer
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
!
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
-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 mgar...@cistrans.cl 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
must be quoted:
test use test;
Database
?
--
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
(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: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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 claudio.na...@gmail.com
To: Ken D'Ambrosio k...@jots.org
Cc: mysql mysql@lists.mysql.com
Sent: Monday, December 28, 2009 10:33 AM
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 Spreitzer
SMTP: mspre
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
. Is
this going to fly, in terms of latency for the incremental lookups and
overall load at the hosting site?
Thanks
Jerry Schwartz jschwa...@the-infoshop.com
09/21/09 03:47 PM
To
'Michael Dykman' mdyk...@gmail.com, Mike Spreitzer/Watson/i...@ibmus
cc
mysql@lists.mysql.com
Subject
RE: incremental
These are namestitles 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 jschwa...@the-infoshop.com
cc
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
|
| Threads_running | 2 |
| Uptime| 202522 |
| Uptime_since_flush_status | 202522 |
+---++
Thanks,
Mike Spreitzer
mos mo...@fastmail.fm
06/25/09 01:05 PM
To
mysql@lists.mysql.com
cc
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 Spreitzer/Watson
,
myisam_sort_buffer_size to 256M, and putting tmpdir on the fiber channel
disk.
Thanks,
Mike Spreitzer
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
. There has to be
a better way!
Thanks,
Mike Spreitzer
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 peter.braw...@earthlink.net
06/20/09 08:56 AM
Please respond
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 peter.braw...@earthlink.net
06/20/09 12:39 PM
Please respond to
peter.braw...@earthlink.net
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 peter.braw...@earthlink.net
06/20/09 03:59 PM
Please respond to
peter.braw
on the order of
100 different integers). But we could save another factor of 100. How do
I save (even a portion of) that?
Thanks,
Mike Spreitzer
Peter Brawley peter.braw...@earthlink.net
06/20/09 06:56 PM
Please respond to
peter.braw...@earthlink.net
To
Mike Spreitzer/Watson/i...@ibmus
cc
mysql
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.acorg.com
' 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
, 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/Watson/IBM
Office
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, Lotus Notes
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 mdyk...@gmail.com
cc
mysql@lists.mysql.com
Subject
Re: Mysterious progress after recovery
fool my package management system (RPM on RHEL) into
doing multiple installations?
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
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 Schwartz [EMAIL
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.thunder-rain.com
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]
someone who knows their way around)
On Tuesday 07 October 2008 13:10:18 walter harms wrote:
Mike Aubury schrieb:
Excellent - this seems to be the issue - the show create table shows :
mysql show create table a\g
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 table a (
blah char(20)
)
I want to return '20', but I'm getting '60
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..
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:47 am Jerry
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 reason
mysql
mysql-query-browser-5.0r12-1rhel4
mysql-gui-tools-5.0r12-1rhel4
MySQL-server-community-5.0.51a-0.rhel4
MySQL-client-community-5.0.51a-0.rhel4
mysql-administrator-5.0r12-1rhel4
[EMAIL PROTECTED] mysql]#
Mike Spreitzer
SMTP: [EMAIL PROTECTED], Lotus Notes: Mike Spreitzer/Watson/IBM
Office
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:
mysql show master status
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 Mon, Jul 28
that are
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 less
than 5 minutes.
Mike
On Mon, Jul
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.
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 files are not
present.
Before setting up the slave, i cleaned up all files.
If you want the logs back you could use
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 SLAVE, bit still getting error.
I
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 number 0
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:
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 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
*You
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
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 tared is
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 [EMAIL PROTECTED] wrote:
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein
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 PROTECTED] wrote:
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein
[EMAIL PROTECTED] wrote:
As long as you use dumps to restore your
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/mysql
To
1 - 100 of 1406 matches
Mail list logo