| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> http://www-128.ibm.com/developerworks/linux/library/l-xampp/ <-- good articel on xamp
<1> I've never used Perl
<1> in fact, I've never looked into it whatsoever
<0> xamp has perl as well (Apache, MySQL, PHP & PEAR, Perl, ProFTPD, phpMyAdmin, OpenSSL, GD, Freetype2, libjpeg, libpng, gdbm, zlib, expat, Sablotron, libxml, Ming, Webalizer, pdf cl***, ncurses, mod_perl, FreeTDS, gettext, mcrypt, mhash, eAccelerator, SQLite and IMAP C-Client.)
<0> I was actually pasting that for osfameron 's benefit ;) but I'm pretty sure -he- can read as well...
<0> I've got a friend who has used xampp with good results recently
<1> I hope so, otherwise he'd be a bit screwed sat on IRC ;D
<1> well I've uninstalled WAMP
<1> and I'm now moving up in life (in the space of 2 minutes) to XAMPP
<0> Kezzer nah...'dragon dictate' diminishes the need for fingers anymore, and with 'true talk' you don't even need to read anymore!...even on irc :P
<0> ...but if you loose your hearing, you're gonna need to learn braille...
<1> surely if I install XAMPP then PHP would work locally just fine?
<2> Providing Mercury is ascendant anddd everything else is according to how it should be :-)
<1> ah, I probably have to put the files somewhere locally yes?
<2> That question really doesn't make sense. What files? And what is 'locally'
<1> to run any kind of script from my computer, where would I need to place the files?
<2> What kind of script, in what environment, under what OS ?
<1> PHP, windows.
<1> I'm talking about using XAMPP here wobbles
<2> So, you have everything installed; does apache work if you do 'http://localhost/' ?
<3> something I never dared do ask but always wanted to know: what is unsigned?
<1> It's ok, I found it
<1> Sorry, I had to place stuff in the xampp dir
<2> numeric variable without negative values
<1> I couldn't actually find anywhere that stated so
<3> wobbles: thanks! Does unsigned make sense in a varchar field?
<1> of course
<2> kombi: No - it is numeric only
<1> when could you ever get a negative amount?
<1> =D
<3> Kezzer + wobbles: point taken ;)
<2> kombi: eg tinyint has a range -128 to 127; as unsigned it would be 0 to 255; more in http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
<0> kezzer, you did read the starting files, right?
<4> hey
<4> is it possible to make a query that changes every time it finds a record?
<4> say i have a table of points and relations, and i want to find the point closest to A, once that has been found i need to found the point closest to that.. etc etc
<4> found/find
<5> Why ndb engine needs to hold all its data in memory?
<5> Do all nodes have the same data ? Do the nodes need to have the same ammount of RAM?
<6> if you have 3 machines with 8gb of memory and 1 machine with 2gb of memory, each node can only make use of 2gb
<5> mhm
<5> and why is it so? is it because of performance -- the data must be availible in memory so it can be replicated very fast?
<5> what about swapping? i guess it should be disabled then.
<6> it's because mysql clustering ****s
<5> :-)
<5> ok..so now something completely different ;P
<5> How could mysql clustering benefit from single system image clusters like openssi?
<7> aloha
<5> would it be only request distribution ?
<5> or is mysql suitable to, for instance, use different processess (which could be on separate nodes) on the same data files
<6> http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-overview.html
<7> can somebody tell me what the point of making views is? i mean, the restrictions are done in the application anyway, so why even make views to restrict what's visible to a user
<8> Jax: convenience, legal reasons
<8> for example, writing queries that use views is basically componentizing your queries
<8> the legal part is also important: if the application can get the p***word, so can someone maintaining the application
<8> if they shouldn't be able to read your birthdate, gender, salary etc., then er... best they can't
<8> if the application doesn't need it either, then it's safer to give the application user access to just the data it needs
<7> hm i guess this is only for large scale projects then?
<7> or where more than one person works on the project
<5> Zaw, i have read it
<5> but there is no much info there
<8> Jax: or, as I wrote, where you want the convenience of componentized queries, or you have legal reasons for not wanting to see your own data
<8> oh, yeah, the latter case more than one person, I guess.
<7> can you elaborate on whta componentized queries are?
<9> well, this may be dumb,but is there a concept of "subtables" in mysql, tables inside another table
<8> mutante: not dumb question. Don't think so though
<7> mutante why would you want to do that
<7> i.e what structure you trying to represent
<9> highscores lists
<7> give some more details so i can help you
<8> ok! So, that might be a case for a view :-)
<9> table scores and inside it score.user1 score.user2
<8> killing 2 birds with one stone
<9> because i want to keep old data with timestamps too
<8> mutante: you'd usually use 2 tables and join them
<9> ah,ok, i need to use join (or union?) on the mediawiki database to get a specific page, that made me look at that before
<10> Hi there
<10> i have a question about mysql type, which one should i have in order to store numbers that have a xxxx.xx format?
<8> Jax: bah, I'm not realy in explaining mode right now, but basically, if you have a complex select that you're going to use a lot of times in part of many oher queries, it sometimes makes sense to make that a view, and then derive the other queries from that view. Saves time, easier to debug etc.
<8> loiic: the first thing you'll want to do is look at http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
<10> i had a look at that which made me use float
<8> (or the equivalent page if you're using a substantially different version)
<8> fair enough. Decimal might also be a good choice
<10> but for simple value, it give me way too much precision
<10> Decimal would give me a simple 2 digit precision ?
<8> loiic: there are probably functions to truncate that. Or look at decimal (at least if you're 5.03+ )
<8> that's what it looks like from that page
<9> "with a precision of 65 digits."
<10> i am 4.1 :/
<8> loiic: well, it looks like you can still use decimal in that case, but it's stored less efficiently
<9> i think you would usually use a round() function in a scripting language to display it shorter?
<10> but it s quite a waste to have such a precision when i only need a very little one
<11> is there a utility that I can use to check if my database has referential integrity?
<10> 0.xx precision would be all i need
<8> or round() in mysql itself - http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
<10> ok i ll do like that then ;)
<9> hmm,or use a "smallint" and add the "." in a script? bad sounds bad too
<8> loiic: if you really care about efficiency then you should try it both with float+round and with decimal and then benchmark them
<10> decimal seems to be much more what i need actually
<10> because it s exact value
<8> if you really only need 2 digits precision and you're not worried about performance then yeah use decimal, it's what you want
<10> float doesnt have an exact value
<10> thank you :)
<8> my pleasure! Any time you want permission to use a db datatype, just ask! :-)
<9> i want boolean please ;)
<9> talking about waste,,isnt that too?
<10> yeah boolean :(
<9> being just a tinyint and not a real boolean as i take it?
<11> how can I check the referential integrity of my database?
<9> tkp: http://www.databasejournal.com/features/mysql/article.php/2248101
<12> Hi Guys! Any idea how I rebuild the uto_increment fields in a table i.e. so instead of the ids having values like 1,3,6,9 they have 1,2,3,4?
<12> i.e. completely sequential.
<13> SimonR, i'm not sure but i think that goes against database normalization or something like that.
<14> SimAtWork, just dont bother as you need to make sure related tables get fixed as well
<9> SimonR: i would like that too, waiting for an answer
<12> There are no related tables to fix :-)
<13> well, if you realy must, i guess you could export all data but the auto_increment field, empty the table, and reload the data
<15> this is one of the most common "There are no stupid questions, just lots of bad ideas" questions
<9> since you can reset the starting id to a specific value,
<9> you could insert new stuff exactly into the "gaps"
<9> until its sequential again
<15> ok, and that's a rarer one :)
<11> mutante: thanks, but that article only describes what referential integrity is and how to implement it
<11> I already have a database set up with many constraints
<11> bubt I want to check if it really is holding its referential integrity
<8> you think it is lying? :-)
<11> as I know there are situations where this can become broken
<11> well for example. Someone turns off foreign key checks, makes some alterations and then turns it back on
<15> take a deep breath, and say "I don't care if there are gaps in my sequences... I don't care if there are gaps in my sequences..."
<11> how do I know it is still holding its integrity?
<15> tkp - in that case, turning it back on probably errors
<11> no it doesn't
<15> however --- are all your tables InnoDB, BDB or NDB?
<11> when you SET FOREIGN_KEY_CHECKS=1 there are no checks done
<15> ok
<11> yes, they are all InnoDB,
<11> it's true (as far as I can tell)
<15> how many tables/checks
<15> ah
<11> so, back to the original question... is there a way to check the referential integrity of a database?
<11> I have 73 tables
<15> I don't think there are tools, but it's a simple thing to do in perl if the db is quiet
<12> Hey - don't shoot me! We have inherited a very badly written app and now the client want's us to sort this mess out!
<11> if the db is quiet?
<15> SimonR - fine, but don't try to renumber the keys
<12> Thanks :-)
Return to
#mysql
or
Go to some related
logs:
proxy problem in synaptic package manager
#ubuntu
failed
aircrack rt61
postsuper bash mailq awk sender delete
#ubuntu
fast suse ftp inst-source
#sql
schedule_delayed_work osx
mbr-backup dd if
|
|