- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Correct. MyISAM is not a transactional storage engine. It has no concept
> of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock
> and as soon as the change is complete, the table is unlocked and
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or
>> with Statement-Based-Logging or with both ?
>>
>>
>
> Both.
>
>
>>
>> I don't understand the example:
>> Does "begin transaction" and
Am 01.04.2016 um 21:09 schrieb Lentes, Bernd:
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
You said, "This is done on the master, written in the log and then
replicated to the slave, "
The INSERT would not appear in the Binary log until after session 1
hat rolled back contained statements that
> changed MyISAM tables, then the entire transaction (all of the work it
> did) needs to be written into the Binary Log and REDO log just to have
> the very last command be "ROLLBACK". What that will do is create the
> same sequen
- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> What is true ? when the transaction started or when the first read is
>> performed ?
> Until you need to establish a snapshot of the data, then you don't need
> a snapshot position.
>
> The transaction
On 4/1/2016 10:08 AM, Lentes, Bernd wrote:
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
On 4/1/2016 9:12 AM, Lentes, Bernd wrote:
- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
"Unsafe" in that sense replies to the fact that certain commands can
have a different effect when processed from the Binary Log than they did
when they were executed
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
"...so that all queries within a transaction
- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
> "Unsafe" in that sense replies to the fact that certain commands can
> have a different effect when processed from the Binary Log than they did
> when they were executed originally on the system that wrote the
On 3/30/2016 1:26 PM, Lentes, Bernd wrote:
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
So i should use the default (autocommit=1)?
no, you should what is appropriate for your application
if you don't care about inserts/updates triggered by let say a
Am 30.03.2016 um 19:26 schrieb Lentes, Bernd:
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
So i should use the default (autocommit=1)?
no, you should what is appropriate for your application
if you don't care about inserts/updates triggered by let say a
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
>> So i should use the default (autocommit=1)?
>
> no, you should what is appropriate for your application
>
> if you don't care about inserts/updates triggered by let say a
> webrequest are half written due a crash
Am 30.03.2016 um 18:56 schrieb Lentes, Bernd:
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
I read that the converting is not difficult. But has the code of our webapp to
be changed ? It's written in php and perl.
What i understand is that
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
>>
>> I read that the converting is not difficult. But has the code of our webapp
>> to
>> be changed ? It's written in php and perl.
>> What i understand is that inserts/updates/deletions in InnoDB tables have to
Am 28.03.2016 um 21:36 schrieb Lentes, Bernd:
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors
Hello Bernd,
On 3/28/2016 3:36 PM, Lentes, Bernd wrote:
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
>>> You would be better served by first converting your MyISAM tables to
>>> InnoDB to stop mixing storage engine behaviors (transactional and
>>> non-transactional)
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (transactional and
non-transactional) within the scope of a single transaction. But if you
cannot convert them, using MIXED will be
- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Hello Bernd,
>
> Sorry for the delay, I wanted to make sure I had enough time to address
> all of your points.
>> He proposed to have two hosts, and on each is running a MySQL instance
>> as master AND slave.
Hello Bernd,
Sorry for the delay, I wanted to make sure I had enough time to address
all of your points.
On 3/22/2016 7:07 AM, william drescher wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know
- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com
wrote:
>>
>> Hi William,
>>
>> thanks for the try. Good idea !
>> Did you change anything ?
>>
>>
>> Bernd
>
> Yes, in the original document there were some characters that
> were put on the screen as asian
On 3/22/2016 7:49 AM, Lentes, Bernd wrote:
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
> sent for Bernd, and to see if it works from another sender
> --
> Lentes, Bernd wrote:
> Hi,
>
> i know that there is a list dedicated to replication, but when
>
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list dedicated to replication, but when
you have a look in the archive it's nearly complete empty. Really
not busy.
So i hope it's ok if i
- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 19.03.2016 um 15:23 schrieb Reindl Harald:
>>
>>
>> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
>>> one further question:
>>> if some of my e-mails get through (like this one) and others don't, it
>>> does not
Dear list admin,
i need your help. I'm trying to write an e-Mail to the list for already one
week. I always get it back because it's classified as spam.
The mail is formatted as plain-text, include neither links nor attachments. I
don't understand why it's classified as spam. Neither our domain
Am 18.03.2016 um 14:56 schrieb Chris Knipe:
Blah blah blah...
Delivery to the following recipient failed permanently:
mysql@lists.mysql.com
Technical details of permanent failure:
Your message was rejected by the server for the recipient domain
lists.mysql.com by lists-mx.mysql.com.
On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd <
bernd.len...@helmholtz-muenchen.de> wrote:
> i need your help. I'm trying to write an e-Mail to the list for already
> one week. I always get it back because it's classified as spam.
>
Ditto. I've pretty much given up on this list...
Am 19.03.2016 um 15:23 schrieb Reindl Harald:
Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
one further question:
if some of my e-mails get through (like this one) and others don't, it
does not depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that
Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail?
both
a spamfilter is typically
Am 19.03.2016 um 15:08 schrieb Lentes, Bernd:
Ok. I tried again:
pc53200:~ # nslookup 20.103.107.146.score.senderscore.com.
Server: 146.107.8.88
Address:146.107.8.88#53
Non-authoritative answer:
Name: 20.103.107.146.score.senderscore.com
Address: 127.0.4.62
My result is
Hi,
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail ?
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer
- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net:
> Am 18.03.2016 um 15:25 schrieb Lentes, Bernd:
>>
>> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be:
>>
>
> as i already told you offlist
> senderscore.com LISTED 127.0.4.67
>
> this
ent: Friday, 18 March, 2016 14:46:26
Subject: Re: need help from the list admin
Ditto. I've pretty much given up on this list...
Neither our outgoing mailserver
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#)
nor our domain
(http://mxtoolbox.com/SuperTo
e :-)
>>>
>>> - Original Message -
>>>
>>>> From: "Chris Knipe" <sav...@savage.za.org>
>>>> To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
>>>> Cc: "MySql" <mysql@lists.mysql.com&g
spam, that's
> usually caused by something on your side :-)
>
> - Original Message -
>> From: "Chris Knipe" <sav...@savage.za.org>
>> To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
>> Cc: "MySql" <mysql@lists.mysql.c
"Chris Knipe" <sav...@savage.za.org>
> > To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
> > Cc: "MySql" <mysql@lists.mysql.com>
> > Sent: Friday, 18 March, 2016 14:46:26
> > Subject: Re: need help from the list admin
>
Hello,
I got a strange problem related to a production server. It has been working OK
for months, but yesterday it start to fail. There are several batch scripts
using the database in addition to a web application using it.
The php scripts running in batch mode began to get:
mysql_connect():
You might want to comment
bind-address= 127.0.0.1
in your my.cnf and restart mysql server.
On 12/10/13 10:49, Jørn Dahl-Stamnes wrote:
Hello,
I got a strange problem related to a production server. It has been working OK
for months, but yesterday it start to fail. There are
On Saturday 12 October 2013 12:01, nixofortune wrote:
You might want to comment
bind-address= 127.0.0.1
in your my.cnf and restart mysql server.
It does not explain why it works under low load and not under high load.
However, I seem to have found something. When I started
Could be a crash related to innodb data dictionary being out of sync. Could
be a bug.
http://bugs.mysql.com/bug.php?id=55277
On 12 Oct 2013 11:21, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote:
On Saturday 12 October 2013 12:01, nixofortune wrote:
You might want to comment
bind-address
On Saturday 12 October 2013 13:07, Andrew Moore wrote:
Could be a crash related to innodb data dictionary being out of sync. Could
be a bug.
Seems like a bug yes. However, we had a strange situation yesterday when we
had several processes in the state copying to tmp table (if i remember the
Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes:
On Saturday 12 October 2013 13:07, Andrew Moore wrote:
Could be a crash related to innodb data dictionary being out of sync. Could
be a bug.
Seems like a bug yes. However, we had a strange situation yesterday when we
had several processes
On Saturday 12 October 2013 17:36, Reindl Harald wrote:
so someone did optimize table on a large table
you do yourself not a favour restarting the server in such a moment
7 hours before the server was shut down, we did a alter table to add a primary
key to a table that is read-only from the
Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes:
On Saturday 12 October 2013 17:36, Reindl Harald wrote:
so someone did optimize table on a large table
you do yourself not a favour restarting the server in such a moment
7 hours before the server was shut down, we did a alter table to add a
We had a similar issue a bit back - and although it sounds similar - based
on your followups it probably isnt, but will just toss this out there
anyhows. We were experiencing connection timeouts when load would ramp up.
Doing some digging we learned that our firewall between the servers
sounds like a scheduler issue
did you try deadline?
http://en.wikipedia.org/wiki/Deadline_scheduler
on Linux systems pass elevator=deadline as kernel param
Am 12.10.2013 20:58, schrieb Chris McKeever:
We had a similar issue a bit back - and although it sounds similar - based
on your followups
2012/09/30 11:07 -0700, Mark Phillips
The data for this table comes from a web page (charet utf8). I copy/paste word
files into gedit (on linux) and then copy/paste from gedit to a text boxes on
the web page input form. I had thought I was stripping out all the funky
characters by using a
.
If you are using PHP, see functions htmlentities() and html_entity_decode().
-Original Message-
From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
Sent: Sunday, September 30, 2012 11:08 AM
To: Rick James
Cc: h...@tbbs.net; Mysql List
Subject: Re: Need Help Converting Character
COLUMN CHARACTER SET ...; -- coming from BINARY,
this does not check the encoding.
(sorry, don't have the link handy)
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Thursday, September 27, 2012 2:24 PM
To: Mark Phillips
Cc: Mysql List
Subject: Re: Need
, don't have the link handy)
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Thursday, September 27, 2012 2:24 PM
To: Mark Phillips
Cc: Mysql List
Subject: Re: Need Help Converting Character Sets
2012/09/24 16:28 -0700, Mark Phillips
I have a table, Articles
2012/09/24 16:28 -0700, Mark Phillips
I have a table, Articles, of news articles (in English) with three text
columns for the intro, body, and caption. The data came from a web page,
and the content was cut and pasted from other sources. I am finding that
there are some non utf-8 characters in
, September 24, 2012 4:28 PM
To: Mysql List
Subject: Need Help Converting Character Sets
I have a table, Articles, of news articles (in English) with three text
columns for the intro, body, and caption. The data came from a web
page, and the content was cut and pasted from other sources. I am
finding
I have a table, Articles, of news articles (in English) with three text
columns for the intro, body, and caption. The data came from a web page,
and the content was cut and pasted from other sources. I am finding that
there are some non utf-8 characters in these three text columns. I would
like to
for the column they go in. (Presumably, all the text columns will be
declared utf8 or utf8mb4.)
-Original Message-
From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
Sent: Monday, September 24, 2012 4:28 PM
To: Mysql List
Subject: Need Help Converting Character Sets
I have a table
)?
-Original Message-
From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
Sent: Wednesday, May 23, 2012 7:10 PM
To: mysql@lists.mysql.com
Subject: Re: Need help for performance tuning with Mysql
Rick
Thank you for the reply.
1. There are only a few things worth tuning
Alex
Thank you for the advice.
Probably, we will put index (key) on both columns.
Thanks,
Yu
Alex Schaft さんは書きました:
On 2012/05/24 07:37, Alex Schaft wrote:
You are selecting a record based on the value of data_id and
thold_enabled, but don't have an index on either? Add an index for both.
If
Johnny
Thank you for the reply.
Second, make sure your Innodb buffer pool is allocating as much ram as
possible. I'd even go as far as adding another 8gb of ram to the
server. The buffer pool setting is going to give you the best
performance increase.
The problem is mainly on MyISAM engine.
NULL
Did you really mean to have 3 values (on, off, NULL)?
-Original Message-
From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
Sent: Wednesday, May 23, 2012 7:10 PM
To: mysql@lists.mysql.com
Subject: Re: Need help for performance tuning with Mysql
Rick
Thank you
Yu,
The upgrade to 5.5 that Jonny advises should NOT your first action. If
MySQL is mis-configured on 5.0 it will likely be misconfigured on 5.1 and
5.5. Test your application thoroughly on the new version before heeding
that advice. Read the change logs and known bugs. Running the upgrade might
Hi,
How much ever tuning you do at my.cnf will not help much, if you do not
tune your sql's.
Your first priority should be tune sql's, which will give you good
performance even with decent memory allocations and other settings
regards
anandkl
On Wed, May 23, 2012 at 3:45 PM, Andrew Moore
EXPLAIN SELECT ...
-Original Message-
From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
Sent: Tuesday, May 22, 2012 7:07 PM
To: mysql@lists.mysql.com
Subject: Need help for performance tuning with Mysql
Hello all.
I would like to ask for advice with performance tuning
:
SHOW CREATE TABLE
SHOW TABLE SIZE
EXPLAIN SELECT ...
-Original Message-
From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
Sent: Tuesday, May 22, 2012 7:07 PM
To: mysql@lists.mysql.com
Subject: Need help for performance tuning with Mysql
Hello all.
I would like to ask
On 2012/05/24 04:10, Yu Watanabe wrote:
2. Instead INDEXes and schema design must be studied. Please provide:
SHOW CREATE TABLE
| thold_data | CREATE TABLE `thold_data` (
`id` int(11) NOT NULL auto_increment,
`rra_id` int(11) NOT NULL default '0',
`data_id` int(11) NOT NULL
On 2012/05/24 07:37, Alex Schaft wrote:
You are selecting a record based on the value of data_id and
thold_enabled, but don't have an index on either? Add an index for both.
If data_id is unique, then you would only need an index on that.
Alex
On second thought, an index on thold_enabled
Hello all.
I would like to ask for advice with performance tuning with MySQL.
Following are some data for my server.
CPU: Xeon(TM) 2.8GHz (2CPUs - 8core total)
Memory : 8GB
OS : RHEL 4.4 x86_64
MySQL : MySQL 5.0.50sp1-enterprise
Attached file
# my.cnf.txt : my.cnf
Also following is the free command result.
total used free sharedbuffers cached
Mem: 81623807843676 318704 0 956325970892
-/+ buffers/cache:17771526385228
Swap: 8032492 235608008932
Thanks,
Yu
Yu
Hello,
I seem your mysqld doesn't use enough memory.
Date Time CPU% RSS VSZ
2012/5/22 21:00:39 109 294752 540028
if your mysqld uses InnoDB oftenly,
edit innodb_buffer_pool_size in you my.cnf.
I don't see any attachments.
First, I would upgrade to 5.5 as 5.0 is very old. The upgrade process
is painless.
Second, make sure your Innodb buffer pool is allocating as much ram as
possible. I'd even go as far as adding another 8gb of ram to the
server. The buffer pool setting is going to give
Hello Tsubasa.
Thank you for the reply. (返信ありがとうございます。)
Our high loaded DB are both INNODB and MyISAM.
Espicially , on MyISAM.
I will consider the tuning of innodb_buffer_pool_size as well.
Do you know the tips for how to tune the disk access for MyISAM?
Thanks,
Yu
Tsubasa Tanaka さんは書きました:
Hello, Yu-san,
(へろへろな英語で申し訳ないです)
Can I think that you already tweaked Index on the tables?
if you yet,please create apt indexes.
MyISAM caches only Index without data.
i take way for decreasing disk seek,
1) create more indexes on the tables,if the tables doesn't update quite often.
Hello All ~ I attempted to do a mysqldump when I got this message -- see below:
mysqldump: unknown variable 'datadir=/var/lib/mysql'
Please can someone help me.
Thanks
This message is intended only for the use of the Addressee and
may contain
Check if this is in the [mysqldump] section of your my.cnf file(s). Of
course it might not be a valid option in mysqldump...I haven't checked...
On 13 Jun 2011 17:00, Brown, Charles cbr...@bmi.com wrote:
Hello All ~ I attempted to do a mysqldump when I got this message -- see
below:
mysqldump:
Subject: Re: need help with -- unknown variable
Check if this is in the [mysqldump] section of your my.cnf file(s). Of course
it might not be a valid option in mysqldump...I haven't checked...
On 13 Jun 2011 17:00, Brown, Charles cbr...@bmi.commailto:cbr...@bmi.com
wrote:
Hello All ~ I attempted
I could be wrong but I think your problem is the unique index.
--
João Cândido de Souza Neto
robert rottermann rob...@redcor.ch escreveu na mensagem
news:4dd967a8.5040...@redcor.ch...
Hi there,
I would like to create a table that optionally links to an other table.
The field company_id in
Hi there,
I would like to create a table that optionally links to an other table.
The field company_id in the following table should be either Null or link to the
table tblCompany (`id` ).
How do I do that. The way I it now, I can not enter records where the field
company_id is null.
Thanks
2011/03/15 17:51 -0500, LAMP
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
item_id int,
org_id int,
) ENGINE=MyISAM
Need to select all (distinct) org_id they have item_id 34, 36, 58 and
63. All of them, not only some of them.
Result is org_id=2607 and
Hi!
I think that the query that you have proposed is the best possible for the
problem.
However, if there are duplicates in the orders table, then
HAVING COUNT(item_id) = 4
should be replaced with
HAVING COUNT(DISTINCT item_id) = 4
(I assume that you meant item_id and not org_id in the
On Mar 17, 2011, at 3:01 PM, Geert-Jan Brits wrote:
Indeed, I don't thing there is.
Just be sure that each record has an unique combination of org_id
and item_id, otherwise you might end up with an org_id that, for
example, references 4 times item_id 34 in 4 different records, but
no
2011/03/18 08:49 -0500, LAMP
Is here anybody from mysql development team, to suggest to build IN
ALL function?
There is a problem here: the basic operation is on the record, each record by
each record, all by itself. The solution to your problem entails acting on more
distinct records until
Yes, that was my question. Though, since English is not my first
language, let me try to post it again:
There is a list of all orgs and items org bough, from table called
orders
item_idorg_id
342607
342607
341520
362607
361520
368934
38
What I need is a list of orgs they bought all of items 34, 36, 58,
63. every of them.
Some solutions under What else did buyers of X buy at
http://www.artfulsoftware.com/infotree/queries.php.
PB
---
On 3/17/2011 12:00 PM, LAMP wrote:
Yes, that was my question. Though, since English is not
First I was thinking there is function IN ALL or something like that,
since there are functions IN and EXISTS. And I would be able to make a
query something like this
select distinct org_id, item_id
from orders
where item_id in all (34, 36, 58, 63)
order by org_id asc
But, there
Hi,
I need a help to build a query.
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
`item_id` int,
`org_id` int,
) ENGINE=MyISAM
item_idorg_id
342607
342607
341520
362607
361520
368934
3828
38
On Mar 15, 2011, at 6:18 PM, Rhino wrote:
All you should need is this:
select distinct org_id
from orders
where item_id in (34, 36, 58, 63)
I'm assuming that the DISTINCT operator is available in the version
of MySQL that you are using. I don't currently have any version of
MySQL
Hello,
Thank for your help
I just try mysqldump with --quick or --opt option ... to avoid
out of memory problem but
-- dump fails with --max_allowed_packet=2048M and --quick :
r...@pcjahia01:/# /usr/bin/mysqldump -A --max_allowed_packet=2048M
--quick --default-character-set=UTF8 -u
Hello,
Starting today, my daily database backup script does not work :-( with
mysqldump typically Out of memory error.
So, I try to change max_allowed_packet option value, but I don't succeed
(mysql run on ubuntu 10.04 OS with 5.1.41-3ubuntu12.7 0 mysql version.)
On the last successfull
;
- test1 table:
col1v_idh_id
America 1 2
- test2 table:
id name
2 SAM
1 UNCLE
- Original Message -
From: Mark Phillips m...@phillipsmarketing.biz
To: Mysql List mysql@lists.mysql.com
Sent: Monday, July 26, 2010 8:29:00 AM
Subject: Need Help Writing
I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.
Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the IDs in
table 2. I want to make a query so I get
SAM
1 UNCLE
- Original Message -
From: Mark Phillips m...@phillipsmarketing.biz
To: Mysql List mysql@lists.mysql.com
Sent: Monday, July 26, 2010 8:29:00 AM
Subject: Need Help Writing Simple Query
I have been away from sql for awhile, and can't seem to figure out how to
write
On 07/25/2010 09:29 PM, Mark Phillips wrote:
I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.
Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the
It may only be returning 51 rows but its having to read significantly more.
Get rid of the derived table join if possible. Something like
SELECT TAP.ID http://tap.id/, M.UID, TAP.FirstName, TAP.MI, TAP.LastName,
TAP.State,
TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,
I have the following query:
SELECT TAP.ID, M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State,
TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,
S.Region, S.District,Pts.TotPoints
FROM TorchAwardParticipants TAP
JOIN Members M On M.ID=TAP.CurrentMemberID
JOIN
Can you please show us the indexes on both the tables.
regards
anandkl
On Tue, Mar 16, 2010 at 11:47 PM, Jesse j...@msdlg.com wrote:
I have the following query:
SELECT TAP.ID http://tap.id/, M.UID, TAP.FirstName, TAP.MI,
TAP.LastName, TAP.State,
TAP.SchoolName, TAP.StateApproved,
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command statement from cmd to create
tables and populate them on a data base that I created in Mysql. Here is what
I did at CMD:
*I changed the directory from c:\ to mysql
*At mysql prompt i used -u root -p
How did you type the source command? Did you remember not to quote the file
name? E.g.
mysql SOURCE schema.sql
is the correct way.
Jesper
On Tue, 2 Feb 2010 10:38:08 kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command statement
On 02/01/2010 06:38 PM, kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command statement from cmd to create
tables and populate them on a data base that I created in Mysql. Here is what
I did at CMD:
*I changed the directory from c
Error 2 is No such file or directory
So, probably the file is not in the right path or you need to explicitly
provide the path to the file.
Carlos
On 2/1/2010 5:38 PM, kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command
what everyone else said... also, is there a longer version of the error? or is
it literally error 2
or error 22?
Colin
On February 1, 2010 06:38:08 pm kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a source command statement from cmd
Give the ful path of file name with in '' and try it out
Thanks
Suresh Kuna
MySQL DBA
--Original Message--
From: Colin Streicher
To: mysql@lists.mysql.com
Cc: kebede teferi
ReplyTo: co...@obviouslymalicious.com
Subject: Re: I NEED HELP ON 'SOURCE(\.) MYSQL
Sent: Feb 2, 2010 7:33 AM
what
1 - 100 of 912 matches
Mail list logo