Richard, there is more to a system than number of queries.
Please post these in a new thread on http://forums.mysql.com/list.php?24 :
SHOW GLOBAL STATUS;
SHOW VARIABLES;
Ram size
I will do some analysis and provide my opinion.
-Original Message-
From: Manuel Arostegui
Am 05.04.2013 09:46, schrieb Nitin Mehta:
Thanks for your response. However, i'm not sure which case it is because in
the downloads, it says Platform: Oracle and Redhat 45. Isn't it supposed
to work?
most likely Oracle does not care about RHEL4 because it is EOL
and has no longer support
Hello Joe
On 4/5/2013 10:25 AM, Joe Kosinski wrote:
I have installed the community edition version 5.6 to my MacBook running
OSX 10.8.3. I am trying to set up MythTV backend which requires the
time zone tables to be loaded for the database I will be using.
I have not been able to load the
Joseph-Kosinskis-MacBook:bin josephkosinski$ mysql_tzinfo_to_sql
/usr/share/zoneinfo sqlLines
-bash: sqlLines: Permission denied
if you need help post your damned commands UNSTRIPPED and mask only passwords
and inline is preferred instead attachments which are wasting others time
Am
Am 06.04.2013 18:18, schrieb attee...@gmail.com:
You don't have to be a jackass to him/her.
surely, if someone is
a) to stoopid to understand that the thousands of subscribers CAN NOT
unsubscribe him
b) repeats the same line multiple times like a child
it is the sad truth that he is a idiot
You don't have to be a jackass to him/her.
The CAN SPAM act requires that a single link, with no further action on behalf
of the recipient, must be provided to unsubscribe.
I see no such thing in the footer. The website is terrible to navigate on
mobile devices... I don't see how I can
Thanks for the input. I have noticed when I wanted to remove MySql Server from
my system there were a lot of steps I had to go through and one was to modify
the config file which was locked. I used show info on the file and changed the
permissions on it to read write. Then when I tried to
Am 06.04.2013 17:46, schrieb Joseph Kosinski:
Thanks for the input. I have noticed when I wanted to remove MySql Server
from my system
there were a lot of steps I had to go through and one was to modify the
config file which
was locked
not really - the problem is you are lacking any
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
However, i'm not sure which case it is because in the downloads, it says
Platform: Oracle and Redhat 45
Isn't it supposed to work?
The downloads section is titled Oracle and Red Hat 4 and 5, but each
individual download is clearly marked as
Am 06.04.2013 12:49, schrieb Reindl Harald:
Am 06.04.2013 03:51, schrieb Joe Kosinski:
I am logged onto the system as system administrator and should have
privilege to write to the file
no you are on MACOSX
on this crippled OS a administrator is not the same as root
I have tried cd ..
hello,
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once everyday. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or deleted?
i can use update_or_create but
1.I was able to use the use mysql; to change to the mysql database and then I
ran the queries which showed that the time zone database is not populated.
2. Then I tried to find the path of mysql_tzinfo_to_sql by running the command
which mysql_tzinfo_to_sql with the following results:
I also triedmysql_tzinfo_to_sql /usr/share/zoneinfo sqlLines with the following Terminal output:
Terminal Saved Output 10
Description: Binary data
-bash: sqlLines: Permission deniedJoeBegin forwarded message:From: Joe Kosinski joj...@gmail.comSubject: Fwd: mysql_tzinfo_to_sqlDate:
I was finally able to load the time zone tables using the following:
sh-3.2#
/usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql
/usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql -u
root mysql
My version of Mac OSX 10.8.3 did not have root
If'n it were my nickel, here is how I would solve the problem (at a somewhat
high level). That is, assuming I had an ETL tool available.
1. Create landing tables for your source data.
2. Load data from the source table(s) to your new landing table(s).
3. Perform lookups from the new landing table
Hi Andrés,
Select for update makes sure that no other process can change the data between
you selected it for update and then actually changed it and commit it.
If you do not use select for update then it is possible that some other
process can change the data in the mean time between you
On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote:
You don't have to be a jackass to him/her.
He's always a jackass, but, I must say, it is a rare occasion that I
agree, and, hte *idiot* who posted all those lines was certainly more of
a jackass.
The CAN SPAM act requires that a
2013/04/06 13:56 -0700, Rajeev Prasad
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once every day. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or
Am 07.04.2013 03:26, schrieb Joe Kosinski:
I was finally able to load the time zone tables using the following:
sh-3.2# /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql
/usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql
-u root mysql
This is what happens when a large conglomerate writes large
checks. Everyone goes on the aggressive... I'm KIDDING!@!!@#!@!!
N.
On 4/6/13, Noel Butler noel.but...@ausics.net wrote:
On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote:
You don't have to be a jackass to him/her.
thx all, the source data is in text file.
- Original Message -
From: h...@tbbs.net h...@tbbs.net
To: mysql list mysql@lists.mysql.com
Cc:
Sent: Saturday, April 6, 2013 8:02 PM
Subject: Re: update a row only if any column has changed, in a very large table
2013/04/06 13:56 -0700,
21 matches
Mail list logo
