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
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_State:
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, Marcel
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!
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
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
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.
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
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,
-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 itself
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
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 is that
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 empty
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...
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
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
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 the
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
18 matches
Mail list logo
