I noticed an interesting benchmark at tweakers.net that shows mysql not
scaling very well on hyperthreading and multicore cpus (see links at end
of email).
Does anyone know what engine they are using for their tests? (Innodb,
myisam, berkdb heheh)
In fact they seem to show that postgres is a fast
On 12/18/06, Peter Smith <[EMAIL PROTECTED]> wrote:
Hello MySQLers,
Since I'm mildly technical and I know how to spell orakle,
I've been asked to write up some technical interview questions
for a MySQL position at a startup.
Can any of you help me out?
Your apparent focus on doing what is b
Hello All
If I compile my code with Purify (a memory tool), I get a core dump in
mysql_real connect. at teh follwing path :
Program received signal SIGSEGV, Segmentation fault.
0x007acb37 in mysql_manager_fetch_line ()
from
/opt/Rational/releases/purecov.i386_linux2.2003a.06.15//cache/getz/usr
Heikki,
Thanks for you help!
I also read the comment in file of innodbase/lock/lock0lock.c in which
you said "Different transaction can have conflicting locks set on the
gap at the same time.". I think that the innodb gap lock's behavior
just like an IX lock's behavior. When a transaction want t
Well,
The hiring mgr told me that he is looking for an Oracle DBA
who also knows MySQL.
To me that is a short sentence but says a lot since the
term Oracle DBA is kind of a loaded term.
Generally it someone with a large DB/data center kind of a slant.
Less of a programmer and more of an operat
On Monday 18 December 2006 18:23, Peter Smith wrote:
> Hello MySQLers,
>
> Since I'm mildly technical and I know how to spell orakle,
> I've been asked to write up some technical interview questions
> for a MySQL position at a startup.
>
> Can any of you help me out?
>
> I did some searching via g
Hello MySQLers,
Since I'm mildly technical and I know how to spell orakle,
I've been asked to write up some technical interview questions
for a MySQL position at a startup.
Can any of you help me out?
I did some searching via google and did not find anything all that
good.
I'm tempted to just
[snip]
I recently last week Had and experience with an Very small Company,
where as
they had around 15 Machines all hooked "Star topology" and a central iis
ASP
Web server that only showed the date, and a few small utilities when
addressed To it, now there entire Operation was based upon Excel,
ev
I recently last week Had and experience with an Very small Company, where as
they had around 15 Machines all hooked "Star topology" and a central iis ASP
Web server that only showed the date, and a few small utilities when
addressed To it, now there entire Operation was based upon Excel,
everythin
I'm sure there is ... here's one way I can think of, a two-step
process but doable in 3.23 I think. Use a server-side variable and a
combination of the LIMIT and OFFSET features.
SELECT id FROM items ORDER BY DATE DESC LIMIT 1 OFFSET 10 INTO @myid
then
SELECT AVG(cost)
FROM items
WHERE id >= @
Ajay,
To lookup the string for an error code use the perror utility:
$ perror 127
MySQL error code 127: Record-file is crashed
Try running repair table.
See http://dev.mysql.com/doc/refman/5.0/en/repair.html for more details.
-Eric
On 12/17/06, ajay roy <[EMAIL PROTECTED]> wrote:
i am gettin
Yes, the LIMIT function affects number of rows returned, not number of
rows evaluated.
If you're on 4.1 or later, you could use a subselect. Assuming you
have an ID field in your table, something like this:
SELECT AVG(cost)
FROM items
WHERE id IN (SELECT id FROM items ORDER BY date DESC LIMIT 1
Ysgrifennodd goose:
However how do I tell it to select JUST the first 2 entries for each
channel??
Does this help:
http://dev.mysql.com/doc/refman/5.0/en/select.html
Look (on the page) for the LIMIT clause. Not sure if it's what you want.
Peter
--
MySQL General Mailing List
For list ar
Leo,
'gap' locks in InnoDB are purely 'inhibitive': they block inserts to the
locked gap. But they do not give the holder of the lock any right to
insert. Several transactions can own X-lock on the same gap. The reason
why we let 'conflicting' locks of different transactions on a gap is
that
A lot depends upon the sophistication of the program you write to manage
this. I doubt there is any way to create something so sophisticated with
just SQL.
My first thought would be to use three tables. Make sure every user has a
unique use ID. The users' passwords would be stored in the table of
On Monday 18 December 2006 13:10, Karl Larsen wrote:
> Is there a paper I can d/l that covers intalling MYSQL on Red Hat
> Linux?
http://dev.mysql.com/doc/refman/5.1/en/linux-rpm.html
perhaps?
--
Scanned by iCritical.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
add "LIMIT 2" to the end of the statement
goose wrote:
Hi All,
I have the following SQL statement
SELECT
channel.channel_name, program_title, start_time, finish_time
FROM
program, channel
WHERE
program.channel_id='3'
AND
program.channel_id=channel.channel_id
UNION
SELECT
channel.ch
Is there a paper I can d/l that covers intalling MYSQL on Red Hat Linux?
Karl Larsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I have the following SQL statement
SELECT
channel.channel_name, program_title, start_time, finish_time
FROM
program, channel
WHERE
program.channel_id='3'
AND
program.channel_id=channel.channel_id
UNION
SELECT
channel.channel_name, program_tit
Remigiusz,
If you work with 32bit OS you need apply hugemem package for work with big
memory settings.
I work with 64bit OS and you don`t need apply any package. In order to add
more memory for the Innodb using innodb_buffer_pool_size you don`t have any
restrictions. You can set 10G, 20G depend
Uz.ytkownik Juan Eduardo Moreno napisa?:
Hi everyone!!
Normally we can set the .._buffer_pool_size up to 50 - 80 % of RAM
innodb_buffer_pool_size = 50% of phisical memory.
And
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 25% of buffer pool size
Now, we installed
21 matches
Mail list logo
