ItÂ’s that time again. Time for fame and fortune! Sorry, as usual there is
no fortune, but the good news is that our readership continues to grow so
author fame is imminent. We are planning the winter issue of MySQL
Magazine (http://www.mysqlzine.net). With the new GA release of MySQL
server 5.1 las
On Dec 9, 2008, at 2:27 PM, Daevid Vincent wrote:
Also, I realize you're trying to 'encode' some sort of X\Y\Z
coordinates
in that column, so perhaps a different delimiter such as the pipe "|"
character or "," would be more appropriate than a \ which has special
meanings?
That's actually how
On Dec 9, 2008, at 2:03 PM, Daevid Vincent wrote:
Do you seriously have a column named "0020,0032" ?!!?
And don't even get me started on the actual name of these images
(column
data).
Jepp, and there are a hell of a lot of more weird number like that.
That's an attribute tag from DICOM ima
Also, I realize you're trying to 'encode' some sort of X\Y\Z coordinates
in that column, so perhaps a different delimiter such as the pipe "|"
character or "," would be more appropriate than a \ which has special
meanings?
Or possibly just split them out into separate X, Y, Z columns rather
than c
Do you seriously have a column named "0020,0032" ?!!?
And don't even get me started on the actual name of these images (column
data).
Wow. That makes my head hurt.
I think mySQL is just punishing you for both of those offenses. *hee
hee* ;-p
But if I were to venture a guess, and RTFM...
http:/
Hi,
I'm trying to compare strings on a varchar field.
The code: 'select * from Image where `0020,0032`="-131.178600\
\107.113725\\200.064000";' returns the correct result set.
However, the code: 'select * from Image where `0020,0032` LIKE
"%-131.178600\\107.113725\\200.064%";' returns an em
On Mon, Dec 8, 2008 at 7:14 AM, Mogens Melander <[EMAIL PROTECTED]> wrote:
> Hi list
>
> I have this statement that really need optimizing. The result is
> about 5500 rows, and it runs for about 3-5 minutes. If i do the
> same in a PHP script (outer loop, inner loop) it run in 20 sec.
>
> The idea
Thanks to everyone who offered their suggestions. Those of you who
suggested I look into SElinux were correct - my admin adjusted the policy
and rebooted the server, and my problem is solved.
I've never run across that issue before, but I'll know to look for it in the
future. The list & the comm
>-Original Message-
>From: Brent Baisley [mailto:[EMAIL PROTECTED]
>Sent: Saturday, December 06, 2008 11:35 AM
>To: sangprabv
>Cc: mos; mysql@lists.mysql.com
>Subject: Re: Randomize by Score and DESC
>
>That's because RAND() is a decimal (0.37689672). Try score*RAND().
>
[JS] That in its
>The idea is that data in tdata "might" be shared between 2 or more
records in main.
Is this any faster?
select m.code, m.parent, t.data
from main m
left join tdata t
on t.code = m.parent and t.country='dk'
where m.parent=0 and m.active = 'on' and m.tdataon = 'on'
union
select m.code, m.parent,
MySQL processes each request in a separate thread... hence, it is
*always* multi-core capable. Check the thread_concurrency setting in
my.cnf. Also, although not exactly related, check the size of
thread_cache.
Are you by chance running 1 long-running query at a time? A single
query runs in a sing
Kunal Jain schrieb:
> How we can configure Mysql in such a way so that i start using all the cores
> of CPU. I Have a QuadCore server but somehow mysql use only single core
> whose usage percentage goes upto 99% while other three cores remains idle.
>
> Any Idea or Multiple Core/CPU is wastage.
Hi list
I have this statement that really need optimizing. The result is
about 5500 rows, and it runs for about 3-5 minutes. If i do the
same in a PHP script (outer loop, inner loop) it run in 20 sec.
The idea is that data in tdata "might" be shared between 2 or more
records in main. The main.par
How we can configure Mysql in such a way so that i start using all the cores
of CPU. I Have a QuadCore server but somehow mysql use only single core
whose usage percentage goes upto 99% while other three cores remains idle.
Any Idea or Multiple Core/CPU is wastage.
--
Kunal Jain, burrp!
http://b
Dear MySQL users,
MySQL 6.0.8-alpha, a new version of the MySQL database system has
been released. The main page for MySQL 6.0 release is at
http://www.mysql.com/mysql60/
MySQL 6.0 includes two new storage engines: the transactional
Falcon engine, and the crash-safe Maria engine.
If you are
did u check if any of the file system holding bin-logs/data files are having
enough free space.
If the slave runs out off disk space, then you need to rebuild the slave
from scratch.
regards
anandkl
On 12/8/08, ewen fortune <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> On Mon, Dec 8, 2008 at 9:20 AM, M
Hi,
On Mon, Dec 8, 2008 at 9:20 AM, Marcel Grandemange
<[EMAIL PROTECTED]> wrote:
>>WHat errors are you getting when you try and start the slave?
>
> That's the exact thing
>
> mysql> show slave status\G
> *** 1. row ***
> Slave_IO_St
>WHat errors are you getting when you try and start the slave?
That's the exact thing
mysql> show slave status\G
*** 1. row ***
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.11.252
18 matches
Mail list logo
