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
Can you tell me what permissions are needed for the user to run these
utilities so i can sync the tables ?
I have only assigned them replication slave right.
thanks
On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore wrote:
> Joey, sounds like you've got a lot of testing to do before you ca
But andrew do you have an answer for me why i am getting this error ?
thanks
On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore wrote:
> Joey, sounds like you've got a lot of testing to do before you can deploy
> and support this in production yourself with out fear of shooting yourself
&g
thanks - i had to reset the whole db and the error went away - do not
know what i did wrong.
thanks
On Tue, Jun 5, 2012 at 3:35 PM, Andrew Moore wrote:
> Joey, please consult your mysql error log. Something has gone wrong on your
> server where innodb is not started.
>
> On Tue, Jun
new :)
I will look at the site for active-active config - but have you had
any experience with active-active yourself?
what was your solution - i am on a seriously low budget - so any thing
free is great.
thanks
mjh
On Tue, Jun 5, 2012 at 6:42 PM, Claudio Nanni wrote:
> Joey,
>
> rea
Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore wrote:
> Joey,
>
> The master master replication topology comes with it's own 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
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni wrote:
> Joey,
>
> from what I can see from your email you
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
isplay the record that
has the date 3/26/2007.
Basically we are returning a special which is dated each Monday, any day
within that week should show the Monday value.
I appreciate your help!
Joey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
access if I setup % in the host as I have done in the past
that should allow me to login both remotely & to localhost right?
( again this works perfectly on my older box)
Hope this makes sense.
Thanks,
Joey
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB with MySQL gui to
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new style password.
Thanks
I am running MySQL-server-4.1.8-0 without problem on FC3.
This could also be hardware related.
Joey
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 1:24 PM
To: Mysql List
Subject: Still having problems with MySQL 4.1 on
E cast(cast(User
AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS
CHAR CHARACTER SET utf8)
25917 Query UPDATE mysql.user SET
Password=Password('testtest') WHERE [EMAIL PROTECTED]
Now the bad part is if this person logs in there are ti
ROR] Can't init databases
050107 14:09:12 [ERROR] Aborting
050107 14:09:12 [Note] mysqld: Shutdown complete
I hope this helps as I have already created a flat spot on my head from
banging it against the wall, and look forward to a more relaxing weekend.
Any help appreciated...
Joey
MySQL so my end users do not have to
install/admin a MySQL database.
Thanks for any tips!
Joey
+--+
+ +
+ Joey Mukherjee "Th
Hi Egor Egorov,
If I set to big5, any influence to English data? By the way, will MySQL
support UTF-8?
Thanks for your help.
At 20:18 02-27-2002, "Egor Egorov" wrote the following:
>You should set big5 character set, look at:
> http://www.mysql.com/doc/C/h/Character_sets.html
-
Dear all,
How to make MySQL with Chinese Big5 support? Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Dear all,
I am running MySQL 3.22.xx at Mandrake 8.1, how can I grade my MySQL??
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
ne because of the I/O bottlenecks between
machines. We are planning on doing what we can to compensate
for this. That said, what kid of experiences have you and others
had with mysql and clusters?
--Joey
From: "Gary Huntress" <[EMAIL PROTECTED]>
To:
Howdy.
My company needs to implement a data mining setup. I am
building a cluster using dual athlons and perhaps firewire instead of
100baseTX.
I need to find out as much as I can from those who have done
mysql on beowulfen. Please contact me at [EMAIL PROTECTED]
Thanks :)
+++
Joey
Howdy.
My company needs to implement a data mining setup. I am
building a cluster using dual athlons and perhaps firewire instead of
100baseTX.
I need to find out as much as I can from those who have done
mysql on beowulfen. Please contact me at [EMAIL PROTECTED]
Thanks :)
+++
Joey
27;ll
probably do that later tonight.
Ok, I'm sure I made a stupid blunder somewhere, but can anyone
tell me what to do?
Thanks :)
+++
Joey Kelly
/Minister of the Gospel | Computer Networking Consultant/
http://nolalinuxcoop.dhs.org/~jkelly/home/
"Experience hath shewn, that even
50 matches
Mail list logo
