.
There are low-impact software solutions.
There are hardware solutions. (This is what I am used to at work; it is
severe overkill for most users.)
Bottom line: There is no best or perfect solution. First decide what
'keeps you up at night'.
-Original Message-
From: Joey L [mailto:mjh2
It sounds like you are all consultants.
On Mon, Jun 11, 2012 at 4:46 PM, Baron Schwartz ba...@xaprb.com 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 eroomy...@gmail.com wrote:
Not
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
balancing.
On Mon, Jun 11, 2012 at 7:56 PM, Joey L mjh2...@gmail.com 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.
What is the best method for this setup? master-master or master
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 shawn.l.gr...@oracle.com wrote:
On 6/11/2012 10:36 AM, Ananda Kumar wrote:
...
of 'load balancing'; it is a high availability
solution you're looking for.
On Mon, Jun 11, 2012 at 4:43 PM, Joey L mjh2...@gmail.com wrote:
I understand ..I am looking for load balancing - something that i do
not have to worry about if one server goes down - the other server
will be up
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 eroomy...@gmail.com 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
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 eroomy...@gmail.com wrote:
Joey, sounds like you've got a lot of testing to do before
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;
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
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 claudio.na...@gmail.com wrote:
Joey,
from what I can see from your
at 6:18 PM, Andrew Moore eroomy...@gmail.com 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 to have'.
pt-table-sync should assist
is 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 claudio.na...@gmail.com wrote:
Joey
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 eroomy...@gmail.com wrote:
Joey, please consult your mysql error log. Something has gone wrong on your
server where innodb is not started.
On Tue
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 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
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 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
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
On Mon, Oct 24, 2011 at 10:52 AM, Joey L mjh2...@gmail.com 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
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 operations ?
MySQLTuner 1.2.0 - Major Hayden ma...@mhtx.net
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:
/
any thoughts or help would be appricated.
thanks
On Mon, Oct 3, 2011 at 1:22 PM, Eric Bergen eric.ber...@gmail.com wrote:
Can you run show processlist in another connection while the select
count(*) query is running and say what the state column is?
On Mon, Oct 3, 2011 at 7:00 AM, Joey L mjh2
is 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 mjh2...@gmail.com 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
AM, Joey L mjh2...@gmail.com wrote:
Just as an fyi - I have other databases and their corresponding apache
websites on the same server - performing okay.
It seems that apache/mysql server is just having a hard time dealing
with the access to those pages that deal with the 9gig table
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
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 eroomy...@gmail.com wrote:
Joey, does your 'large' table get
On Thu, Oct 6, 2011 at 3:22 PM, Joey L mjh2...@gmail.com wrote:
here
another session, do a show processlist
I bet you that you will see another process updating or deleting or
inserting into the MyISAM table.
On Thu, Oct 6, 2011 at 12:35, Joey L mjh2...@gmail.com wrote:
i did google search - myisam is faster...i am not really doing any
transaction stuff
about 20 miles long.
thanks again
mjh
On Thu, Oct 6, 2011 at 7:48 PM, Jan Steinman j...@bytesmiths.com wrote:
From: Joey L mjh2...@gmail.com
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 of reads
:
set global wait_timeout=some value
You can do the same for the interactive_timeout.
Setting these values too low will cause long running queries to abort
On 10/02/2011 07:02 PM, Joey L wrote:
Variables to adjust:
max_connections ( 100)
wait_timeout ( 28800
:58 AM, Andrés Tello mr.crip...@gmail.com wrote:
have you tried
select count(yourindex) instead of select count(*) ?
On Mon, Oct 3, 2011 at 7:53 AM, Joey L mjh2...@gmail.com wrote:
Thanks for the input -
1. I will wait 48 hours and see what happens.
2. can you tell me what are some
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
?
A
On Sun, Oct 2, 2011 at 2:44 PM, Joey L mjh2...@gmail.com 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 why i did this test.
I have about 4
, Singer X.J. Wang w...@singerwang.comwrote:
Are you sure? Do a show create table and send it to us please
On Sun, Oct 2, 2011 at 10:02, Joey L mjh2...@gmail.com wrote:
thanks for the quick reply!
My table is MyISAM
further top says this:
top - 10:01:29 up 8:25, 4 users, load average
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 mjh2...@gmail.com 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 -- does
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 unsubscribe:http
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
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
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 mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new
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
is lanin1_swedish_ci which earlier mentioned that that may not be
good.
I am at a bad point here with the security being compromised and really need
some help.
Thanks,
Joey
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:http
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
so my end users do not have to
install/admin a MySQL database.
Thanks for any tips!
Joey
+--+
+ +
+ Joey Mukherjee The price
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)
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: Joey Kelly [EMAIL
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
.
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 under the best forms [of government] those
50 matches
Mail list logo