| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> Ahh Milosevic died
<1> yeah
<1> 30 edits in 10 minutes to his article..
<1> ;-)
<0> lol
<0> at least half of those had to have been cleaning up ugliness
<1> well at first 50/50 were "milosevic died!" vs "revert, unconfirmed"
<1> ;-D
<1> always love that abuse of resources
<2> infi: thank you very much. this was very informative.
<3> Welcome
<4> why when I declare mydate date default current_date , I receive a syntax error?
<4> nobody can help me about date?
<5> I want a friend too
<6> Hello, I'm running mysql 5.x on my SuSE 10.0 computer and i'm trying to access my mysql server from my other computer but i get: <myhost> is not allowed to connect to this MySQL server
<5> www.mysql.com/grant
<4> hey? where is the problem in my statement???
<4> mydate date default current_date
<4> it doesnt work
<4> :(
<5> cause defaults have to be constants
<5> only exception is on timestamp columns
<4> the value returned by current_date() is not a costant?
<5> no
<5> it'll be different from day to day
<4> hmmm
<6> and where should i type GRANT ALL ON *.*
<5> _atidem: any specific reason you can't use timestamp instead of datetime?
<5> oh, just date
<5> if you run 5.x you can just use trigger for it
<6> flupps|US
<5> Factory|David: in your client
<6> On my other comp?
<5> yes
<4> flupps|US: I found a workaround
<4> a call to function current_date() in insert statement
<5> that'll work
<6> Well where on it... Since my mysql server is on my suse comp and i'm trying to connect to my mysql server on my suse comp from my windows comp but i get host "192.168.0.xxx" is not allowed to connect to this server
<6> no one?
<5> Factory|David: in your client
<6> and what do you mean in your client, should i type mysql -u root -pp***word
<6> and then GRANT ALL ON *.*
<5> probabaly should read the security chapters
<5> to understand how host/user account information works
<6> i know, im jsut gonna take my host but it aint working any way
<6> i type GRANT ALL ON *81-231-254-4-no53.tbcn.telia.com*;
<6> but it aint working
<5> how did you get to that command?
<6> from the page you gave me
<6> Global level
<6> Global privileges apply to all databases on a given server. These privileges are stored in the mysql.user table. GRANT ALL ON *.* and REVOKE ALL ON *.* grant and revoke only global privileges.
<7> Factory|David: grant all on *.* to username@'host';
<6> ty
<6> not working
<8> hello
<5> !tell use about not working
<9> But I don't know a thing about that.
<5> !tell us about not working
<9> But I don't know a thing about that.
<5> !tell us about doesn't work
<9> flupps|US asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message. Tell us what it does and/or does not do.
<8> I am trying to convert a large mssql database to mysql and so far its all good but one thing
<6> grant all on myhost to root@'localhost';
<8> would anyone know what sort of datatype would be equivalent to image ins mssql
<5> psyko_php: what would you store in an image datatype?
<5> binary data?
<8> flupps|US: I am not too sure this particular database does not have any data but it is used in all the schools in the uk and some school might have some data in it
<6> why isnt it working like i want
<10> how do i save numbers that start with 0 in mysql?
<10> using FLOAT?
<5> psyko_php: ok, found a reference for SQL server, MEDIUMBLOB has the same characteristics and size
<5> turbano: is it always the same width? if so you could check out the zerofill attribute
<8> thank you
<10> flupps|US => no, its a zipcode field
<10> could be from 5 to 9 numbers =/
<5> US only?
<11> hey guys, i got a large query that i'm doing (i'm using php and mysql) and it's gonna look like - $query = "SELECT event_date_id, event_datetime, event_id, ..... etc etc... --- can i put each of these thigns that i want to SELECT on seperate lines.. so i don't have to scroll horizontally?
<5> some countries have characters too
<10> flupps|US -> no , worldwide
<10> yes
<5> like UK
<10> i will make it a STRING
<12> is KEY rating (rating), the same as INDEX rating(rating), ?
<5> that's probably your best bet, yes
<5> swarmz: yes
<12> thans
<12> thanks
<13> how can I do a SELECT with FIELDS TERMINATED BY without using INFILE? want to use it with batch-mode from the cli...
<8> flupps|US: thank you very much
<5> psyko_php: sure thing :)
<5> blizzard_: you mean OUTFILE?
<5> minDscrm: usually handle that stuff client-side.
<5> minDscrm: formatting is for your application, not the database
<13> flupps: dont really want to use a file at all, I just want to do a SELECT from the CLI and have the fields terminated by a ;
<13> values will go straight into an RRDTool Graph (via a wrapping script checking some stuff), and I would like to avoid using a tempfile
<14> How do i check how many connected users mysql can have and max querys /s ?
<5> blizzard_: mysql -Be "SELECT....." db | perl -lpe 's/\t/\;/g'
<5> would that be acceptable?
<5> xnor: SHOW VARIABLES LIKE 'max_con%'
<5> xnor: hardware limits qps
<14> flupps|US ok, great thanks!
<5> (well, design and code, etc also limits qps, of course, bad design = bad max qps)
<13> flupps, but what about those fields which are NULL?
<13> they will magically dissapere with that perl thing right? while they will be within ;; with a FIELDS TERMINATED BY and they wont be lost, right?
<5> hmm
<13> brb, dinner...
<14> gaaa! i have max connections = 100, i run a server with about 10 000 visitors/month, hwat happens when 100 is reached?
<15> max connections are max connections at the same time
<5> will get an error saying max connections are reached
<5> but it's simultaneous
<14> flupps|US okey thats maybe okey then, a query in my system goes really fast ;)
<15> best is to set maxconnections in apache or the webserver you use to just below the database maxconnection
<15> like if you have 400 in apache then put 401 in mysql
<15> the extra one in the end is so you can logon as admin to see whats going on in case something bad happends
<15> this way the webserver will only serve 400 clients at the same time (based on requests)
<14> Apachez ahh hehe thats true ill check my apache.conf
<15> it will also have a backlog so if you get a burst of say 500 DoS attempts the first 400 will be served while the other 100 will be in queue until one of the first 400 handlers are ready to take another request
<15> both apache and mysql has backlogs
<14> in apache conffile i have maxclients=150, is the keepalivetimeout the time each client have before the server releases?
<16> does anyone have or can point me to a generally agreed table structure for a book database?
<15> keep alive is the maximum time the handler will wait for requests
<15> in a busy site the keepalive should be set to 5 seconds or something
<15> the point is to create a handler takes some cost of performance
<15> and if one client sends like 10 requests at the same time to the server through same socket then keepalive makes sure only one handler is being used and have optimized away the cost of crearte like 10 handlers
<15> but i think if there come another query then the server will take care of that
<15> keepalive is more the max value to wait for new command from client
<16> what data type would you use for ISBNs?
<14> Apachez ok great
<0> kombi: varchar(50) probably
<0> kombi: or shorter...
<16> Therion: it only has 13 digits (the new version)..
<0> kombi: so use 13 if you have total control of your data
<7> kombi: varchar(13) then ;)
<0> I have seen too many "ISBN" numbers that did not comply to expected format
<15> does it always have 13 chars ?
<0> kombi: If you're confident it will be X length and always X length, char(X). ;)
<16> Apachez: it used to be ten, it is now transfered to 13
<0> Depends on what you're doing and how much control you will have over ensuring proper data format
<16> Therion: I will have to cut out any dashes beforehand though. Is there a real advantage to save every char?
<0> kombi: Just depends on what you're doing....
<16> like does it make much of a difference having varchar(32) or varchar(16)?
<0> Depends on whether you store more rows of 16 chars or 32 chars :P
<16> point taken ;)
<0> If the extra bytes > 16 characters are unused, there is no difference
<0> Pointer sizes and such will remain the same
<7> disk is cheap, use 32 :D
<0> One application of mine just uses 50 because booksellers will cram all sorts of nonsense into the "ISBN" field.
<0> I can't stop them from doing it so I have to adapt to their doing it
<0> Your mileage hopefully varies.
Return to
#mysql
or
Go to some related
logs:
hate.py
xwine screenshot
#perl
find symbolic links linux
entrance_edit
cross-compile+icecc
#oe
gtetrinet *** glibc detected *** double free or corruption (fasttop):
#osdev
fissy candy
|
|