...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
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
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
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 rajl...@rajshekhar.net
In infinite wisdom
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) shawn.l.gr...@oracle.com
On 12/3/2010 03:40,
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, 2010 at 8:02
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 listan...@gmail.com wrote:
Greetings everyone.
I am in a situation where I need to do parallel inserts into MySQL database
from inside
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 hes...@gmail.com:
Mysql 5.5 -- when is it going to go GA?
And when it does, which version will it be? 5.5.8 or
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
In infinite wisdom Basil Daoust bdao...@lemonfree.com 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
In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB
again?
-Partha
- Original Message
From: Machiel Richards machi...@rdc.co.za
To: mysql mailing list mysql@lists.mysql.com
Sent: Fri, 3 December, 2010 1:38:24 PM
Subject: MySQL restore failing
Hi All
then?
The current proc tables have 16 columns.
Any ideas?
Regards
Machiel
-Original Message-
From: partha sarathy par...@mafiree.com
To: Machiel Richards machi...@rdc.co.za, mysql mailing list
mysql@lists.mysql.com
Subject: Re: MySQL restore failing
Date: Fri, 3 Dec 2010 14:02:59
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
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 could
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 machi...@rdc.co.zawrote:
HI Guys
I found some info regarding a method to upgrade mysql databases.
Currently the
vegiv...@tuxera.be
To: Machiel Richards machi...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
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
earlier.
Regards
Machiel
-Original Message-
From: Johan De Meersman vegiv...@tuxera.be
To: Machiel Richards machi...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
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
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 aim.prab...@gmail.comwrote:
Hi,
to avoid this change ur wait_timeout value to 300 Secs or less, along
with
Johan De Meersman vegiv...@tuxera.be 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
On Mon, Nov 29, 2010 at 2:21 PM, Peter Wang wangx...@gmail.com 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
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
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 vegiv...@tuxera.be wrote:
Hey,
Late last night, I got a
On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood nw...@plus.net 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
You are correct, in a master slave setup the slave does not accept writes.
John
On 22 November 2010 11:06, Machiel Richards machi...@rdc.co.za 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
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.
.
-Original Message-
From: a.sm...@ukgrid.net
To: John Daisley daisleyj...@googlemail.com
Cc: Machiel Richards machi...@rdc.co.za, mysql mailing list
mysql@lists.mysql.com
Subject: Re: MySQL replication server
Date: Mon, 22 Nov 2010 13:03:38 +
Hi,
I think you are wrong, slaves will always
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, a.sm...@ukgrid.net 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
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
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
On Mon, Nov 22, 2010 at 2:08 PM, John Daisley daisleyj...@googlemail.comwrote:
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
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 failover
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 good
@lists.mysql.com
Subject: Re: MySQL clustering and licensing
Date: Wed, 10 Nov 2010 00:09:16 +0100
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
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 =
, 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
: [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_SCHEMA.TABLES WHERE
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
/ - 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 your comment
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
-
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 and most other databases require adjustment of server settings, and
especially of table structures and indexes
/ - 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 want to determine
...@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
ExternalID = 'fred1'
Explain Extended
PM
To: Patrick Thompson; mysql@lists.mysql.com
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
So it's a primary key lookup. That's a rather large primary key though, it's
going to bloat the table size since innodb in mysql uses clustered indexes.
So the explain plan
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: mySql versus Sql
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:
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
2010/10/11 Sabika M sabika.makhd...@gmail.com:
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
Hi,
This can be useful...
http://mafiree.com/blg/?p=124
-Partha
www.mafiree.com
- Original Message
From: spacemarc spacem...@gmail.com
To: MySQL mysql@lists.mysql.com
Sent: Mon, 11 October, 2010 12:37:24 AM
Subject: MySQL sock file is missing: server doesn't start
hi
MySQL server
2010/10/11 partha sarathy par...@mafiree.com:
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
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,
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
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!
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 error
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
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), Robert P. J. Day
rpj...@crashcourse.ca 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
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 machiel.richa...@gmail.com
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
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 database is
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
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 mis...@poczta.fm wrote:
I don't think that SUM will work for varchar columns.
If I got your point right - you need to use WITH ROLLUP
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
Perfect. Exactly what I was looking for.
Cheers John.
Regards,
Neil
On Tue, Aug 31, 2010 at 12:06 PM, John Daisley
daisleyj...@googlemail.comwrote:
SELECT products_sales.language, SUM(products.rating) AS products_rating
FROM products_sales
INNER JOIN products ON products_sales.products_id
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 Tue, Aug
/10, Prabhat Kumar aim.prab...@gmail.com wrote:
From: Prabhat Kumar aim.prab...@gmail.com
Subject: Re: MySQL Server has gone away
To: Krishna Chandra Prajapati prajapat...@gmail.com
Cc: jitendra ranjan jitendra_ran...@yahoo.com, mysql@lists.mysql.com
Date: Thursday, 19 August, 2010, 4:56 PM
The account has full permission on all the databases.
--- On Fri, 20/8/10, Ananda Kumar anan...@gmail.com wrote:
From: Ananda Kumar anan...@gmail.com
Subject: Re: MySQL Server has gone away
To: jitendra ranjan jitendra_ran...@yahoo.com
Cc: Krishna Chandra Prajapati prajapat...@gmail.com
, Prabhat Kumar aim.prab...@gmail.com wrote:
From: Prabhat Kumar aim.prab...@gmail.com
Subject: Re: MySQL Server has gone away
To: Krishna Chandra Prajapati prajapat...@gmail.com
Cc: jitendra ranjan jitendra_ran...@yahoo.com, mysql@lists.mysql.com
Date: Thursday, 19 August, 2010, 4:56 PM
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
jitendra_ran...@yahoo.comwrote:
Hi,
Whenever i run any commnd on mysql it gives message as below then gives the
result successfully. What is the reason of the
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,
: Prabhat Kumar aim.prab...@gmail.com
Subject: Re: MySQL Server has gone away
To: Krishna Chandra Prajapati prajapat...@gmail.com
Cc: jitendra ranjan jitendra_ran...@yahoo.com, mysql@lists.mysql.com
Date: Thursday, 19 August, 2010, 4:56 PM
there is high chance of corruption of any data 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 kranthi_penty...@iicindia.comwrote:
Hi all,
Please send sample mysql best practice document.
Thanks Regards,
Kranthi kiran
--
Bier met grenadyn
Is
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,
Hi all,
Please send sample mysql best practice document.
Thanks Regards,
Kranthi kiran
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
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_size to 3GB
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 yhue...@msi.umn.edu wrote:
On Fri, Aug 13, 2010 at 04:33:38PM
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 tracefile
On Fri, Aug 13, 2010 at 11:47 AM, Krishna Chandra Prajapati
prajapat...@gmail.com 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,
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.
From: Manasi Save manasi.s...@artificialmachines.com
To: Michael Dykman mdyk...@gmail.com
Cc: mysql@lists.mysql.com 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
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 @
On Sun, Aug 8, 2010 at 11:49 PM, Walter Heck - OlinData.com
li...@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
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
manasi.s...@artificialmachines.com wrote:
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,
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?
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 li...@olindata.com
It would be a lot
I can't write my config parameters now.
5 августа 2010 г. 23:02 пользователь Евгений Килимчук
ekilimc...@gmail.comнаписал:
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,
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 Евгений Килимчук ekilimc...@gmail.com
I can't write my
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
vegiv...@tuxera.beнаписал:
You don't want to mess with
2010/8/5 Евгений Килимчук ekilimc...@gmail.com:
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
2010/8/5 Rob Wultsch wult...@gmail.com:
2010/8/5 Евгений Килимчук ekilimc...@gmail.com:
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
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
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
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
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?
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: [MySQL] Re: Decimal points
Thanks to everybody, and to Rob Wultsch, his link helped me to understand
what I was doing...
./configure select an automake configure or a perl one...
I ended building mysql with innodb,heap,myisam and partitions, statically
built with:
./configure --with-plugins=heap,partition,innobase,myisam
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 |
+---+-+-+---+
How do we deduce
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
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 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
601 - 700 of 9139 matches
Mail list logo