_GP(var1), that can get the variable from the extension path like tx_blablabla[var1]?

hi, what are the advantages of indexes?

it can make SELECT queries faster, because mysql can simply look up a row instead of searching through the whole table for it

Alloosh, nothing its the placebo effect

It solves world hunger

Hai guys! Anyone have experience with replication? I had the weirdest occurence this night (at 4AM)

lifeforms, not that right but ..

A master crashed, the slaves got out of sync and stopped updating when I checked them, but… this morning, they seem to be up-to-date and syncing changes

thanks for the answer, I know that, the specific question is when it starts to have effect, I have around 100 000 rows in the table

Alloosh the explanation of lifeforms whas not that right the right answer to the question is more like

:_(

a table without … index is like a unsorted list you have to loop through each … entry till u find what you want a table with index is like a sorted list u have the binary logarithm of entries … as accessnumber u need to get one row

thanks, so if the table has 100 000 rows, will that effect the speed, and do I need to use index?

take a calculator and … u get the … result without index you access the table … 50000 times averafe average for one row with index you can … get the result with (logbase10 100000)/(logbase10 2) u have 17 accesses __constant__ to get one … entry

hi folks. is there a quick reference available for syntax changes between version 4.x and 5.x? trying to migrate a web site from a server running 4.x to one running 5.x and need to modify some of the code.

Alloosh, so you can choose if you want to read 50000 rows average to get one row or 17 rows … for one row

true still no HASH indexes?

makes no difference the … system is the same

Fiver, Have a look at http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html (and specifically mysql40 mode)

well, with a hash there’s ideally only one lookup (plus the calculation)

got the point thanks

but I will admit that your e-penis is quite large anyway, nobody has seen my strange replication phenomenon of today?

What’s up ? Oh, saw it there Isn’t that what’s supposed to happen?

this night, my master crashed, and the 2 slaves seemed to be out of sync (not incorporating updates) for about 30 mins, then I went to sleep.. This morning I had decided to re-import, but then they were up2date

well, I have other sites already running on the 5.x server.. if I change it’s mode, it may break the existing sites

perhaps I’ve had slaves crashing which went great

The replication isn’t “live”, as long as you’ve got the binlogs, it will continue to replicate fine once the master starts accepting slaves again If the master needed to repair tables, roll back stuff etc, it could take quite a while

ah….! that sounds very likely, it was a hard lockup with some FS trouble

Replication is more “Hi, what have you done lately?” rather than “Hi, give me all your datas!!” uReplication is more “Hi, what have you done lately?” rather than “Hi, give me all your datas!!”/u uReplication is more “Hi, what have you done lately?” rather than “Hi, give me all your datas!!”/u

very interesting arigato, sensei!

anyone here used to sphinx?

the ones in egypt ?

yes of course

I put it in mysql40 mode but it returns the same syntax errors

I did throw stuff at his nose and it did fall off poor sphinx

poor sphincter?

im doing a bunch of select (count *) queries from a big .sql file but I need to know what query has which count number in the output so I was wondering how I could print a string with the output of the count output select count(*) I meant

select count(1) as SOMETOTAL from

I need more information on how mysqldump works with flushing logs with innodb database and the records it keeps

to use BOOLEAN is just just BOOLEAN and no other stuff unlike enum?

Trengo but that doesn’t display a string which is what I’m looking for trengo that will create a view, no?

no it will display SOMETOTAL as the column name title actualyl

it just puts count(*) as the title

read again

count(1) is the same thing

read again

?

select count(1) as SOMETOTAL from did you try it yet?

I put the “as SOMETOTAL” in the wrong spot in my query, works now cheers

cheers

is “release” a new reserved word in mysql 5?

!man reserved words

see http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

it would seem so

why would my query be inserting a:0: instead of a:0:{}? I have it in single quotes too?!

I read from the manual that I should not set the memory usage of MySQL under linux greater than 2GB because “glibc may allow the process heap to grow over thread stacks” Is this still a historical issue, or has glibc still got this fault? (And where can I find out more?)

jstarcher how are you inserting it? Directly into mysql or using php or the like? either way, have you tried escaping the { and } with \?

Patabugen, like this http://pb.theoverclocked.com/83

presuming that’s PHP… in php 5 you can more specifically ‘define’ strings with {}’s

what do you mean?

e.g $somevar {$somevar} and ${somevar} are the same you use it when you have vars in strings

ahh ic

like echo “Hello my name is $sami and i like fish” if you were to do “Hello my name is $samiand i like fish”; then php would think the var was called $samiand and it would be blank so you do echo “Hello my name is ${sami}and i like fish and it knows what you want

Hey can anyone help! Can’t connect to local MySQL 5 server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

so the php might be thinking that’s what your {} are, and thus not sending them to the mysql

your mysql server probably isn’t running

right

so try doing 4s’, ‘a:0{\}’)”

let me rattle that around and see what I can do, thx Patabugen

no prob

Yeah I tried that and it got a:0

hm one thing that’s always worth doing

why is my overall qps up near 25 when I dont see any queries in the process list that arent sleeping?

is echoing the query and putting it directly into mysql, to see if the problem is mysql or php

Patabugen, im gonna try inserting the value as serialize(array()) which is a:0:{}

sorry, I had it stopped… THIS is the error I am getting root@ubuntu:/# mysql Access denied for user ‘root’@'localhost’ (using password: YES)

looking for some advice on clustering. I have a project that might need to have two active nodes on two different sides of the country, so I was thinking active/active. But I can run into a condition where duplicate primary keys can be inserted at the same time. Anyone have any ideas on this?

use the right password

cmdln, cause they are not running while you are doing show processlist, but are running otherwise

I am, is the problem

garywsmith, are you using natural or generated primary keys?

!m benj3one reset root

natural. they are email addresses

Sorry - I have no idea what function you’re talking about! but try http://dev.mysql.com/reset root

reset root

See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

because show process list only shows queries that are executing at that moment. If you are running 25 qps but they all take 0.01 seconds then you probably won’t see them too often

there, use that one

thanks!

Patabugen, ahh that worked

but that must be a mysql problem then?

currently we are doing active/passive (for backup’s) but we are needing to pickup load at the second office.

if you try echo ‘${a}’ php just prints ${a}

GeroiRabotui, nah I think it has to do with the way my mysql handler uses sprintf

