| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> you're a genius
<1> woo
<1> shabbs: http://www.mysql.com/network
<1> :P
<2> does mysql automaticly place an index on a foreign key?
<1> Snadder: In current versions, yes, if one is not already available for use
<1> Snadder: In older versions, no.
<2> i'm using 5.0 I think
<2> 5.0.18
<3> Hi! I'd like to search a string field, which ignores non-letter chars, so that querying 'foobar' should find 'foobar' and 'foo bar' and also 'foo-bar'. Is it possible?
<4> add another column and index it for that, heh
<3> but can't I do it with a query?
<4> you can. but it won't be indexed
<3> domas: no problem
<3> but can't find a function which keeps just letters... ;(
<4> udf ! :)
<3> maybe... How hard to install it on the server?
<3> any easier way?
<5> Is it possible to group by 2 columns?
<5> like, month and referrer.
<6> I've got a bunch of /var/lib/mysql/db1-bin.00000x files, where x is between 1 and 40 - they're taking up about 30GB between them. What are then and can I delete them?
<6> *they
<7> Hi guys, my sql statment is returning one element short ... can someone have a look at it for me ... http://pastebin.com/640000
<3> Roobarb-Work: of course, if you don't need your DBs :-D lol
<8> hey all, does anyone have any suggestions for doing some benchmarking on some test data? I've got a 44k entry table with 33 fields (yuck) and I want to time certain statements before and after making changes to indexes etc.
<9> babo that doesn't look like a query that looks like php too me
<7> Ungy: the php part of it is fine ... what's up with the sql part though ?
<6> golya: what are they?
<10> hello.. how do I check a db for two spesific row-id's?
<3> your databases!!!!
<6> uh
<6> you sure?
<3> (: delete and see what happens :)
<6> I thought they were stored in /var/lib/mysql/<dbname>
<9> babo I will give you two hints for getting help in here number 1 do not show your php code give the query alone
<10> like SELECT * FROM table WHERE id = '' ...only that im checking for two
<9> babo number 2 make sure you tell us what is wrong it's not returning somethign doesn't help us saying it is not returning this column or that column does
<3> so, anyone, a function which delete non-alfa chars from a string?
<10> Where A and/or B
<7> Ungy: ok pls disregard the php code ... as for what is wrong ... I've written at the bottom what the error is. And I do appreciate your help ... :-)
<10> hm... babo.. babi
<9> babi WHERE column A = # AND column A = #
<7> babi: maybe you're my evil twin ;-:
<10> heh... probably
<9> babo I do nto see any error listed there
<9> I woudl say he is yoru good twin
<9> Roobarb-Work, what is your table types are they all myisam?
<7> Ungy: the php code is now removed. The problem is that I ask for 8 fields and I get only 7 ... sorry if that was unclear from the pastebin
<9> babo and which field do you not get?
<10> Ungy: thats what I thought.. SELECT b.bookingTabell_ID, b.bookingDato FROM bookingTabell b WHERE b.bookingTabell_ID=160 AND b.bookingTabell_ID=155
<10> but result == NULL
<7> Ungy: recruiter_jobs.arrival ... like I've said in the pastebin ...
<9> babo, did you make another pastebin or somethign cause the one I am looking at has no error and states nothign like that
<11> hey guys, with JDBC and mysql 4.1 is it possible to start a transaction. If so do i just do a normal query with "START TRANSACTION" ...i see there is a commit() and rollback() method
<7> Ungy: oops maybe I did ... sorry ... http://pastebin.com/640037 ... my fault
<9> babo OK first off you are doing a JOIN you probably want to learn to do a proper JOIN Secondly the problem is in the join itself so you fix that your problem shoudl go away
<11> no start() ?
<9> !m babo JOIN syntax
<12> babo: (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<7> Ungy: but I'm not doing a join ?
<9> babo anytime you are returning columns from two tables you are doing a join
<9> babo unless you are doing a UNION which you are not
<7> Ok ... I just want 8 elements back from the statement that I'm using at the moment ... why am I only getting 7 ?
<9> babo your data doesn't match your query properly
<8> does anyone know if there is a function to time statements?
<9> Holy crap Therion is on a MAC I just lost all respect for him ;-)
<9> JediMaster, you mean you want the time it takes to runa statement
<8> yeah
<13> Ungy, what are you running?
<7> Ungy: how do you mean ?
<8> just to do some sort of benchmarking
<9> JediMaster, well I am not sure I know if you run querries directly from client you see results
<9> sjrussel, a PII 800 512 MB RAM Debian SID
<13> so basically, any new Mac is a more powerful *nix machine than yours ;)
<8> Ungy: well the mysql command line client doesn't help much =)
<13> with a better memory management subsystem :)
<13> and better TCP stack
<9> sjrussel, yes but it is a mac so it is overpriced and gives money to a ****ty as company more concerned with how things look then how things work
<9> JediMaster, Yeah I know I can;t think of anything that will help you with it
<13> Ungy - Macs work really well, that's their selling point
<13> as opposed to, say, price
<9> sjrussel, and any Dell works really well no problems until you install third party ****
<7> Ungy: can you be a little bit less obtuse ... which data are you talking about ?
<9> Same goes for any computer makers packaged product
<9> babo how about you read the link I gave you abotu joins once you do and you change your query then come back to me if you already haven't figured it out
<13> uh, sure
<13> 'build your own' is a good philosophy unless you have something better to do :)
<9> sjrussel, if you build your own you may run into problems such is life
<13> it's just not very profitable unless it's a hobby
<14> -S, --socket=name Socket file to use for connection.
<14> what should i put here?
<9> sjrussel, but saying a MAC just works good is pretty stupid statement copnsidering "every computer I have ever built myself just works well" I never have any problems but then I am not a typical idiot who believes marketing bull**** like MAC users do I woudl rather pay fair price for **** then pay there over inflated egos
<9> xwolf-, are you connecting to the local machine?
<13> at my company, we're 33/33/33 Mac OSX/Linux/Windows in engineering... we're covered if there's a big virus, but document sharing is a bitch
<14> yes
<14> but phpMyAdmin cant connect to mysql
<9> ugg phpmyadmin is mysql running?
<14> ?
<13> xwolf - the socket file is configurable in my.cnf IIRC, but can you connect with a shell?
<9> sjrussel, hmm Openoffice.org is on all three platforms is it not
<14> look:
<13> sure
<14> root@almeida:/usr/local/mysql-standard-5.0.19-linux-i686# ./bin/mysqladmin ping
<14> mysqld is alive
<14> root@almeida:/usr/local/mysql-standard-5.0.19-linux-i686# ./bin/mysqladmin ping
<14> mysqld is alive
<14> woops :>
<14> root@almeida:/usr/local/mysql-standard-5.0.19-linux-i686# ./bin/mysqladmin status
<14> Uptime: 1290 Threads: 1 Questions: 3 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 6 Queries per second avg: 0.002
<9> xwolf ok
<14> looks like it's ok, right?
<9> xwolf check your my.cnf
<9> does it specify where the socket is to be created?
<14> lemme look
<15> Anyone here run MySQL on windows?
<14> Ungy i cant find it... where should my.cnf be?
<9> DogWater, I have ran it on Windows and I am sure others have
<14> now i found it
<9> xwolf /etc/mysql/my.cnf /etc/my.cnf something like that
<16> Is there a way to set default settings (host, login, p***, etc) for the mysql client program?
<9> Vlet for a given login you can set thigns in the .mysql in yoru home directory I beleive
<16> thanks Ungy
<16> just didn't know where to begin lookin
<9> Vlet, make sure you secure that for only you to look at
<16> ;)
<14> Ungy /var/run/mysqld/mysqld.sock
<15> Well; my question really just pertains to backup practices; I'd really like to just use retrospect, but they dont have a MySQL backup client; but i could easily create an automated task to do a dump every night of my tables/databases and just backup the dump file
<14> thing is, there is nothing on /var/run
<15> but then if i use the disaster recovery CD the server might not be 100% pristine when it boots up
<7> Ungy: join statement isn't helping ...
<15> I'm wondering if those backup software packages that have the mysql clients are really worth the extra $20000+ they cost
<9> babo did you fix your query?
<9> DogWater, WTF?!?!?!
<9> DogWater, what backup packages
<9> dude I can write a script to back **** up for me mayeb I coudl sell it for $10,000+ and undercut those ***holes
<15> Comvault...
<15> uhh tivoli
<15> lets see I have a list from our storage partner
<15> ungy: what?
<15> I dont think thats a dumb question
<15> Ungy: I dont need a script, I need a piece of software that if I put a cd in I can take a box from baremetal dead to restored in less than 20 minutes
<9> DogWater, well you pay for what you want to do then
<14> Ungy there is no /var/run/mysqld
<9> xwolf-, that is where is specifies?
<15> I'm just wondering if mysql is a little more tolerant than MS-SQL when you're backing it up while its running, or if there is a real need for a bunch of hoop jumping
<9> xwolf-, restart mysql and check the syslog for any errors
<15> I.e. the need for a mysql client
<14> Ungy [mysqld] socket=/var/run/mysqld/mysqld.sock
<14> that's my.cnf
Return to
#mysql
or
Go to some related
logs:
mqueue clientmqueue difference
float number in bash
smtpd_require_helo
recreate host.frm -installation innodb
4(x+3)-x>15?
#bash
#web
webcam+sneex
#python
Win32::ODBC concat
|
|