Did a tried MaatKit? MaatKit let you control over the number of threads
dedicated to extract a MySQL backup.
Best regards.
--
Wagner Bianchi
2010/12/31 Lydia Rowe
> In order to get a database into A .SQL file, I usually import the raw
> files, .MYI and such, into a database and then run mysqld
Message-
> From: Johan De Meersman
> To: Machiel Richards
> Cc: mysql mailing list
> Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
> Date: Tue, 30 Nov 2010 11:29:29 +0100
>
> I suspect you need to have the new version running instead of the old
> one, for the m
Hi, I think you didn't run mysql_upgrade script.
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0...@gmail.com
2010/12/3 Shawn Green (MySQL)
> On 12/3/2010 03:40, Machiel Richards wrote:
>
>
Hi.
Can you show me some of your critical system logs?
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0...@gmail.com
2010/12/7 Raj Shekhar
> In infinite wisdom Basil Daoust wrote:
>
> >
Hi.
MySQL do the sql parse in the single way, just one thread. So if there
are parallel insert statement, it will not faster than before.
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
2010/12/17 Andy
> Shaw
Shawn/Krishna,
Thank you. I will try this.
-Andy
On Tue, Dec 14, 2010 at 8:13 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Andy,
>
> I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30%
> faster than normal inserts.
>
> Krishna
>
>
> On Tue, Dec 14, 201
not sure,maybe help to you:
http://forge.mysql.com/wiki/Development_Cycle#GA_releases
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/15 Hank :
> Mysql 5.5 -- when is it going to go GA?
>
> And when it does, which version will it be? 5.5.8 or 5.5.6rc?
>
> Thank
Hi Andy,
I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30%
faster than normal inserts.
Krishna
On Tue, Dec 14, 2010 at 8:02 AM, Andy wrote:
> Greetings everyone.
>
> I am in a situation where I need to do parallel inserts into MySQL database
> from inside my Perl program.
On 12/13/2010 21:32, Andy wrote:
Greetings everyone.
I am in a situation where I need to do parallel inserts into MySQL database
from inside my Perl program. Basically, I have several million records to
insert into the database, and hence I would rather do them in parallel than
doing them one at
In infinite wisdom Basil Daoust wrote:
> Any help greatly appreciated.
>
> Our mysql is restarting a LOT!
> Here is what is in the log, it doesn't seem to give much help.
>
Do you have the coredump from this crash? If yes, can you load the core
dump into gdb and run "bt" (backtrace) and see w
On Fri, December 3, 2010 14:11, Basil Daoust wrote:
> Any help
greatly appreciated.
>
> Our mysql is restarting a
LOT!
> Here is what is in the log, it doesn't seem to give much
help.
>
> --start of log--
> InnoDB: Warning: a
long semaphore wait:
> 101203 15:12:40 - mysqld got signal 11;
> This
On 12/3/2010 03:40, Machiel Richards wrote:
I checked now and saw that they have already attempted a restore
previously and hence the original table was dropped and recreated.
I found some links on the internet stating that after restoring the
dump file to the new version, the proc table sh
?
The current proc tables have 16 columns.
Any ideas?
Regards
Machiel
-Original Message-
From: partha sarathy
To: Machiel Richards , mysql mailing list
Subject: Re: MySQL restore failing
Date: Fri, 3 Dec 2010 14:02:59 +0530 (IST)
In mysql 5.1, mysql.proc table contains 20
In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB
again?
-Partha
- Original Message
From: Machiel Richards
To: mysql mailing list
Sent: Fri, 3 December, 2010 1:38:24 PM
Subject: MySQL restore failing
Hi All
I am hoping that someone could assist
earlier.
Regards
Machiel
-Original Message-
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100
I suspect you need to have the new version running instead of the old
one, for the
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100
I suspect you need to have the new version running instead of the old
one, for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards
I suspect you need to have the new version running instead of the old one,
for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards wrote:
> HI Guys
>
> I found some info regarding a method to upgrade mysql databases.
>
>Currently the version is at mys
On Mon, Nov 29, 2010 at 2:21 PM, Peter Wang wrote:
> We had have a similar problem caused by broken network-card, use
> `/sbin/ifconfig | grep errors' to check errors/dropped counter. for
> example, broken network-card may cause many connections, since normal
> tcp connect open/close can't be co
Johan De Meersman writes:
Hi,
You may check the network at that time.
We had have a similar problem caused by broken network-card, use
`/sbin/ifconfig | grep errors' to check errors/dropped counter. for
example, broken network-card may cause many connections, since normal
tcp connect open/cl
300 seconds is 5 minutes, while this whole thing happened probably under a
minute. I'm looking for possible causes, not workarounds :-)
On Fri, Nov 26, 2010 at 8:57 PM, Prabhat Kumar wrote:
> Hi,
>
> to avoid this change ur "wait_timeout" value to 300 Secs or less, along
> with this you can als
Hi,
to avoid this change ur "wait_timeout" value to 300 Secs or less, along
with this you can also write a script to kill those process (mysql process)
which are in sleep mode for more than certain time..
hope this will helpful..
On Wed, Nov 24, 2010 at 6:41 PM, Johan De Meersman wrote:
> On
On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood wrote:
> Quick thought: what is your idle timeout set to on the MySQL server?
> Could you have configured it to reap these idle connections?
>
I could, probably, but the applications are generally well-behaved, and it's
not a recurring problem. I hope.
Seen this a lot with poorly written web apps which open connections but dont
close them when finished. Try setting wait_timeout and/or
interactive_timeout to close unused connections.
John
On 24 November 2010 11:27, Johan De Meersman wrote:
> Hey,
>
> Late last night, I got a call that one of
On Mon, Nov 22, 2010 at 2:08 PM, John Daisley wrote:
> The replicated database should not be accepting writes, if it is then you
> haven't set it up correctly
>
*shrug*
I never bother. The slave is way too useful to fuck around with
optimisations and whatnot, reporting tools tend to do useful ag
Hi,
so yes you can do that, but then I guess you cannot set the server
hosting database A as readonly (from memory this can only be set
server wide, but worht checking it out). Which might leave you a few
options to ensure data integrity, for example simply by user security
either by di
Additionally, if a user has the SUPER privilege (eg. all privileges on
*.*) they can write to a database running in read-only mode. Yet
another reason to never allow this privilege for general purpose users.
Tyler
On 11/22/10 8:08 AM, John Daisley wrote:
The replicated database should not be
The replicated database should not be accepting writes, if it is then you
haven't set it up correctly
On 22 November 2010 13:03, wrote:
> Hi,
>
> I think you are wrong, slaves will always accept writes unless you set
> readonly in the mysql config.
> Due to this, and if you dont specifically se
.
-Original Message-
From: a.sm...@ukgrid.net
To: John Daisley
Cc: Machiel Richards , mysql mailing list
Subject: Re: MySQL replication server
Date: Mon, 22 Nov 2010 13:03:38 +
Hi,
I think you are wrong, slaves will always accept writes unless you
set readonly in the mysql config.
Due
Hi,
I think you are wrong, slaves will always accept writes unless you
set readonly in the mysql config.
Due to this, and if you dont specifically set readonly on the slave
you have to be very careful in order to maintain data integrity on the
slave and also not to break repliacton. Tools
You are correct, in a master slave setup the slave does not accept writes.
John
On 22 November 2010 11:06, Machiel Richards wrote:
> Hi All
>
>sorry to bother everyone again. but now I have a question from a
> client which I am sure about my answer, however need to confirm.
>
>When
Hi!
Machiel Richards wrote:
> Good day
>
>thank you all for the responses thus far.
>
> Just to add onto the requirements.
>
>The client's business is based around a website that does all
> business related tasks and are exremely utilized.
>
> The idea is to provide f
ponse times.
Any ideas on this will help us out in making the final
decisions.
Ps there are only 2 machine available for the databases.
Regards
-Original Message-
From: Joerg Bruehe
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: MySQL clustering and lice
Hi!
Machiel Richards wrote:
> Good day all
>
> Maybe someone can assist me here as I am not sure where to get this
> information from and I need this for a proposed environment for a
> client.
>
>
> 1. The client will have 2 new machines, had a look at the specs and
> it is fairly goo
I don't see any thing written dmesg and message releated to this.
Does this have to do something with performance tuning? or can be
tuned to make better.
my.cnf looks:
[mysqld]
key_buffer = 128M
sort_buffer = 1M
join_buffer = 1M
max_allowed_packet = 8M
max_heap_table_size = 16M
table_cache = 102
om
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
It's not much, but the dataset is definitely larger than your buffer pool. You
could try this query to show how much data+index is in innodb: SELECT
SUM(data_length+index_length) as data size FROM INFORMATION_SCHE
ber 25, 2010 2:24 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: RE: mySql versus Sql Server performance
Here's the innodb stuff - although the largest data set I've used in the stats
run is around 20MB, which doesn't seem like much to me.
'innodb_adaptive_hash_index
Sorry, that should be 200MB not 20MB (still doesn't seem like much to me)
Patrick
myList - everything you could possibly want (to buy)
-Original Message-
From: Patrick Thompson
Sent: Monday, October 25, 2010 5:24 PM
To: 'Gavin Towey'; mysql@lists.mysql.com
Subject: RE: m
'0'
'innodb_mirrored_log_groups', '1'
'innodb_open_files', '300'
'innodb_rollback_on_timeout', 'OFF'
'innodb_stats_on_metadata', 'ON'
'innodb_support_xa', 'ON'
'innodb_sync_spin_loops
son [mailto:patrick.thomp...@channelintelligence.com]
Sent: Monday, October 25, 2010 12:31 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: RE: mySql versus Sql Server performance
Query:
SELECT *
FROM Item
WHERE CollectionID = 'a0d3937b-f5a8-0640-dec8-bdd60f7f4775' AND
Ext
list.com/> - everything you could possibly want (to buy)
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, October 25, 2010 3:53 PM
To: Patrick Thompson; gto...@ffn.com; mysql@lists.mysql.com
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
Patrick-
you'll w
on of the same problems.
Patrick
myList - everything you could possibly want (to buy)
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Monday, October 25, 2010 2:00 PM
To: Patrick Thompson; mysql@lists.mysql.com
Subject: RE: mySql versus Sql Server performance
MySQL
MySQL and most other databases require adjustment of server settings, and
especially of table structures and indexes to achieve the best performance
possible.
If you haven't examined index usage for the queries you're running, or adjusted
server memory settings from defaults, then it's no surpr
list.com/> - everything you could possibly want (to buy)
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Monday, October 25, 2010 9:55 AM
To: Patrick Thompson
Cc: mysql@lists.mysql.com
Subject: Re: mySql versus Sql Server performance
I merely skimmed it, but y
I merely skimmed it, but your comment that you pay the query compilation
cost on every request suggests to me that you're not using prepared
statements. If you can, you should :-)
Also, MySQL *does* support SPs, from 5.0 onwards or something. You could
split into separate modules for pre- and post
Bruijne,
Thank you for responding.
The my.cnf file was fine, but when you mentioned it, it sparked a long
forgotten memory that there was something specific to Ubuntu that
affects who has access to files like my.cnf.
After a little web searching, I realized it is a security thing called
"Apparm
Check whether mysql is running:
ps aux | grep mysqld
If MySQL is not running, check /var/log/mysql/error.log for errors.
Have you changed /etc/mysql/my.cnf and/or /etc/mysql/conf.d/*.cnf or are
are you still using the default config files from Ubuntu?
On 10/16/2010 06:30 PM, Dave M G wrote:
2010/10/11 Sabika M :
> are the permissions on that directory correct? The .sock file is created at
> start up by mysql
mysqld doesn't start because are missing /var/run/mysqld dir and
/var/run/mysqld/mysqld.sock file. Dir and file are created on mysqld
boot, i presume. It's cyclic!
2010/10/12 par
More often than not, this is a file permission issue. Does the MySQL
user have permission to create a socket in /var/run/mysqld ?try
ls -ld /var/run/mysqld
ls -l /var/run/mysqld
and make sure everything is owned by the MySQL user.
- michael dykman
On Mon, Oct 11, 2010 at 2:09 PM, spacemar
2010/10/11 partha sarathy :
> Hi,
>
> This can be useful...
> http://mafiree.com/blg/?p=124
i've checked your link but it doesn't work.
mysqld server is not running and if i want to start it i obtain 2002
error because the /var/run/mysqld/mysqld.sock file is missing.
If i start it with "sudo mysq
Hi,
This can be useful...
http://mafiree.com/blg/?p=124
-Partha
www.mafiree.com
- Original Message
From: spacemarc
To: MySQL
Sent: Mon, 11 October, 2010 12:37:24 AM
Subject: MySQL sock file is missing: server doesn't start
hi
MySQL server doesn't start because #2002 the
/var/run/my
> How can we get our MySQL db upgraded to this version or greater ?
You can also find these at:
http://dev.mysql.com/downloads/
Cheers,
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 10/4/2010 12:32 PM, Tompkins Neil wrote:
Account Number : uk600724
Dear Sir/Madam,
The MySQL database version which you have supplied to us is version 5.0.77.
However, it would appear that we require version to be at least 5.1.43.
How can we get our MySQL db upgraded to this version or g
Yeah I have been using the latest 5.1.51 one.
# ./mysqld -V
100928 17:07:55 [Warning] '--skip-locking' is deprecated and will be
removed in a future release. Please use '--skip-external-locking'
instead.
./mysqld Ver 5.1.51-log for pc-linux-gnu on i686 (MySQL Community Server (GPL))
Thanks!
20
Hi,
On 21-9-2010 5:25, Tim Thorburn wrote:
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
It's also amazing how frustrating it is for those who are searching for
the problem you mentioned to only find threads with '
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
On 9/20/2010 10:58 PM, Tim Thorburn wrote:
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The erro
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), "Robert P. J. Day"
wrote:
> no, i don't want to start a flame war, i just want some feedback on
> a current list of mysql "drawbacks" WRT postgresql.
>
> in the context of a fully open-source, java based ECM product, there
> is a FAQ entry that summarize
Hi Machiel, all!
Machiel Richards wrote:
> Good day all
>
> I am looking for someone that can maybe help me with some info
> regarding the upgrading of MySQL.
>
> We have a MySQL database currently running with a master/slave
> replication setup.
>
> The current version of the dat
On 03/09/2010 12:23 p, Machiel Richards wrote:
Good day all
I am looking for someone that can maybe help me with some info
regarding the upgrading of MySQL.
We have a MySQL database currently running with a master/slave
replication setup.
The current version of the database is
If you planing to migrate to a new hardware, then install the new version of
mysql and take dump of the current data and imported into ur new m/c and
test your app. If you all looks fine, then ur done.
regards
anandkl
On Fri, Sep 3, 2010 at 3:53 PM, Machiel Richards wrote:
> Good day all
>
>
Hi,
I also wondered, if there is any way to LIMIT the products.rating for each
language to say the top 25 ?
Cheers
Neil
On Tue, Aug 31, 2010 at 12:11 PM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote:
> Perfect. Exactly what I was looking for.
>
> Cheers John.
>
> Regards,
> Neil
>
> On
Perfect. Exactly what I was looking for.
Cheers John.
Regards,
Neil
On Tue, Aug 31, 2010 at 12:06 PM, John Daisley
wrote:
> SELECT products_sales.language, SUM(products.rating) AS products_rating
>
> FROM products_sales
> INNER JOIN products ON products_sales.products_id = products.products_id
SELECT products_sales.language, SUM(products.rating) AS products_rating
FROM products_sales
INNER JOIN products ON products_sales.products_id = products.products_id
WHERE products.enabled = 1
AND products_sales.language IN ('EN','ES')
GROUP BY products_sales.language
Will give the sum for each la
Sorry I don't want to SUM the varchar columns. This is the parameter passed
that defines the two different queries.
On Tue, Aug 31, 2010 at 11:48 AM, misiaQ wrote:
> I don't think that SUM will work for varchar columns.
> If I got your point right - you need to use WITH ROLLUP grouping
> http
I don't think that SUM will work for varchar columns.
If I got your point right - you need to use WITH ROLLUP grouping
http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
see second example on that page.
regards,
m
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@
relay log
'/var/run/mysqld/mysqld-relay-bin.01' (relay_log_pos 4)
100817 6:42:11 [ERROR] Could not find target log during relay log initialization
100817 6:42:11 [ERROR] Failed to initialize the master info structure
100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections.
Vers
The account has full permission on all the databases.
--- On Fri, 20/8/10, Ananda Kumar wrote:
From: Ananda Kumar
Subject: Re: MySQL Server has gone away
To: "jitendra ranjan"
Cc: "Krishna Chandra Prajapati" , "Prabhat Kumar"
, mysql@lists.mysql.com
Date: Fr
ead_cache_size': unsigned value
> 33554432 adjusted to 16384
> 100817 6:42:10 InnoDB: Started; log sequence number 0 44054
> 100817 6:42:11 [Warning] Neither --relay-log nor --relay-log-index were
> used; so replication may break when this MySQL server acts as a slave and
> has hi
y-bin.01' (relay_log_pos 4)
100817 6:42:11 [ERROR] Could not find target log during relay log initialization
100817 6:42:11 [ERROR] Failed to initialize the master info structure
100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/va
there is high chance of corruption of any data files, but it will clear only
after looking of your error file (generated by mysql) can you post the 50
last lines of your mysql error file.
On Thu, Aug 19, 2010 at 4:35 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Jitendra,
>
Hi Jitendra,
Check your error log file. Some thing might have gone wrong.
Krishna
On Wed, Aug 18, 2010 at 9:41 PM, jitendra ranjan
wrote:
> Hi,
>
> Whenever i run any commnd on mysql it gives message as below then gives the
> result successfully. What is the reason of the below error message :
>> 1. Make sure it works
Change this to
1. Make sure it works efficiently and is correctly configured!
Meaning - Just because it works now doesn't mean its going to work when you
put the system live and 2000 users hit the system ;) Don't just accept the
defaults in the sample my.cnf/my.ini files,
1. Make sure it works
2. Make sure it's secure
3. Make sure you have backups
On Mon, Aug 16, 2010 at 7:58 AM, Kranthi wrote:
> Hi all,
>
> Please send sample mysql best practice document.
>
>
>
> Thanks & Regards,
>
> Kranthi kiran
>
>
>
>
--
Bier met grenadyn
Is als mosterd by de
Hi all,
Please send sample mysql best practice document.
Thanks & Regards,
Kranthi kiran
On Fri, Aug 13, 2010 at 11:54:02AM -0700, Rob Wultsch wrote:
> # file /usr/local/mysql/bin/mysqld
> /usr/local/mysql/bin/mysqld: ELF 64-bit LSB executable, AMD x86-64,
> version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared
> libs), for GNU/Linux 2.4.0, not stripped
>
it is 64bit
On Fri, Aug 13, 2010 at 11:47 AM, Krishna Chandra Prajapati
wrote:
> Hi Yectli,
>
> I am talking about mysql server. Is it 32bit or 64bit.
>
> Provide some additional information. mysql configuration file, show
> variables, Error log file details etc.
>
> Kirshna
>
> On Fri, Aug 13, 2010 at 8:36 P
On Sat, Aug 14, 2010 at 12:17:20AM +0530, Krishna Chandra Prajapati wrote:
> Hi Yectli,
>
> I am talking about mysql server. Is it 32bit or 64bit.
>
> Provide some additional information. mysql configuration file, show
> variables, Error log file details etc.
>
> Kirshna
>
i provided the trace
Hi Yectli,
I am talking about mysql server. Is it 32bit or 64bit.
Provide some additional information. mysql configuration file, show
variables, Error log file details etc.
Kirshna
On Fri, Aug 13, 2010 at 8:36 PM, Yectli Huerta wrote:
> On Fri, Aug 13, 2010 at 04:33:38PM +0530, Krishna Chandr
On Fri, Aug 13, 2010 at 04:33:38PM +0530, Krishna Chandra Prajapati wrote:
> Hi Yectli,
>
> In mysql configuration file (my.cnf) you have given
>
> key_buffer_size = 5G
>
> For 32bit OS it should be less than or equal to 4GB and for 64bit it can be
> greater than 4GB.
> Reduce the key_buffer_siz
Hi Yectli,
In mysql configuration file (my.cnf) you have given
key_buffer_size = 5G
For 32bit OS it should be less than or equal to 4GB and for 64bit it can be
greater than 4GB.
Reduce the key_buffer_size to 3GB and try.
_Kirshna
On Fri, Aug 13, 2010 at 3:02 AM, Yectli Huerta wrote:
> Hello,
rds,
Nitin
From: Manasi Save
To: Michael Dykman
Cc: "mysql@lists.mysql.com"
Sent: Tue, August 10, 2010 10:34:37 AM
Subject: Re: MySQL data get and set problem
Hi Michale,
I have made that parameter column name change. but I am unable to
understand how even after
Hi Michale,
I have made that parameter column name change. but I am unable to
understand how even after execution of update statement and commit
after that, data is getting reverted.
Any inputs on this will be a great help.
--
Regards,
Manasi Save
On Mon, 9 Aug 2010 14:11:19 -0400, Michael
You might have better results if you use unique identifiers:
Select MyID From Test Where TestID = TestID;
I'm not sure how mysql is supposed to tell the param 'TestID' from the
column name.
- michael dykman
On Mon, Aug 9, 2010 at 3:10 AM, Manasi Save
wrote:
> Dear All,
>
> Table values are g
On Sun, Aug 8, 2010 at 11:49 PM, Walter Heck - OlinData.com
wrote:
> Unless you have a very good reason, you probably shouldn't go with
> cluster in the first place. If it is HA you want to have, check out
> other options like MMM for MySQL (http://mysql-mmm.org), DRBD
> +Heartbeat and others.
> C
Unless you have a very good reason, you probably shouldn't go with
cluster in the first place. If it is HA you want to have, check out
other options like MMM for MySQL (http://mysql-mmm.org), DRBD
+Heartbeat and others.
Can you tell us a bit more about your goals/desires?
Walter Heck
Engineer @ Op
2010/8/5 Rob Wultsch :
> 2010/8/5 Евгений Килимчук :
>> When OOM-killer kill mysqld, I had a critical corrupted tables. My database
>> is a very big. I think Apache with cgi-scripts not critical process in this
>> story. And sshd is a real true.
>>
>
> OOM is configurable via the proc filesystem vi
2010/8/5 Евгений Килимчук :
> When OOM-killer kill mysqld, I had a critical corrupted tables. My database
> is a very big. I think Apache with cgi-scripts not critical process in this
> story. And sshd is a real true.
>
OOM is configurable via the proc filesystem via /proc//oom_adj .
You can set t
When OOM-killer kill mysqld, I had a critical corrupted tables. My database
is a very big. I think Apache with cgi-scripts not critical process in this
story. And sshd is a real true.
6 августа 2010 г. 0:09 пользователь Johan De Meersman
написал:
> You don't want to mess with OOM too much - you r
You don't want to mess with OOM too much - you risk it killing off other
useful/critical things, like SSH daemons, the Apache root, what have you.
Add more memory to the box or split the webserver off to another system, I'd
say.
2010/8/5 Евгений Килимчук
> I can't write my config parameters no
I can't write my config parameters now.
5 августа 2010 г. 23:02 пользователь Евгений Килимчук
написал:
> Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script some
> time made heavy load when used many memory and used SWAP. OOM-killer must
> kill new cgi-forks, wich use many memory
Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script some
time made heavy load when used many memory and used SWAP. OOM-killer must
kill new cgi-forks, wich use many memory, but it kill mysqld and sshd.
2010/8/5 Walter Heck - OlinData.com
> It would be a lot better to make sure y
It would be a lot better to make sure your server doesn't turn
OOM-psycho on you. The most common case of this happening is that you
have set the memory-settings in your my.cnf in such a way that it
allows MySQL to use more memory then you have available. Could you
post your my.cnf here by chance?
On 7/21/2010 12:16 PM, Nunzio Daveri wrote:
database is around 150GB with over 5,000 tables. To make things worse, if I
shutdown MySQL, top-c still says all the memory is still used? Is this a bug,
why would it say all the memory is used when I turn off MySQL. The weird thing
is that when I rebo
hello ash...@pcraft.com;
where is the solution:
You have table A, so copy the entire table in another table. Table B.
so Table A=Table B (only in data no constrains)
then [id]=id you want to search
Untitled
select B.cod,count(*) entrysA from A,B where
A.atrib1=B.atrib1 and
A.atrib2=B.atrib2 and
A
FLOOR() CEIL() or ROUND()
SELECT ROUND(1+1.6, 0);
= 3
SELECT FLOOR(1+1.6);
= 2
SELECT CEIL(1+1.6);
= 3
Steven Staples
> -Original Message-
> From: Ashley M. Kirchner [mailto:ash...@pcraft.com]
> Sent: July 20, 2010 1:52 PM
> To: mysql@lists.mysql.com
> Subject: Re: [MyS
On 7/20/2010 10:07 AM, Chris W wrote:
I try to avoid asking why but in this case I have to. I can't imagine
wanting to have a list of numbers displayed and not have them all
aligned right with the sane number of digits after the decimal
point. So why would you even want to do this is?
Hi Mike, all!
Mike Spreitzer schrieb:
> Today I downloaded MySQL-server-community, MySQL-client-community,
> MySQL-shared-community, and mysql-workbench-gpl to install on an
> RHEL5/x86_64 machine. The first three installed just fine. The fourth
> failed due to a large pile of missing depend
Ashley,
> I can't go back to the client and tell them their schema
> is really messed up and to store their data differently.
You can hope that's not not necessary in order to deliver the requested
query, but it's a bad mistake to rule it out altogether, since it often
happens that accomplish
On 7/19/2010 11:08 AM, Shawn Green (MySQL) wrote:
Just because someone hands you a set of data to *start* with, does not
mean that you must only use that data to *work* with.
You should be able create additional tables derived from the original
data and work with those as part of your analysis
On 7/19/2010 10:48 AM, Michael Dykman wrote:
Not quite sure what the question is.
from:
mysql> select * from table where id='1';
+---+-+-+---+
| 1 | 123 | 0.0 | C |
| 1 | 234 | 0.1 | D |
| 1 | 345 | 0.0 | D |
| 1 | 456 | 0.1 | C |
| 1 | 567 | 0.1 | G |
+
On 7/19/2010 12:36 PM, Ashley M. Kirchner wrote:
I may be going at this completely wrong but at the moment I'm
stuck. I have a DB from a client and need to do several searches on
it. This one sentence is important because it's their DB, not mine. So
I can't modify the way the DB was cr
601 - 700 of 9506 matches
Mail list logo