ok then

good to hear jstarcher

thanks for the help. the only problem was a table named “release” in the mysql4 site cheers

who can explain the format of the log-bin file once converted. when you use mysqldump one of the first lines is “CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.000001′, MASTER_LOG_POS=98;” or something. When useing a dump and binary log files would you start the mysqlbinlog at position 98 or 99 ???

hello

Ello?

Do I need to configure mysql specifically to use dual processor? or is this automatic?

is it possible to install just the mysql client on win32 and not the server?

EHLO

lastlog -word postgre heh

I have a developer who need to access a remote mysql database from windows but doesn’t want to install the server as well can he just use the mysql binary from the noinstall zip file?

works out of the box if your OS is SMP capable. there are some settings which you can tune (thread concurrency for innodb and so on) but this starts to make sense with way more disks/cpus normally.

hi I’m working on a file upload script where I want to rename the file using [newid]-filename. Though before inserting I don’t know the ID of the new entry. How can I get the ‘next’ id when I use a auto_increment field?

roxlu__, just grab the last ID and +1

like select max(id) ?

inserting is the only way to know for sure.

and than updating?

yes

nils, wouldn’t auto increment suggest that it will always use last_id+1 as opposed to jumping back to freed up IDs?

what do you do when you have to concurrent uploads?

lock it

locking is evil.

locking is sane so no-one got any ideas about only installing mysql-client on win32 and not mysqld as well?

and auto_increment won’t always use last_id + 1, but those cases are usually corner cases I think it is best to do it this way: Start transaction, INSERT, then get id, rename file, commit.

oke thanks

hello is it posible?: UPDATE bla SET bild = ‘\\\\Kruemel\\’ + SUBSTRING(bild, 10) WHERE bild LIKE ‘%\\\\Server%’; if i try this then is the value in my fields “0″

Use CONCAT instead of +

hmm? do u have a little example? please?

UPDATE bla SET bild = concat(’\\\\Kruemel\\’ , SUBSTRING(bild, 10)) WHERE bild LIKE ‘%\\\\Server%’;

+ is for math. CONCAT is for strings

ah ok

2GB on linux web hosting - “glibc may allow the process heap to grow over thread stacks” - is this historical, or still true with recent versions of glibc?

SHOW OFF!

afds

C+P baby ftw

and in MSSQL is this same?

No idea! This is #mysql. We talk about MySQL

jepp ok gracias mi amigo

hehehe

am i a pig if i buy two sandwiches, eat one at lunch and then 3 hrs later eat the other one?

dependsif the sammich contains 2lb of cold cuts or not surely

You’re a pig for eating the whole sandwich

hey snoyes

Are they 24 inch subs

hi haptiK

no they are just normal sandwiches

Hi snoyes_!

haptiK, I doubt it - I didn’t think pigs were aware of a monetary system, and therefore would not buy sandwiches.

hi seekwill

hehe

also depends on the size of the bread, I made some bread loaves yesterday and they ended up almost 1 foot high hehe

Anorectic..

haha they are standard roll size

Although, if you want to eat your sandwitches DBA style, you’d eat both for lunch, and then three hours later collect enough crumbs from your beard for another sandwitch

http://www.paladine.org.uk/images/bread-02.png :p

hahah

Why do I keep typing sandwitch ?

hhAHHAha seekwell rofl

and if there aren’t enough in the beard, just clean the keyboard, lot’s of food in there. band if there aren’t enough in the beard, just clean the keyboard, lot’s of food in there. /b

That too

paladine thats looks great recipe? or a HOWTO might be better

sensei, surely you would save the crumbs in your beard for your commute home and simply send one of your underlings to drive to the best sub place in town and buy you another sandwich for the 3 hours after lunch senario?

or a MAN page would be even better

how do you connect to a remote mysql server from the console?

DBA’s goes home? o.O

haptic, 900g of strong flour, 20g butter, 5 grams sugar, 2.5 grams salt, 480ml water and 6g of yeast

That means the possibility of exposure to daylight!

mysql -h host.com -u -p i think

And people! No no

hmm back in the old days when I was young recipes where woman pages

From the looks of things, are sure it’s not 6hg of yeast?

People! What a bunch of bastards!

hehe

sensei, lol no, thats a 3lb loaf though hehehe

Impressive

impressive that I baked it or impressive that I was geek enough to put a photo online of it? I bake pies too

oh no… not the old pie vs. cake debate!

http://www.paladine.org.uk/images/pies.jpg

will you marry me?

I am a guy

hey folks

me too i dont care we dont have to like touch each other just bake me stuff

lol hahahaha my missus and son might object lol

do you make sheperds pie?

actually the missus makes shepherd’s pie she does a fine shepherd’s pie

my dad makes a great one thats an amazing dish im going to make that soon i think

stop this, i am getting hungry

I do most of the cooking but a few things she excels at I did a 3.5lb chicken and mushroom pie last week for a big family meal

we can all see who wheres teh pants in that relationship!!! jk paladin

haptiK, naaah I spend around 30+ hours at a time infront of my computers so I have to make a domestic effort every now and again

Can someone help me with a fairly simple web-based query that’s apparently based on mysql (which I have no knowledge of :/)?

pff can you bake stuff? then yes hehe

Well I can make pancakes. From scratch, not a mix

haptiK, you should see my lasagne, I tend to use 1KG+ of cheese in it

Does that qualify?

of course i have a soft spot for good cheese… just another reason i moved to mainland europe

But Paladine’s baking skills are like using a dual-core CPU and I’m sitting somewhere around a 486 level.

I am known for being a bit of a cheese monster

its not the size that matters its how well you use it :p

I am making Jam later this week

Is it safe to drop the URL for the site I’m trying to put my query into in here?

thanks, haptiK

not if it lets anyone perform anything

or give out free root

for what??

Not as far as I’m aware.

what’s the problem your having?

this must surely be the least anal channel on freenode?

It’s a specialized search engine, essentially. it’s www.manabase.com ..

omg

After checking the HTML source, it looks like the two set numbers I want to deal with are 10 and 12 (I’ll explain in a moment).

is that a MTG related db ?

Yeah

theres nothing wrong with MTG moving on…

