| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> muahaha
<0> Juzzy: Kill it, it was just a wild crazy ***ed idea
<1> i hacked the **** out of the ****ty php and sql
<2> in the cms?
<3> i cant use like and wildcards
<0> Juzzy: Unless you want to try partitioning, you're going to have to change the way you store it to make that work
<3> b/c some cl***es are whole cl*** A's
<1> in the bbs software yes
<3> if it were all cl*** bs or c's i could
<1> we're still on the dual xeon that we thought we were upgrading from
<2> but is there some thing I can do to improve the mysql?
<2> wow
<2> I'm migrating from a dual xeon too!
<3> Therion: if i split it into 3 tables, ipfrom and ipto in their own with an id, think i could get preformance joining them?
<1> quidam: probably.. start with latest supported binary from mysql.com
<0> Juzzy: No
<1> and if possible, find out what queries take their sweet time..
<4> Therion, can i ask you sth in query?
<1> no
<4> not mysql ;)
<1> unless it's his a/s/l
<2> did you tried recompiling the kernel?
<4> its with the bot ;)
<0> abchirk: If you want
<5> Juzzy: ***uming the range is distinct, try something like ipfrom <= ip order by ipfrom desc limit 1 may be better
<3> yea that may work
<1> nope, quidam.. of those options were not available to me, as i'm just the admin/programmer for the forum.. and the guy had changed dns quickly
<2> hmm
<0> It's one of the ways I was going to suggest doing it if you had splitted it into nets and such
<0> but might work with this form too
<0> Might work better ;)
<2> I think I will try that too
<1> but, first figure out 1. why do you think you need to upgrade.. on the original server, turn on query cache, and slow query loggin
<0> !join #mysql.de
<1> find the guilty stuff
<1> hunt down the guilty!
<2> oh, it is not my server, i'm only migrating it for a client
<1> if it helps, if you're using any thirdparty plugins and enhancements.. they're usually crap
<2> heheh
<2> hmmm
<1> just parse the code for select *
<1> 38,000 users is not terribly large. how many posts ?
<2> but the database performance is low, even with phpmyadmin
<0> Juzzy: If you just get crazy you might also try partitioning with a hash on your IP ranges
<2> about a milion
<1> is it during the siege test ? or db performance is low no matter what ?
<2> no matter
<1> if that's the case.. talk to the planet support people, they have gold support, make em fix their ****ty servers
<2> it takes 15-30 seconds to draw the main table
<1> keep in mind, less than $400 for a dual core dual opteron with 2GB ram ...
<1> and it's apenguin computing box..
<2> I think it is too much server for that work
<2> but I'm not a forum admin, so my experience is limited
<1> the specs on that box, should make everything you do happen pretty quickly
<1> if you know linux/mysql/php that's all you need to know.. find the cause of the problem first, then see if it's a hw issue or a code issue
<0> litheum: DIE COMMIE BASTARD
<0> !kick litheum FREEDOM!!!!!!
<1> uhh
<1> i thought commies were are friends.. it's the islams we're against now
<1> wow
<1> s/are/our/
<0> I am against everyone
<2> alphablue, I'm a little lost, because apache performance is brutal
<0> Die terrorist!
<0> woo magic-removal is done
<1> quidam: just run a mysql benchmark on the system first
<2> good idea
<0> Listening to alphablue is never a good idea
<0> Worse than listening to me when I've been drinking
<1> make sure you've run mysqlcheck and sent me $55505 first
<2> but... how?
<1> google for mysql benchmarking tools
<2> ah, ok
<1> and paypal
<1> ok seriously now, i need to take the cat out
<1> he thinks he's a dog
<2> ok
<2> thank you
<6> I have a question how would i go about changing the permissions of a user in a linux install?
<0> Linux system user, or mysqld user?
<6> myswl user
<0> GRANT and REVOKE statements, or use a GUI tool
<0> !man grant syntax
<7> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<6> thank you very much
<8> can i turn on query caching with a sql statement?
<5> JakeConnor: using SET statement
<8> does SHOW VARIABLES LIKE 'have_query_cache'; mean that it is running?
<8> ... if it returns yes?
<1> if it says yes
<9> I have a question about how to execute a query and return certain results.
<9> Here is an abbreviated version of the table structure of the two tables I am working with: Table A has a field 'OriginalArtID'. Table B has a field 'ArtID'.
<9> How can I select from Table B, and *exclude* any rows where *any* 'OriginalArtID' row in Table A matches the field 'ArtID' in Table B?
<5> fury: maybe left join
<6> what file would i need to edit to change the permissions of a mysql user?
<1> Arthur: look into GRANT syntax
<6> sorry i dont understand i installed xampp so am not to familiar with Mysql
<9> lokus, hmm, well Table B might not be able to join with Table A, because there might not be a row in Table A that matches ArtID in Table B
<9> does that still make sense?
<1> Arthur: download mysql administrator
<1> and work from that
<6> ok
<1> Vanish like as in Vanish into thin air ? or Vanish as in.. vaneesh ?
<6> thanks
<10> how do i delete a table with a foreign key constraint?
<10> alter table runs add constraint fk_routes foreign key (route_id) references routes(id), there's how i added the constraint
<10> but i've deleted the runs table, but it won't let me delete the routes tables
<6> i just installed mysql administrator and cant find out how to start it.. Any ideas?
<1> Arthur: Start -> program -> mysql....
<11> Sorry. Off in another channel. As in 'into thin air'
<1> ahh
<10> hey i'm having problems deleting a table because of a foreign key constraint, is there anyway i can force delete the table and/or the constraints?
<12> set foreign_key_checks=0
<13> heh you cant drop a table without deleting its contents?
<12> uh
<13> fine
<12> what do you expect drop to do?
<14> That would be a neat trick if you could.
<13> s/th/thout/;
<13> better?
<12> no, now it makes no sense
<12> withthoutout?
<10> so is there anyway to remove foreign key constraints?
<13> eh
<13> I didn't even look at what I said
<13> I just guessed at my mistake :)
<10> alter table runs remove constraint?
<13> gleam_: are you confused yet?
<10> gleam_: thanks for that tip worked perfectly
<12> no, i've already ***igned you into a category in my head
<13> fair enough
<12> have you decided on a new question?
<13> heh you cant drop a table without first deleting its contents?
<12> sure you can
<12> drop table mytable
<12> what's the problem?
<10> mage: yeah it just works
<13> then why was he having issues with forien keys?
<13> *foriegn
<12> the issue isn't with the data, it's with the structure
<12> even if it was empty he'd have a problem
<12> foreign keys are called constraints for a reason
<10> mage: because i had a foregin key ***ociated with Users from the table Routes, mysql wouldn't let me drop the table
<13> oh okay
<10> http://www.databasejournal.com/features/mysql/article.php/10897_2248101_2, apparantly the only way to drop a foregin key is to get it's internal id
<12> yes but it's not particularly hard to get its internal id
Return to
#mysql
or
Go to some related
logs:
terminal compy paste mouse
#php
esddsp skype bus error
#osdev
mysql money column
#linux
cm823f manual
#perl
#qemu
solaris 10 vmware tools pkg
|
|