| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> then you can just have the id for each host in the table
<1> hi people
<0> otherwise you repeat the name on every row
<0> which leads to an unnecessarily big table
<0> same with useragent, referer, method, host...
<0> probably some others
<0> as a general rule if data is being repeated there is something wrong
<1> can someone advise my with a configuration for innodb, and why should i do it?
<1> i have -> innodb_data_file_path = ibdata1:10M:autoextend
<1> does this mean that'll have a file every 10MB ?
<0> it would lead to a much smaller table too
<1> if i have 100MB of data, i'll have 10 files?
<0> also i expect that integer comparisons are much quicker than varchar comparisons
<0> since integer compare is a processor function and all :P
<2> I use WHERE vhost='sub.domain.com'. but seperating would then create more complex queries (inner joins and the such), during insertion too, having to check if the user agent is already know, adding it to its own table if it doesn't exist, get it's ID, then insert into the main query...
<0> it would go much faster with the design that i suggested
<2> ok, but would it be even faster than actually separating the vhosts?
<0> not sure
<0> i doubt it
<0> but it should be almost as fast
<0> in any case, you will be looking at a huge improvement in performance
<2> the table actually contains 1 642 340 rows. if I seperate vhosts, some tables will still contain up to 500 000, that might still be slow
<3> how do i turn debugging messages for mysqld?
<2> or maybe something else would be faster (sqlite?)
<0> retroneo: it will be faster if you get rid of the repeated data
<0> i routinely query table much bigger than that at work
<1> can someone explain me what will happen with this configuration?
<1> ibdata1:1000M;ibdata2:3000M;ibdata3:1000M:autoextend:max:4000M
<1> if my innodb database get 10GB the files will autosplit?
<4> Hello
<4> I'm an utter newbie when it comes to SQL.
<4> When I try and log into my phpBB forum with the 'Remember me' option ticked, I get this:
<4> Fatal error: Call to undefined method sql_db::sql_error() in /var/www/linuxp2p.com/forums/includes/functions.php on line 624
<4> I looked at that line, but all it says is:
<4> $sql_error = $db->sql_error();
<4> Can anyone help me out please?
<5> hello
<2> DaBlade: try commenting that line out
<4> retroneo: Alright
<6>
<4> retroneo: Now I get this: http://pastebin.com/634055
<2> is your phpbb source code original? it should work out of the box; if you hacked it, check there
<4> retroneo: It is, however I switched server a few days ago
<4> that's when the problems started occouring
<5> how are you ? Did someone use Mysql++ ?
<7> This charsets are giving me headache...
<8> Hello there
<8> i got some problemes with IPB forum and mysql 4.1
<8> after upgrade of mysql version 3.23 to 4.1 IPB table are frequently corrupt
<8> but not other forum table like vBulletin table or PHP-BB table
<8> do you have any ideas ?
<8> we set charset to latin1_general_ci
<8> we have fixe right of user after upgrade
<7> I think it is an IPB problem, check if it doesn't require any fix when database updates
<8> in my mind i think it's an MySQL probleme because table are corrupt by accent, accent do strang things.
<8> ha have the last version of IPB
<8> -ha +we
<7> you mean problem with ?
<8> yes
<7> Wait, .1
<7> it's charset problem
<7> Im with the same
<8> do thing like for
<7> check the charset of the website and the charset of the tables
<8> website is in iso-8859-15
<9> hi, can a key be both foreign and primary in a table?
<7> sure
<7> I mean, by the logical side
<7> I believe MySQL support it
<9> heh, but its not recommended?
<9> i have a table with productinfo, and one with productstatus (with quantity and price and such)
<10> what's the correct way to reset a datetime to 0000-00-00 00:00
<9> and the prod-id, is autoincremented, so when i insert i have no idea what the articlenumber is (or can i get that somehow?)
<0> minoan: you mean apart from last_insert_id() ?
<11> I'm really stressing over storage of an IP
<12> howdy
<12> -bash: mysqladmin: command not found
<12> how do I set root pw?
<11> Guest53351: rtfm, its on almost the front page
<12> lmfao
<12> the manual it comes with?
<11> Guest53351: the one on the mysql site
<0> it comes with one ?
<0> i always just use the one on the site
<0> did not even know there was one included with it :P
<11> andrewbryson: I'm pretty sure it isnt
<12> wow
<12> its such a bitch
<12> lol
<12> do i need a mysql root pw
<12> or is just a thing
<11> Guest53351: its empty by default
<12> yes.
<12> but do they/you recommend setting it.
<11> Guest53351: of course
<0> lol
<12> lmoa
<11> andrewbryson: is there a function in phpmyadmin to facilitate the storage of IPs?
<12> anyway screw that
<0> phpmyadmin ? :|
<2> can having thousands of tables in 1 DB cause any problems?
<0> why would i use that ? :|
<0> retroneo: only if you try to put their files all in the same directory
<2> I imagine thats the default, how can I change that?
<0> not sure - i have never needed to
<0> but there will be instructions in the manual :P
<13> Guest53351: The root p***word has nothing to do with the error you showed above.
<12> i am aware
<12> i fixed it
<14> morning
<13> retroneo: Why would you need thousands of tables in one database? Is the design that complex or is this an issue of denormalized data that might best be normalized a bit more?
<15> hello
<16> hello
<15> i've a problem with utf8 :P
<15> someone can help me ?
<2> Xgc: a batch script populates it with the server logs (1 month=1gb), a PHP application uses the data in it, but only for 1 vhost at the time, which each coresponds to a user that already his own DB
<12> god gentoo is a whore
<17> hi all
<15> my website is in utf8 but the values in textera don't apear correctly in phpmyadmin
<15> MySQL - 5.0.19-Debian and phpMyAdmin - 2.8.0.2-Debian-3
<2> Xgc : I could insert the logs by vhost in the coresponding user's DB, but that would make me need to select a new DB for every insert in the batch script
<15> phpmyadmin is in utf8_unicode_ca
<15> --ci
<17> hey, i'm trying to set up replication but the 'show master status' command on the master returns nothing
<17> i have binary logging turned on and a serverid
<15> someone ?
<13> retroneo: INSERT INTO dbname.tablename ...; -- might be a better approach. Connect as a user that has access to all the necessary databases.
<2> Xgc; thanks, that's just what i needed
<14> gniretar_work: http://dev.mysql.com/doc/refman/5.0/en/replication-slave-sql.html
<14> uhm, http://dev.mysql.com/doc/refman/5.0/en/replication-master-sql.html even
<17> K_F: I'm already at the MySQl docu. http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html
<17> it says to lock the tabels
<17> tables*
<17> take a snapshot
<17> then to a 'show master status'
<18> Hey all.
<18> I recall reading in the mysql docs that "SELECT *" is depreciated. Is this true?
<18> If so, what should be done instead?
<19> its not deprecated
<19> and never will be
<19> its just not recommended for general use
<17> I figured it out
<17> i guess mysql doesnt put certain config paramaters into effect when you reload
<17> one mustn restart
<17> must*
<20> How do I get a dump created in mysqldump 4.0.25 to import into 4.1.11?
<10> Xgc what's the right way to reset a datetime column to 0000-00-00 00:00 ?
<10> i just do myDate = 0 for now
<10> which seems to work, but not sure if it's compatible
<21> hi
<21> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Return to
#mysql
or
Go to some related
logs:
#debian
#gimp
#perl
#perl
fc4 new kernel black screen cross
#perl
nvidia-glx etch missing
perl cannot configure a generic socket
dorksuit
#lisp
|
|