What I want to do is find a list of everything that’s in set=12 (11 and 10 have the same items) But not repeated in any other set. So, for example, not found in set=13. (For those familiar with the game, 10-12 are Alpha, Beta, and Unlimited, respectively.) The [] and [______] box is for you to put your own query in. And the variable for checking what set it’s in is cards.expansion

hm

12) AND (NOT cards.expansion 10)

But that just gave me the list of what was in Unlimited. And I *had* the checkbox marked. The easiest way to check to see if the list is right is, is the first entry Ancestral Recall? If yes then it’s probably right. Otherwise, it’s not

So you have a table with alot of items in, and a link table that puts them into groups? i’m not quite with you…

k guys thanks for the laugh I will be sure to pop in again some time, have fun

when you use mysqldump one of the first lines is “CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.000001′, MASTER_LOG_POS=98;” or something. When useing a dump and binary log files would you start the mysqlbinlog at position 98 or 99 ???

I’m not entirely sure, Patabugen; it’s not my site. I’m only trying to find a useable filter so I only get cards that were only printed in those sets and that’s all. So, in other words, for the cards.expansion values, it could *only* list as options: 10, 11, and 12 (and with I think two exceptions, all cards from 10 went into 11 and 12, but some have been carried into other sets and some not). its name, and a list of values for what set it was in. In this case, I’m looking for cards.expansion == { 10, 11, 12 }, with nothing else in that list of numbers.

IN (10,11,12)

Right.. but, for example, it can’t have 13 on the list as well. Sol Ring would come up in sets 10, 11, 12, 13. Time Vault would come up 10, 11, 12. Return Time Vault but not Sol Ring.

SELECT id FROM cards WHERE id IN (10,11,12) AND id NOT IN (SELECT id FROM cards WHERE id NOT IN (10,11,12))?

If I read that right, I think so would id be the name?

id would be whatever key you’re using

Well, the value to return is the card’s name.

show variables like ‘thread_concurrency’; returns Empty set (0.00 sec) what does this mean?

ho hi

I don’t suppose there’s a way to rewrite that without saying ‘SELECT id FROM cards WHERE’ in the second part is there?

sure left outer joins

Mostly due to the fact that I don’t know the name of the database itself so I can’t say select X from *this* where..

Night_Owl, the second select doesn’t return anything visible, its a sub-select

gonads and strife

x NOT IN (….) where the …. is filled out by a select that returns values for x

Also known as Wheeeeeeeeeeeeeeeeeeee!!

when your a kid and you wanna go wheeeeee but you aint got drugs yet….

Uh… the MySQL Web site is redesigned, and I can’t find the download anywhere. It keeps bugging me about paying for the “enterprise” version.

http://dev.mysql.com/downloads/

Where is the link to that? “Community” link? Uh… okay.

yeah

yes

under community, then downloads

http://dev.mysql.com/downloads/mysql/5.0.html#downloads

right side is paid, left side is free

I thought “enterprise” was the exact same source code but with added “support”. I thought this was how Open Source worked. :/

hmm well…

http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.45-win32.zip/from/ftp://ftp.fu-berlin.de/unix/databases/mysql/

you can’t download RHEL for example

Yes you can

yes?

You can download the source code for Enterprise

I take that one back.

Hmm. “Community server” sounds lame. seekwill:

Which is the “open source” way

yes they should name it MySQL BlueRedFrog Edition.. because that would be so cool.

It roughly has the same features, I guess there even are some more than in enterprise

Where do you think CentOS comes from?

compiled from rhel srpms afaik.

Exactly!

but it’s still CentOS

Didn’t they recently redesign the Web site, and now they’re doing it again?

It’s still RHEL

the new community dl site was before the redesign I think… whatever.

Damn I shoulda started my laundry earlier.. I get back and now I’m getting confused.

Good thing you’re a night owl.

What is the difference?

the name and the guys who compiled it.

What are the differences that matter?

don’t know, there might be a slight delay between new RHEL binaries and CentOS binaries… I don’t use it. I just took RHEL as an example how other OS companies handle it.

There are three different downloads for Windows, each with vastly different file sizes. There are no descriptions or short summaries about what these contain. I suppose “Essentials” is what I want for my devbox?

rhel made them change the logos, too.

yes, there is a delay…

Is this the case?

I like the way CentOS refers to Red Hat. “CentOS is an Enterprise-class Linux Distribution derived from sources freely provided to the public by a prominent North American Enterprise Linux vendor. CentOS conforms fully with the upstream vendors redistribution policy and aims to be 100% binary compatible. (CentOS mainly changes packages to remove upstream vendor branding and artwork.)”

Where can I find optimal my.conf for my setting? Is there a database of my.conf?

So.. Trevelyan`.. where were we?

arg[]:

‘…who shall remain unnamed…’

Walking the plank, ye scurvy bilge rat…

!tell Jomyoot_ about tuning

Jomyoot_ http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/

Trevelyan`: thats not till tomorrow

i know but i need practice although i’ll be in portugal tomorrow. i have no idea how well know pirate talk is known and understood there.

Does anyone understand the 2GB Linux memory limit for MySQL? http://forums.mysql.com/read.php?22,74129,116829#msg-116829

32bit OS?

nils_, yes.

there you go.

But Linux support 4GB with 32-bit, and infact up to 64GB with some hackery.

did you write that blog?

you have to make single changes and benchmark. Optimal settings depend on the DB and usage

botsnack

ooooh let me bend over and lift my skirt for that

what is a good benchmark tools for mysql?

for the system yes, but not for single processes. For a single process something between 2 and 3 GB is the limit

timing your application there is also supersmack, Jomyoot_ and some otherws

is it possible to use 2 left join ?

mysql has PAE support (which is enabled by the 64GB in the kernel) but it’s not well tested and crappy all way long.

nils_, according to http://forums.mysql.com/read.php?22,74129,74143#msg-74143 CentOS (the OS I use on my servers) has changed it to 4G/4G?

that tuning article has crazy grammer

the guy is russian… hmm might be possible… but not up to 16G, better use 64 bit

nils_, where could I find out if it is or not? I don’t want my DB to crash! nils_, I only have 4GB, and my hosting company is being hesitant over 64-bit… I am wearing them down but it is taking time.

hmm well the only way to find out for sure is allocating so much memory. but I think 4GB is the absolute limit without PAE code…

