There is no "best" or "perfect" solution. First decide what
> 'keeps you up at night'.
>
>> -Original Message-
>> From: Joey L [mailto:mjh2...@gmail.com]
>> Sent: Monday, June 11, 2012 7:26 AM
>> To: mysql@lists.mysql.com
It sounds like you are all consultants.
On Mon, Jun 11, 2012 at 4:46 PM, Baron Schwartz wrote:
> Yeah -- that was an unintentional omission. There are solo consultants
> like Ronald Bradford too.
>
> On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore wrote:
>> Not forgetting Pythian, Baron ;)
>>
>>
oad balancing'; it is a high availability
> solution you're looking for.
>
>
> On Mon, Jun 11, 2012 at 4:43 PM, Joey L wrote:
>>
>> I understand ..I am looking for load balancing - something that i do
>> not have to worry about if one server goes down - the o
You listed a lot of things - but no solution - i am looking for master
- master configuration.
Any tools you have used ?
Anything concrete you can offer?
thanks
On Mon, Jun 11, 2012 at 11:39 AM, Shawn Green wrote:
> On 6/11/2012 10:36 AM, Ananda Kumar wrote:
>>
>> ...
>> Master-master allows lo
aster allows load balancing.
>
> On Mon, Jun 11, 2012 at 7:56 PM, Joey L wrote:
>>
>> I am running a site with about 50gig myisam databases which are the
>> backend to different websites.
>> I can not afford any downtime and the data is realtime.
>>
>>
I am running a site with about 50gig myisam databases which are the
backend to different websites.
I can not afford any downtime and the data is realtime.
What is the best method for this setup? master-master or master-slave?
What are the best utilities to create and maintain this setup? as far
n deploy
> and support this in production yourself with out fear of shooting yourself
> in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
> from percona.
>
> A
>
>
> On Wed, Jun 6, 2012 at 5:09 AM, Joey L wrote:
>>
>> My cu
t; in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
> from percona.
>
> A
>
>
> On Wed, Jun 6, 2012 at 5:09 AM, Joey L wrote:
>>
>> My current situation arises out of testing really - i restored a db
>> that is out of syn
5, 2012 at 3:53 PM, Joey L wrote:
>>
>> I am following or trying to follow this document:
>> http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
>>
>> I think it is running in a good state because when i query the show
>> slave state, I ge
potential
>> pitfalls and trials. Be sure your use case needs master master and that
>> you're not implementing it because you think it's 'nice to have'.
>>
>> pt-table-sync should assist you getting your data in sync but how have you
>> arrived at t
to have'.
>
> pt-table-sync should assist you getting your data in sync but how have you
> arrived at this out-of-sync predicament you find yourself in?
>
> A
>
>
>
> On Tue, Jun 5, 2012 at 11:03 PM, Joey L wrote:
>>
>> with all do respect - I am new to this -
lack of a lot of basics and I
> suggest you to read some documentation before proceeding.
>
> Maatkit is now Percona Toolkit and contains some of the best tools for
> MySQL.
>
> Cheers
>
> Claudio
>
> 2012/6/5 Joey L
>>
>> Hi -
>> I have setup mysql mul
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is
I am following or trying to follow this document:
http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
I think it is running in a good state because when i query the show
slave state, I get awaiting connection from host, like :
on server1:
mysql> SHOW MASTER STATUS;
+--
Can you explain this further ?
Sorry a little slow ?
> table count * expected connections
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i have tried different syntax -- get the same error
i am running mysqlrepair on 80G myisam table.
It is taking forever to repair - i am getting a lot of "Waiting for
table" messeges when i execute "show full processlist"
613 | p_040912 | localhost | p_040912| Query | 24 | Waiting
for table | SELECT `oldurl`, `newurl
Can anyone help for
I am running debian with mysql 5.1
I am running the backup command like this :
innobackupex --user=root --password=pass --stream=tar .^C| bzip2 - >
./xtra/052912backup.tar.bz2
and doing the restore command like this in the /var/lib/mysql directory:
tar -xvif ./xtra/052912backup.tar.bz2
and then i
>> MySQLTuner 1.2.0 - Major Hayden
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:
General S
>
> You should do EXPLAINs on your slow-running queries to find out which ones
> are likely... If it is generating a 30gig file, I'd expect it must be a very
> slow query.
>
I know why the files are being created - but is there anything i can
do on the server to accomodate for large file operation
On Mon, Oct 24, 2011 at 10:52 AM, Joey L wrote:
> I have a very large table - approx 3 or 4 gig in size.
> When i initiate a process on my webpage - mysql starts to create a
> temporary table in /tmp directory.
> Is there a way i can create this file/table ahead of time so mysql
>
I have a very large table - approx 3 or 4 gig in size.
When i initiate a process on my webpage - mysql starts to create a
temporary table in /tmp directory.
Is there a way i can create this file/table ahead of time so mysql
does not have to create it ?
thanks
mjh
--
MySQL General Mailing List
Fo
about 20 miles long.
thanks again
mjh
On Thu, Oct 6, 2011 at 7:48 PM, Jan Steinman wrote:
>> From: Joey L
>>
>> i did google search - myisam is faster...i am not really doing any
>> transaction stuff.
>
> That's true for read-only. But if you have a mix o
load vs resources. The count is going to be queued as you
> describe.
>
> A
>
> On Thu, Oct 6, 2011 at 6:09 PM, Singer X.J. Wang
> wrote:
>>
>> Okay, lets hold on for a minute here and go back. We're side tracking too
>> much.
>>
>> Lets
ybe thats why your count has such a delay. Such activity may
> be better suited to InnoDB engine (you must configure and tune for this, not
> JUST change the engine).
> HTH
> Andy
>
>
> On Thu, Oct 6, 2011 at 5:05 PM, Andrew Moore wrote:
>>
>> Joey, does your
here is mysqlreport ---
root@rider:~/tmp# ./mysqlreport --user root --password barakobomb
Use of uninitialized value $is in multiplication (*) at ./mysqlreport line 829.
Use of uninitialized value in formline at ./mysqlreport line 1227.
MySQL 5.1.49-
our problem you will need to post the queries
> running against this table along with the explain output of each problem
> query. Optimizing server settings is a good start, however, individual query
> performance sounds like your problem now.
>
> Sent from my iPad
>
> On Oct 6,
done by webcrawlers to the
site - so there is a lot of activity occuring on the 9gig tables.
thanks
mjh
On Thu, Oct 6, 2011 at 6:13 AM, Joey L wrote:
> guys - i am having such a hard time with this..it is killing me!!!
> Sorry - had to vent.
> my machine is running an tyan S2912G2NR
rwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
any thoughts or help would be appricated.
thanks
On Mon, Oct 3, 2011 at 1:22 PM, Eric Bergen wrote:
> Can you run show processlist in another connection while the select
> count(*) query is running and say what the state column i
:58 AM, Andrés Tello wrote:
> have you tried
>
> select count(yourindex) instead of select count(*) ?
>
>
> On Mon, Oct 3, 2011 at 7:53 AM, Joey L wrote:
>
>> Thanks for the input -
>> 1. I will wait 48 hours and see what happens.
>> 2. can you tell me what
first line says mysql has only been running 9
> hours. You can reset the timeouts interactivly by entering at the
> mysql prompt:
>
> set global wait_timeout=
>
> You can do the same for the interactive_timeout.
>
> Setting these values too low will cause long running qu
Also i did run mysqlcheck and i did optimize and repair the database/table..
thanks
On Sun, Oct 2, 2011 at 9:19 PM, Joey L wrote:
> The section called: Variables to adjust: --when it says ">" -- does this
> mean I have to set it higher in my.cnf file ?? and if I have a &quo
> Did you fix the issue?
>
>
> On Sun, Oct 2, 2011 at 4:05 PM, Singer X.J. Wang wrote:
>
>> Are you sure? Do a show create table and send it to us please
>>
>>
>>
>>
>> On Sun, Oct 2, 2011 at 10:02, Joey L wrote:
>>
>>> thanks for th
> On Sun, Oct 2, 2011 at 2:44 PM, Joey L wrote:
>
>> I have having issues with mysql db - I am doing a "select count(*) from
>> table" -- and it take 3 to 4 min.
>> My table has about 9,000,000 records in it.
>> I have noticed issues on my web pages so that is
I have having issues with mysql db - I am doing a "select count(*) from
table" -- and it take 3 to 4 min.
My table has about 9,000,000 records in it.
I have noticed issues on my web pages so that is why i did this test.
I have about 4 gig of memory on the server.
Is there anything I can do to fix t
35 matches
Mail list logo
