Alright.. I think I see what's is happening after this latest lockup..
here's what I think is happening..
When a replace into query locks a table for a few seconds there are a boot
load of connections to the db, and then when the table is unlocked the
connections start to filter through and us
So, I found out why we had to switch all of our datetimes to timestamps:
http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
"The current time zone setting does not affect values in DATE, TIME, or
DATETIME columns."
So it appears this is a catch 22... In order to store things in UTC an
DBConvert.com announces DBForms from MS Access to PHP + MySQL v.2.1.1
release.
Our application allows you to convert mdb (Microsoft Access databases) and
MS Access forms to AJAX based WEB page using PHP and MySQL. DBForms for MS
Access to PHP + MySQL supports elements in MS Access forms such a
Had a minor crisis this morning. One of my database tables had become
corrupted.
As I've done quite a few times, I shut down the db, ran myisamchk -r and it
seemed to repair the table.
Shortly afterwards it corrupted again - seemed a little strange, but decided
I'd give it another go and ran myisam
[EMAIL PROTECTED] wrote:
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
Unless you are r
Hi,
As usual, everything is heavilly dependant on your specific scenario.
Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes
benefit from I/O (more, faster disks).
Regards,
Ricardo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
That is not a question that can be answered directly... it come down
to exactly how much data you expect to be handling, how many nodes you
plan on using and what your proposed node configuration might be..
generally, a lot of RAM always helps and in a RAM-based solution like
NDB, of course it's li
I have some queries, involving a largish number of JOIN, which
are apparently very slow or even take forever (a mysqladmin processlist
shows them remain in the "statistics" status for a long time, in most
cases I have to kill them after several minutes).
When I first had the problem I googled a
Hi,
Does anyone know if thread_concurrency works in linux or is it just
limited to Solaris and Windows?
I know the general rule is number of CPU's*2 but will this actually have
any effect with Linux's threading model?
Thanks for any help :)
Andrew
Mysql, query
This message has been scanned f
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
regards,
Spiker
Original-Nachric
all,
I am working on a budget proposal for next year to put in a MySQL cluster
but wanted to validate (or correct) a couple of assumptions:
1. do storage nodes benefit far more from additional RAM than they do from
faster CPUs/multiple cores?
2. do SQL nodes benefit more from faster CPUs/multi
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren'
Hi, and thanks Baron;
I should have been a bit clearer on the bulk insert - I am using a bulk
insert statement, as you assumed.
I'll put this onto the db server and check, I think that's a more future
proof method. Will this affect any of my linked tables (linked via the
row's primary key(id))?
-
Hi,
Esbach, Brandon wrote:
Hi all,
I'm guessing this is a fairly common question, but I've drawn a blank so
far with all workarounds possible.
Here's the rough scenario:
We have data streaming in constantly from various offsite locations.
This comprises of several details: a session, a unit of
On 8/30/07, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
>
> Hi Abhishek,
>
> Maybe it's off topic, but do you know:
> http://dev.mysql.com/downloads/other/eventum/
> a ready-to-use issue tracking system ...
> maybe also suitable for your purposes.
>
> Regards, Cor
>
> - Original Message -
> From
Hi all,
I'm guessing this is a fairly common question, but I've drawn a blank so
far with all workarounds possible.
Here's the rough scenario:
We have data streaming in constantly from various offsite locations.
This comprises of several details: a session, a unit of that session,
and a measuremen
yep, thru php it's easy: just do a utf8_decode($value). but is it
possible directly from the mysql command line.
On 31/08/2007, Ken Peng <[EMAIL PROTECTED]> wrote:
>
> On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid"
> <[EMAIL PROTECTED]> said:
> > if a table column is supposed to contain text i
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren't accepted.
example:
selec
Hello,
We seem to have a problem with the usage of GET_LOCK on our mysql
server. Is there anyone who has experienced similar behavior, or could
provide some insight into what is going on?
/Niklas
Symptoms:
* mysqld CPU-usage is 100%
* Queries of the type GET_LOCK('lock_name', 10); seems to abound
A 64-bit Gentoo Linux box had just been upgraded from MySQL 4.1 to
5.0.44 fresh (by dumping in 4.1 and restoring in 5.0.44) and almost
immediately after that, during which time the database was not used,
a crash occurred during a scripted mysqldump. So I restored and days
later, it happened aga
20 matches
Mail list logo