is there something like int(value) to delete decimal ?

nils_, OK thanks. If I set it to use 4 GB (e.g. by using a 3GB innodb_buffer_pool_size) would it fail to start or would it only fail once it starts using too much memory?

see round(), floor() and ceil()

it crashes once it starts to use so much memory I think

nils_, dang. Is there something I can do to force it to use lots of memory fast?

lol Load up lots of stuff?

what you could do is for example set the max heap table size to very large and then fill a heap table with lots of data.

I was hoping for one query… Ahh cunning.

hi all. SELECT DISTINCT tblnews.* , tblusers.user_name FROM tblnews LEFT JOIN tblusers ON tblnews.user_id = tblusers.id WHERE tblnews.article_id = 34 OR tblnews.article_id = 26;. I want the result to be ordered in relevance to the search criteria. I.e. WHERE statement A comes before WHERE statement B etc… Hope that makes sense.

or just run the code snippet posted on the forum

nils_, the C code?

yes

nils_, OK, thanks

for my system for example it’s 2.8GB which is quite common

2.8?

2800MiB to be exact.

That feels like two 1GB sticks, a 512, and a 256

MiB?

Million bytes I think

yes. no strictly speaking, MB is million bytes

1MiB = 1,000,000 1MB = 1,024,000 ?

how do I select those IDs from one table which not present in another table?

1MiB = 1024KiB

No MB is megabytes

yeah

which is 1,048,576 bytes

and according to SI mega is 1mio

SI?

MiB is Men in Black, right? LOL

it’s not being used in an SI setup

indeed

What’s SI?

International System of Units

(couldn’t resist)

Metric

Le Système international d’unités

Who cares about standards?!?!?!?!?!

bleh

hard-disk vendors

I’ve not found a compelling reason to switch to Vista from XP.

Marketing! It looks pretty

Good for it. Give me functionality first.

And it’s way more secure!!!!

Than what, Windows Firewall by itself? So’s using a router or NIS.

even the viruses have compatibility issues

lol

centosian, thank

np

is it possible to use left join two times with 3 tables ?

yes I think so

Strangely enough, that could sell it.. at least until the virii catch up, and then I’ll go back to XP

can’t see why not

I don’t have an unique id for the 3 table one table link the two others with two different id

that’s not a problem

okok I don’t know how to

pastebin the table schemas and what you’re trying to do

Hello, When I want to start mysql I get “MySQL NOT started (0)” … how can I fix this ??? — I’m in linux btw

check the mysql error log

and google the error

Where does it is ? There is nothing on /var/log/mysql/mysql.err

table0.field0=”zefezfezf:matchdata:zefzef” and table1.filed1=”matchdata” and I need to do the left join on table1.field1=table0.field0

could be a lot of stuff, don’t know offhand

but where does the log is saved?

“But where is the log saved?”)

hello i have a question

42.

who can help me ? it’s about a request

don’t ask to ask, we have no idea who can help you until you ask your question.

don’t ask who can help, just ask the question

ok

I predict that f00li5h can help

there is support available starting at 499$ lol

my database shema :

also, don’t say “hello” no one cares

plus VAT

who speak french ?

this is an English-only channel

