| |
| |
| |
|
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> high capacity.
<1> I guessed connections...
<0> connections works too.
<0> Basically I'm just trying to get a feel for where I should take my investigation.
<1> Talk to sjrussel. He's a pro.
<2> or jamesday
<3> heh
<1> Or Duesentrieb.
<2> not really :)
<4> read harrison fisk's new book
<1> :(
<0> Right now I've got several alion and f5 load balancers I can use on the front end of a replication pool to give me some sort of HA. Just wanna get some first hand anecdotes really.
<3> or Zw...dy's
<1> heh
<3> the yahoo dude
<3> !google mysql super smack
<2> i just sit and watch jamesday and domas work ;)
<5> mysql super smack: http://jeremy.zawodny.com/mysql/super-smack/
<3> that guy
<0> I know that guy. ;)
<0> He's in my local LUG.
<3> that guys pretty smart, ask him
<3> just don't start with 'Yahoo! ****s, but...'
<6> if i get missing .frm file of a table, what can I do to fix that?
<6> repair table?
<3> heh
<3> missing .frm?
<3> you lose
<3> find a backup
<6> ****
<1> That's not a nice word.
<7> !man table recovery
<5> (Table Maintenance and Crash Recovery) : http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
<1> Sure can't recreate a .frm from a MYI?
<3> yeah
<3> .frm == data description
<8> Hey guys
<8> I notice PHPMyAdmin can store/display a "table comment" -- is this something PHPMyAdmin stores, or a feature of MySQL?
<7> beerdeliveryguy: see http://dev.mysql.com/doc/refman/5.0/en/repair.html under step 4
<3> you could copy the .MYD somewhere, recreate the table
<9> why does it gotta be guys ?
<9> why can't it be girls ?
<1> Duesentrieb, Do you work at/with wikipedia/
<1> ?
<3> copy .MYD back and try to repair
<8> #1, obvious reasons. #2, the connotation of 'guys' is not limited to males.
<3> but you need to create the table somehow
<8> #3, maybe I'm only speaking to the males in the room. :]
<9> ***ist pig
<1> oink
<1> HELLO PEOPLE OF #MYSQL
<9> a/s/l check!
<8> f/fmfma
<9> slut
<8> will, do you know whether the "table comment" mechanism PHPMyAdmin has is part of MySQL or a PHPMyAdmin feature?
<8> I'm trying to avoid digging through their source to find where its pulled from.
<1> !m Julian|Work create table
<5> Julian|Work: (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<2> will[werk]: i'm involved in content and code, but don't have (shell/db) access to the servers
<8> Nice.
<1> ah
<1> So many wikipedia people...
<1> So many MySQL people
<1> I'm glad I'm an individual.
<2> will[werk]: http://meta.wikimedia.org/wiki/User_talk:Duesentrieb/Tools
<2> uh, sorry
<2> http://meta.wikimedia.org/wiki/User:Duesentrieb/Tools
<2> better :)
<1> heh
<10> whats wrong with this
<10> $sqlquery2 = "SELECT * FROM koppel INNER JOIN klant ON koppel.klantID=klant.klantID WHERE bedrijfID = $bedrijfID
<10> ORDER BY bedrijf_naam";
<1> !tell us about whats wrong
<5> will[werk] asked me to tell you this: Don't ask us "What's wrong with this query...". We are not SQL parsers. We do not care to look character by character looking for errors when MySQL will tell all of us WHERE the error is. Paste the FULL error issued by MySQL.
<10> it doesnt give result if i do 'ORDER By'
<1> echo $sqlquery2
<9> there is no Ted .. just koppel ?
<10> ted?
<9> Koppel
<1> HS^, Most likely you need bedrijfID ='$bedrijfID'
<1> But I just guess. Make sure you use mysql_error();
<10> SELECT * FROM koppel INNER JOIN klant ON koppel.klantID=klant.klantID WHERE bedrijfID = 3 ORDER BY bedrijf_naam
<1> Oh
<1> What does mysql_error() say?
<1> Duesentrieb, It's all in German....
<10> it gives a error if the query is wrong i think
<1> Exact error.
<10> so i echod the query..
<10> i dont know
<2> will[werk]: eh? what is? use the second link.
<1> We won't know either.
<10> this is the query
<10> SELECT * FROM koppel INNER JOIN klant ON koppel.klantID=klant.klantID WHERE bedrijfID = 3 ORDER BY bedrijf_naam
<9> if it's not returning any data
<1> Duesentrieb, Oh lol. I thought I was.
<9> then there is nothing wrong with the query
<10> is it wrong query, if i remove the ORDER BY ... it works
<9> there is something wrong with your data
<10> so i think something is wrong with order by
<1> No
<10> yeas
<1> No
<9> noas
<1> Do you get an error? Are you checking for errors with mysql_error() ?
<9> what table is bedrijf_naam in ?
<11> hi, how many connections MAX can a dual p4 /4gigs of ram handle. I cannot seem to get over 500
<9> what is the circumfrence of the earth ?
<9> elive: then you have your answer
<11> I heard you can get over 3000
<1> So why do you ask?
<1> What happens at 501?
<9> yes you can
<12> is it possible to put something in an ORDER BY clause that will drop a certain value at the bottom
<1> "Drop a certain value"?
<12> i have a list that has an Other value, i want that to be ordered at the bottom
<11> I just need to know.
<9> artnez: no, thats a where clause thing
<11> I don't think I have it configured properly
<9> artnez: yes you can
<1> Yes, you can go over 500 connections. Are you sure you need 500 active connections?
<12> vluther: how?
<9> by changing my.cnf
<1> heh
<1> ^Artnez, ORDER BY IF(col = 'Other', 1, 0 ), col
<9> buying better hardware, and sending me $3404
<11> will, I want to know if there is a large difference between the amount of connections a commercial copy of mysql can handle compared to a community version.
<1> No
<12> thanks will
<9> there is no difference
<1> Well, possibly....
<9> it's like the spoon
<1> Depends on what libraries I guess, and the fact that the "commercial" one you'd get help :)
<9> i shall shut up now
<11> will, then what is the largest amount of silmuntanious connections a mysql server can handle. ~1000?
<11> mysql-ab
<1> I don't know. I've never needed that many. My connections are for like a second. So I've never needed more than like 50 at any given second.
<9> elive: it depends on server configuration
<9> the whois db is answering about 25,000/second
<0> Elive_user: We are running over 2500 and are looking for the upper limit.
<1> Glad I'm not whois
<11> thanx man
<1> Just make sure to close your connections when they are done.
<1> Connections hogs resources.
<9> and don't use pconnect
<1> Using pconnect is like using your sister in bad ways.
<7> bump the thread_cache up a bit too
<9> but what if your sister is Ms. Oklahoma ?
<1> Use a blindfold.
<9> she darn well be purtiest girl in city
<9> why do i gotta blindfold her ?
Return to
#mysql
or
Go to some related
logs:
fedora disk limit
unrar-free usage
#math
#css
#css
usb_bulk_write 4 bytes
icyfire0573
distccmon authentication Rejected
#gentoo
#perl
|
|