SIGNATURE(id, nom, prenom, …, date, #id_petition)

depends, not applicable in the European Union for B2B consumers

PETITION(id, titre, date_d, date_f, …, #id_user) USER(id, nom, prenom, date_inscription)

Oui ?

 

Secure mambo.

 

oui oui cheri

ma base de données : SIGNATURE(id, nom, prenom, …, date, #id_petition) PETITION(id, titre, date_d, date_f, …, #id_user) USER(id, nom, prenom, date_inscription) jve afficher la liste des membre avec pour chaque membre sa pétition la plus populaire (petition avec le plus de signature) et le nombre de signature correspondant. Si aucune petition du membre n’est signé on affiche la derniere petition quel requête pour afficher ça ? ok

déjà y’a un problème de modélisation : on voit deux fois nom prénom

on a dire nom_user et prenom_user

dans signature, tu stockes uniquement l’id du USER et tu mets une contrainte d’intégrité

dans la table USER

dans la table signature qui oblige que signature.user_id existe parmi les user.id alter table signature add constraint …

hey, I have a problem with mysql_upgrade on fedora core 6, it is telling me mysql_fix_privilege_tables.sql can’t be found.

quel requete puis je faire avec ces tables ?

j’imagine que petition.#id_user correspond à l’utilisateur ayant créé la pétition…

je n’ai pas un niveau avancé oui comment faire la requete ? penses tu que la requete soit possible ?

si tu arrives à exprimer une requête en français, la requête est possible.

jrx, ok je ne sais pas quoi mettre comme requete

select user.id, user.nom, user.prenom, petition.titre, count(*) nb from user, petition, signature where petition.#user_id = user.id group by petition.id order by nb; oops, j’ai oublié la jointure entre les pétitions et les signatures…

sa donne quoi avec les jointures stp ?

select user.id, user.nom, user.prenom, petition.titre, count(*) nb from user, petition, signature where petition.#user_id = user.id and signature.#id_petition = petition.id group by petition.id order by nb; order by nb desc; je dis ça de tête, j’ai pas essayé sur mysql…

on test

mephisto , isn’t there a french mysql channel?

well, seems not…

jrx, je test dans phpmadmin de mon site

come join me on #mysqlfr viens sur #mysqlfr

greeting folks question for anyone who may know — when using innodb, can I have it automatically break the database into 2gig files, or do I need to manually add them to the config file every time one fills up ? I see how I can specify multiple files and make them autoextend and set a max size and all, but it appears I need to create new datafiles on my own, it wont just keep creating them every 2 GB if needs be any thoughts would be appreciated (i know I’m leaving myself wide open with that one)

hey, anyone here use mysql+nfs for the data?

no, and why would you do that?

hello guys can i beg you for help

you can beg

dont know mysql root password can i reset her?

google lawl http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html jinks

thx guys

i have two servers doing HA, and both run mysql, but the data is stored at one server that has raid-10 and one nfs to export this data to the servers. it works fine, but, when i stop one mysql and start the another one, it takes some time to it get running, on x.err i see it saying about ibdata1 and locking.

you’re on your own with that one centosian

no idea what you’re talking about has to get enough data from nfs to get started, and it’s slower than a local disk. locking over nfs is dodgy (ie, doesn’t work typically)

the problem is with locking. so how can i do something like this w/o nfs? unable to lock ./ibdata1, error: 37″

!perror 37

No locks available

slumpo, certainly looks like your NFS setup isn’t working that well!

:~

in theory, you could disable locking on the NFS setup, but you will most likely end up corrupting your innodb data at some point

yeah, there won’t be two servers accessing the same db at the same time, so i think it’s ok

if it ever accidently does, you will corrupt all of your data beyond repair

hmm

which is why InnoDB does the lock to prevent it from occuring

it’s just test yet

why does your NFS take such a long time to remove the lock?

i don’ t know :/

it obvious goes away when the first MySQL shuts down how long does the lock persist for?

let me see. it’s strang lsof gives me nothing them i start mysql and got many unable to lock after i stop it, lsof don’t show nothing anymore.. it’s strange

SET PASSWORD FOR ‘root’@'localhost’ = PASSWORD(’MyNewPassword’); sorry

Anyone know what to do when you lost your mysql root pass?

what

when I do GROUP BY 1 - what are my results grouped by? the first index?

If we have a unique index so that no record can have both the same photo_id and user_id but I want to add a general non-unique index for photo_id to aid in lookups do I just change the key name on the first unique index?

bye bye

no, don’t add any index

why?

if your composite index is like UNIQUE (photo_id,user_id), you can already use photo_id as an index

oh, okay, so no need for a non-unique one on top? or in additon to I mean

no, you don’t need it but if you want to use user_id, then you’ll have to have a separate

why is this returning 10 results and not one? it seems to be echoing each image instead of grouping them - http://pastebin.com/d146a77c4

rycar centosian thx guys

np

Is there any chance of resolving a root password when you’ve lost it?

swimrr because it is in a while loop

thanks, that’s what I wondered

why was in the while loop

is it possible to set ssl parameters (crt path, etc) while running? it’s compiled in, and “DISABLED”, but i’d like to enable it

because I am returning multiple results to display

Samen query though right ?

anyone using c-api for mysql?

*same

!tell Grandie about reset root

Grandie See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

since teh query is not changing you can run the query once and report the results in the while loop to extract the data. they way you have it, it seems to run the query every pass of the loop.

mysql_fetch_field(MYSQL_RES* res) doesn’t deliver any pointers to MYSQL_FIELD but just a NULL … mysql_fetch_field() gives the next value of the field…

I got this error importing a mysql dump in a mysql 4.0 server , what should it be ? 1005 - Can’t create table ‘./Sql66991_5/tiki_articles.frm’ (errno: 140)

!perror 140

Wrong create options

needs an edit large jump 4 to 5

Anyone knows about the possibility to get retrieve a MySQL root pass from old versions? 3.* ?

do I do that by moving the query before the while loop?

ok, seems no answer..

jsbach, vague question Grandie, reset it

archivist, i am trying to use the mysql_fetch_field() from mysql.h . According to c-api, it should return a pointer to the “next” field value everytime it has been executed. So if i call that function, i get a NULL pointer instead.

hey what can I use to convert ‘false’ into false (ie, cast the string into boolean)

hello- I have ve an existing, minimal MySQL 4.1 on an older machine sitting in a closet. I just logged in to it for the first time in a long time. I set it up, and I am a rank beginner at such things. I want to add a database to do some scripting tests… I have a user called ‘mysql’, and a user called’admin’, but when I open phpMyAdmin as either of those, I see “New Database - no priveleges” an no sign of a User Management lin

jsbach, empty resuly? result

i do the call just as i saw it on many examples after googling.

anyone here ever managed to get a mysql server running under OSX? I’ve got a coworker who wants to do that for testing stuff on his local machine.

archivist, yes. but if i do a mysql_fetch_fields(MSQL_RES* res), i get a full rite answer. MYSQL_FIELD* field ; while(counter number_cols) { field = mysql_fetch_field(res); fprintf(stdout,”%s\n”,field-name) ; /* do sth */ counter++;} i get a nice sigsegv for that of course number_cols is delivered rite and res is an already defined MYSQL_RES pointer

Yes. I believe OSX comes with it

jsbach, you are calling this immediately after doing the query or have you done anything else on the MYSQL_RES ?

ok, I guessed at a likely user name, and its there.. It has DB create privs

HarrisonF, i used MYSQL_RES to print out all the columns first, before i call the mysql_fetch_field on MYSQL_RES for the second time.. is it the prob?

there is a privelages link in phpmyadmin now.. I am looking at a list.. the other users I mentioned aren’t even explicitly listed, they are “Any” (I guess) I set this up, last November.. but I dont know where the admin privs are defined

HarrisonF, it looks like it is the problem. so, i can’t use one pointer if i want to do multiple things within a query. i have to use copies of the MYSQL_RES* ?

what is the most efficient way index wise to select where datcol is older than three months? ( datecol date_sub(now(), interval 3 month) or is there something better? )

fatpelt, calculate your date of 3 months ago in application, and do WHERE datecol ?

(not that I am getting any attention here, but)… in a MySQL connect string in the form of MySQL:test,user=admin,host=davy.local what does the test part mean?

hi there !

salut jules

salut eric ericP

the database name perhaps?

‘have a question regarding VIEW how can you list existing VIEWs on a database ?

ericP tu parle français ?

pas bien

mephisto, toi aussi ?

mais tu peut parle avec jules

jules ? tu parle français ?

though changing language here is likely to distract and annoy

oui, en fait je crois que je suis français meme ^^

jules, tu peux répondre a une question que je me pose ?

dis toujours si je peux t’aider…

voici mes trois tables: SIGNATURE(id, nom, prenom, …, date, #id_petition) PETITION(id, titre, date_d, date_f, …, #id_user) USER(id, nom, prenom, date_inscription) jve afficher la liste des membre avec pour chaque membre sa pétition la plus populaire (petition avec le plus de signature) et le nombre de signature correspondant. Si aucune petition du membre n’est signé on affiche la derniere petition

does FORCE INDEX () allow one to specify index merging? or does ndb allow for index merging ?

y, seems likely..

hmm tu vas me forcer a reflechir

I dont know how to tell what port its running on.. conenct string is not connecting

3306 likely unless it is trying to use a unix socket to connect. then it’d be a filename

comment vois tu la requete ? jules ?

how can i clone MYSQL_RES ?

il est en train de t’aider, je pense

oui une sec j’essaye de visualiser tout ça

ok

a .. filename.. ? I have two unx machines.. one is the server, I can see there is mysql running, with netstat ‘… /tmp/mysql.sock’, but, I dont know what port.. and basically, that connect string is not working.. needs something else? everything should be prtty default.. as I mentioned. I set ths up last Nov, and I dont know any special tricks

/tmp/mysql.sock is a unix socket. not a tcp socket. you can really only use a unix socket on the local machine

you can connect tcp to local be using 127.0.0.1

well.. I want to connect from the other machine on the local network. DO I need t do something else?

je pense que la piste se situe sur les jointures

not meaning to disregard your valued comment.. I was already typing

external

remove bind-address= and skip-networking from my.cnf and grant permission to the external ‘user’@'host’ and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline

aha.. my.cnf .. neds a magic line? checking… .. and .. a grant ?

mephisto_, peut-etre queque chose comme [[SELECT nom, prenom, if (COUNT(*)0, COUNT(*), FROM USER INNER JOIN PETITION ON id_user=USER.id LEFT OUTER JOIN SIGNATURE ON id_petition=PETITION.id GROUP BY PETITION.id]]

j etest

mais il ne fait pas l’ORDER

0 , COUNT( * ) , FROM USER INNER JOIN P’ at line 1

in .. /usr/local/mysql/support-files/ there are some .cnf files, but they look like samples…

mephisto_ tu as regarde mon pv ?

non comment faire pour voir PV ?

euh le message que j’ai ouvert aveec toi

je n’ai pas reçu tu peux renvoyer sur le chan ?

SELECT u.nom, p.titre, p.date, count(s.id) FROM signature s, petition p, user u WHERE u.id=p.id_user and p.id=s.id_petition ORDER BY count(s.id), p.date ça marchera sans pas tel quel mais c’est une idée que j’avais

#1054 - Unknown column ‘p.date’ in ‘field list’

How can I configure the location MySQL uses for temporary tables? It tries to build them in /tmp, but there is insufficent space on / for it

après sinon il faut complique le select des champs et y inclure des if() comme Eric a fait p.date_f

je ne vois comment faire

ou date_d je sais pas

je vois pas comment faire

on the entire machine there are only those 5 .cnf files, which look like examples.. Perhaps I do not have a my.cnf at all?Is that required to get a network connection?

what’s the default schema in a mysql db?

il ne trouve pas les colonnes

tmpdir = blah

wonderful, thank you

SHOW VARIABLES LIKE ‘tmpdir’;

quel serai la bonne requete avec les bonne colonnees ?

the_wench is a bot

si tu remplace p.date par p.date_d ça ne marche pas ?

I am making a multi site news feed and I wanted to know if you can use “AND” but also have another “AND” to select a different query? Like AND & OR functions?

Anyone has an idea of how to list existing VIEWS on a mysql database so ?

jules, non sa marche pas, mais que donnerai la requete avec celle de ericP ?

ok, i am talking to a chat robot..

ok, just so you know

So, do I need a my.cnf to get a network connecton on MySQL 4.1 ? thank you

It’s probably better to have one. Why don’t you want to use a cnf file?

je sais pas trop en fait il faudrai que j’ai une db pour tester un peu

I am a rank beginner, there is nothing extra there.. apparently there was never one created. I am not averse to it, I just need to fgure out how to conenct a local network unix machine to run a test script. I appreciate pointers

the defaults in any of the my.cnf* files will probably just work have you done a mysql_install_db and granted access yet?

Okay guys, I’m trying to do a SELECT * from `photos` WHERE `id` not in (1,2,3,4,5)

bon je vous laisse @ +

This works just great if I hve photos up to 10, it will return 6, 7, 8, 9, and 10

suprising I can still understand some french after over 10 years

but, if I do SELECT * from `photos` WHERE `id` not in (1,3,9) it only returns 10… the one after the list I give it. Shouldn’t it give me all that aren’t in my list ?

there are a few users in place, and a few databases for one user. I am logged in via phpMyAdmin which exists on the server, and with a shell account. I added the database for the test using phpMyAdmin, to the user I wanted. But I cannot connect from the remote machne with an otherwise reasonable looking connect string in the script/tool I am usng

is phpmyadmin on the same server as mysql? And are you sure that you are allowing remote connections to that server?

so I am wondering if there is something special I need to enable a remote connecton. yes, and no..

bind-address external

remove bind-address= and skip-networking from my.cnf and grant permission to the external ‘user’@'host’ and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline

how can I translate your helpful but cryptic words into an action, either on the command line or in phpmyadmin?

check to see if mysql has bound to a routeable address or at least not to the loopback device only

huh?

linux?

How long have SQL injections been known/used?

MacOS Darwin, on a local network behin a linksys.. So I usually addres this machine with g4shadow.local, which makes most things happy but, I can try the IP address .. trying…

since sql was used probably can you find out what address mysqld is attached to?

I went for years building Web apps without knowing or protecting against about SQL injections…

ouch i went for years without thinking about cookies being editable =\

wow

how might I try to do that?

you must not be a very good web developer, blueredfrog

if it were linux I’d do something like netstat -tuanp | grep mysql

saving logged in user ID in a cookie, and trusting it :p

sometimes the worst web developers are those who have been doing it the longest

Anyone? can someone please explain NOT IN to me better?

I would dare to say that 99% of Web developers do NOT know (or care) about SQL injections.

he must not have _been_ a very good dev

I can do that… trying

uh I think it’s mostly just you, blueredfrog

99% of them don’t write valid code…

trying to make yourself feel more competent

^Migs^: I think you’re being naive.

what don’t you get MrPunkin?

I am no longer an idiot, but I admit that I have been in the past.

I think you’re feeling ashamed and are trying to compensate by blaming others

^Migs^: And I know how it is.

say the guy who threw the first insult o_O

3

99+% of all Web sites don’t validate.

I ALWAYS write valid code, and I ALWAYS protect SQL injections. And out of the HUNDREDS of developers I’ve known, they’ve ALL done the same.

Why do you think that somebody who cannot write HTML would protect against SQL injections?

read above, “but, if I do SELECT * from `photos` WHERE `id` not in (1,3,9) it only returns 10… the one after the list I give it. Shouldn’t it give me all that aren’t in my list”

who said anything about anybody who can’t write HTML?

i bet you learned to read from o’riley

even though 2,4,5,6,7,8 exist

Who?

perhaps you have no other results

So you’re saying web developers, i.e. you, don’t know how to write HTML?

^Migs^

?

^Migs^: Learn how to read?

blueredfrog made the first insult, Patabugen, pay attention

You’re not reading what I type.

or perhaps you have other WHERE clauses?

what a jerk

and another .se

before “your not a good web dev”?

I suck at html. my tags are limited to , table, form

my netstat does not like -p, but otherwise, works fine.. All I get back is the ’stream … /tmp/mysql.sock’

If I get an array of all photo ids, and subtract the ids of SELECT * from photos where id in (array) I get 1000 results… but if I simply do SELECT * from photos where id not in (array) I only get the ones after the last item in the array

Perhaps you should mind your own business, Patabugen

I would dare to say that 99% of Web developers do NOT know (or care) about SQL injections.

that’s an assault on everyone here

so disable the skip-networking line in my.cnf, or change however mysqld starts so that it accepts external connections

no, just 99% of the web developers here

true, but your the one who appears to think your perfect

some of us like to validate our code

is that your complete query?

hi I’m trying to install mysql on my macbook and I ran the package installer. when I type mysql -u root -p on my terminal it says -bash: mysql: command not found would someone be able to help me

wow what retardedly dualistic thinking

yes, what is it missing?

when did I EVER say I’m perfect? I simply said I ALWAYS protect against SQL injectors, and ALWAYS write valid code. *injections

no my.cnf, it starts with the line ’sudo bin/mysqld_safe –User mysql&’ so I add.. ?

do you see any claim to perfection in there? Hmm? No you do not, because I never said it. Stop putting words in my mouth, fliptard.

and you act like you ALWAYS have, you NEVER wrote ANY code that didnt

try using a mysql config file

I do NOT appreciate it. wtf? No I don’t perhaps English isn’t your native language, Patabugen. That would make sense.

Except that it is

See, when people who speak English use present tense, such as “always protect” or “always write” they are referring to current circumstances. Okay, then maybe you failed 5th grade English

I’ll pastie my whole thing, you tell me if it’s too long, or whatnot.

We dont have grades. Here in England. Where we speak English.

Now see, there is no claim in there that I have ALWAYS written valid code, just that I ALWAYS write valid code. lol well that makes sense. Brits seriously corrupted English.

Interesting.

Thank goodness for Americans, who speak CORRECT English I mean, come on. You call things by the wrong names, like you call elevators “lifts” and diapers “nappies.”

So Americans speak English that’s more correct than English people. Yeees, and who spoke English first?

It’s hilarious. You don’t realize the whole world is laughing at you.

And then in which country did it change?

does it matter that our array to check with not-in is about 2200 items long?

no

It’s a matter of who PURIFIED the language.

as long as it’s smaller than the max query size

that’s one way of putting it.

You Brits have been dragging English downhill for a long, long time I’m embarassed for you, frankly so proud

so why is it not giving us all between all these values, but just the values after the last one unless we simplify our array down to just like 3 items?

it’s okay though, dude. I forgive you and all. But just get over yourself, k?

Patabugen, the people who spoke English first were the Angles, something like two thousand years back.

Says mr perfect code?

it should be

Brits speak a corrupted form of English. That is just a fact.

It changed in both Britain and America after they split geographically, just as it had changed in Britain alone for many centuries.

My point was not that we spoke it first, but that america spoke it after

I suspect you have the values you were not expecting in there somewhere

Americans speak a more correct form of English.

so what do you mean values I’m not expecting

Patabugen, the two of us are the same number of degrees removed from any kind of “pure” or unified English.

Wrong, Simetrical

(assuming you’re British and I’m American)

it has the ‘in between’ values in your NOT IN clause

I think you’re forgetting that Brits just have wrong words for things. and there’s a ton of them

hehe

There’s no such thing a pure or unified english

then when they say them, everyone else goes, “Huh?”

i’d pastie our thing but it’s not letting me past that much text anywhere. I promies you that we are only passing the id’s of 2000 of the 3000 items into the NOT IN clause, but only getting 6 back with no other WHERE clauses

there is here in America, Patabugen

I’m not saying i speak english better than the next guy (heck i can’t spell for cake)

look, I know it’s hard for you to understand, but Americans DO speak correct English. Just take my word for it, okay?

More that Mig’s is speaking out of his arse.

that is exactly the ball of wax I am looking to avoid, actually… I dont have a much of config needs.. skip-networking is a single line, which is disabled by defaul tin the sample .config I am looking at.. If any of the 100+ lines in the config file are a problem, I have new problems.. f I figure out the one option to use for the start cmd, I am in business. I appreciate your help, but thats nothe right answer ofr me as

I think, technically, that ‘I have always’ means the same as ‘I always’

Migs I’d find it hard to take your word for anything

Patabugen, there was a pure or unified English around, say, 1500 years ago. Which isn’t to say it was better than modern English, just pure and unified.

Wrong, flung

Was it not more unified after oxford wrote the dictionary? maybe less pure, but more unified

they’re both entirely different tenses. Learn English please, thank you. and not backwards British English. Correct AMERICAN English.

^Migs^, you write perfect code, speak perfect english, no doubt your a perfect person all round. That is why I don’t trust a word you say.

yes, they are differenct tenses, but ALWAYS means always

you wouldn’t trust a perfect person? write

means that now always is the same as previous always

I wouldn’t trust a person who thinks they are perfect

Patabugen, certainly less pure, maybe more unified but quite possibly not.

oh well, time to go home

I ALWAYS write valid code, and I ALWAYS protect against SQL injections. (Note there is NOTHING about perfection in there) I have NOT always written valid code, nor have I always protected against SQL injections. That would be a different statement.

I ALWAYS write valid code implies I have ALWAYS written valid code

That wasn’t the question, Patabugen. No it doesn’t I never claimed that.

then you do not ALWAYS write perfect code.

Moreover, I think I adequately clarified my statement and cleared up any confusion, so I think you’re just trying to create an argument here.

Nobodys perfect, everybody makes mistakes. Even you Migs

i want to show if my string is “NY” and the results was “NY,NJ”

If I were to write some code right now, I would guarantee that it was valid.

^Migs^, cut it out

Yes, but you write code more often than just now i bet you’ve written thousands of lines of code

I am clearly not including the past in this statement Right, I have

select * from sltest where “eight” SOUNDS LIKE “ate”;

Empty set (0.00 sec) boo

and i bet theyre not all valid, bug proof, and hacker proof.

uh I said nothing about bug proof or hacker proof

i want to show if my string is “NY” and the results was “NY,NJ”

wow, you’re just putting all kinds of words in my mouth today, aren’t you?

Your tone implies you believe your code is perfect

Perhaps you also don’t know the definition of a simple word like “valid”

what would the sql statement be?

even though I’ve repeatedly said it’s NOT, Patabugen?

stupid question. how can I show what the charset for a given database is?

could you clarify, nycphper? what string?

But you wouldn’t have said it wasn’t had I not contested it and everyone would have gone about thinking you were perfect

Because that was your CONFUSION, not anyone else’s

so im glad we have cleared it up.

mostly I need to know how to show the charset, so I can properly back it up with mysqldump

theres lots of people in this room, you want to check they all understood it perfectly?

No, you do not speak for everyone, Patabugen. who here thinks I ever said I was perfect? or even IMPLIED it?

No I speak for myself, and cleared it up for myself

Very well then

anyone else who benified is.. well benifited.

^Migs^: if users select “NY” on a states dropdown, and if i have a row with “NY,NJ”. I will want to show this row

Anyway you enjoy yourself, I’m going to write some code.

use WHERE states LIKE ‘%NY%’ or something I tire of you.

Then were both happy.

Please refrain from speaking to me any further, okay?

Works for me.

Okay, enough then. Leave me alone.

quiet the pair of you

uh, we just ended it, archivist

Hey didn’t you see, we just finished on a good note

yeah, we’re cool now keep up, archivist

ooh let’s argue about archivist!

Maybe he’s lagging hmmm, guess not wtf

you have an error in your syntax near ‘wtf’, what the fsck are you on about?

o_O

better pipe down, Patabugen, or you might be next

he’ll never see me here

it seems if we only pass in 999 items in comma-seperated form for the NOT IN it works fine, but once you cross 1000 it returns random results

there should be some sort of superinvisible mode you can set, so NO ONE can see you

yeah, there’s a command called /quit that does that it hides the GUI and everything

i hi

hey

o rly?

give it a go neeeatt

well, it worked, but I got lonely

couldn’t see you anywhere

I know, I was all like POOF! like a ninja!

didn’t see any smoke either so must have been ninja like, as opposed to magician.

and then I was all BAM! I’m back! Where did I come from?!??! Who knows!? yup some ninjas use smoke grenades, but I’m so sneaky I didn’t even need those

i tried to create a new table with 16 indexed fields, and i got a #1071 - Specified key was too long; max key length is 1000 bytes error from mysql. is this 1000bytes the sum of the key-sizes? because the biggest field of indexed fields is only a 100-long varchar in utf8… any idea?

Not from me =\ sorry

PDani, sounds a bit over indexed

Seriously, Why can we break our MySQL returns once we go over 999 items in a NOT IN clause, but no one else has documented this? Is it a configuration issue or something?

I’ve never run into that problem might be a config issue

MrPunkin, break your what?

his MySQL returns whatever that means think he means results

hello

hey

If we pass in an array of 999 items to check against in a NOT IN clause, say out of 2000 total items, we get 1001 back (as we should). If we pass in 1001 items to the NOT IN instead of getting 999 rows back we only get say 5, or 10, or something random it seems once we cross the 1000 item mark within our NOT IN (x,x,x,x) clause we get inconsistant results

make a test case and put it somewhere for me to look at

I don’t know what you mean a test case? LIke actually give you a DB with 2000 rows and id’s that are just from 1 - 2000 and let you test against it?

when you use mysqldump one of the first lines is “CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.000001′, MASTER_LOG_POS=98;” or something. When useing a dump and binary log files would you start the mysqlbinlog at position 98 or 99 ???

MrPunkin, yes, the exact queries you would run to see it not work MrPunkin, if you have an index on the column, you might try to repair table the table first

Oh really? How do I do that?

I think we’re all forgetting how awesome I am. let’s not forget that important thing.

I started mySQL with mysqld_safe –user=mysql –port=3306

repair table tblname;

anyhting else to enable a remote connection? the grant connection to user@host thing? where do I do that?

so your thinking its a corruption issue later on, and not actually a limit to how much can be passed to the NOT IN clause, even though its a hard 1000 items that breaks it?

you’re describing an interesting bug

do it from wherever you create a user

5.1.x is in beta?

MrPunkin, i have no idea what it is, but corruption could be one cause, yes

cant connect to local mysql through socket /var/run/mysql/mysql.sock, than, I added those lines to /etc/rc.d/rc.mysqld and it worked in the first but it didn’t in the second, why ?? the lines are : rm -f /tmp/mysql.sock , touch /tmp/mysq.sock , chown mysql.mysql /tmp/mysql.sock sorry, added those lines to /etc/rc.d/rc.local !!

blobaugh|s I am lookng at the phpMyAdmin scren for users.. Global Privelages = All Privelages.. places to look to grant connection to external source?

why am I still getting the error in the second, not in the first machine ??

freebird, why did you add those lines?

ok, in your add a new user form for Host use ‘Any Host’

I’ve read that in a website, and it worked !! what do you suggest ?? ta osso a parada são paulino !! have no one else to ask

I just find it really hard to believe that it is indeed a 1000 item limit causing this to break on two seperate DBs. Seems like too clean a number on two seperate DBs to cause the same corruption or breaking, and not be a real limitation

you never said you did it on two different systems previously make a test case

please you guys, have none of you guys ever gone thru something like that ??

i am creating a log analyzer software. it will generates ~10000 rows of output per minute at the current state. each row will consist of 1 string(256] two floats & 3 integers. the other part is that i will also have to select historic data out of this table, like 1 of the ~10000 per minute for a week or something like this. i?m quite new to mysql and i was wondering what storage engine i should use for this, any hints?

New zealand geeklog website hosting