#mysql
30 September 2007
Total 19 pages. You are browsing page 19/19.
First :: Prev :: [...] [15] [16] [17] [18] [19] :: Next :: Last
23:30 <****> maestrojed: what's it say?
23:31 <****> chadmaynard: [fail]. I can look in that system log again
23:32 <****> `DoM`: you say there is no external access to this server? you haven't been compromised by Russian kiddie-porn traders?
23:32 <****> chadmaynard: are you saying that all *.MYI "must" reside only on datadir and not tmp one ?
23:32 <****> yes
23:32 <****> chadmaynard: so .. i have a question.. how it's possible that ? do you have any ideas ?
23:33 <****> `DoM`: backups? your datadir is /tmp?
23:34 <****> chadmaynard: no is not my tmp dir is /usr/local/mysql4/tmp
23:34 <****> my datadir is /usr/local/mysql4/data
23:35 <****> then mysql isn't using /tmp
23:35 <****> chadmaynard: My guess is that is still has a problem with this "nice" entry. This box's ip is 192.168.0.160 which is what I set the 'nice' to in the my.cnf. I see in my daemon.log "mysqld[5727]: nice: invalide adjustment '192.168.0.160'.
23:36 <****> Ok, so I now have access to the user's local timezone, should I use php to convert the timezone, for example my timezone is '-7'
23:36 <****> chadmaynard: yes i find large files inside /usr/local/mysql4/tmp
23:36 <****> maestrojed: comment that line out
23:36 <****> `DoM`: but not in /tmp
23:36 <****> right?
23:39 <****> chadmaynard: yeah it successfully loads with that line commented out.
23:39 <****> maestrojed: keep it that way then! you aren't using it anyway are you?
23:39 <****> chadmaynard: right
23:39 <****> chadmaynard: I don't even know what it is :)
23:39 <****> `DoM`: mysql has to sort data. that's just how it is
23:40 <****> maestrojed: then you surely don't need it!
23:40 <****> chadmaynard: Thank you for the help
23:40 <****> chadmaynard: it still possible that someone try to hack but phpmyadmin and maybe do it.. i am checking..
23:40 <****> chadmaynard: *by phpmyadmin
23:41 <****> chadmaynard: may I ask what 'nice' is or is used for? I am trying to learn as I do all this
23:41 <****> `DoM`: what are these servers for if i might ask? you running a hosting company?
23:42 <****> seems like an aweful lot of dbs
23:43 <****> blobaugh: yes a hosting company
23:43 <****> maestrojed: sets the nice level
23:43 <****> maestrojed: http://en.wikipedia.org/wiki/Nice_level
23:47 <****> whats an easy way to copy a db
23:47 <****> via mysql-client
23:48 <****> as in copy 1 db to another
23:48 <****> without dumping it or anything
23:49 <****> Fr0zen_: myslqdump -u root -p old_db | mysql -u root -p new_db
23:49 <****> chadmaynard: so i was wrong.Data file with large dimension is .MYD and name is something like #sql_6638_0.MYD
23:49 <****> `DoM`: ever seen using_filesort in explain output?
23:50 <****> chadmaynard: the .MYI for that file is like other about 1024b
23:50 <****> chadmaynard: i check now on mysql log
23:50 <****> chadmaynard: i saw this by lsof mysql process
23:52 <****> ki77a77 will that copy it, or move it
23:53 <****> Fr0zen_: that will create new_db that is a copy of old_db
23:53 <****> for match against search do I need a seperate column to store it or something? I keep getting "Can't find FULLTEXT index matching the column list"
23:53 <****> chadmaynard: mmm let me understand, on mysql log i saw an id number near each like and i find same id as file inside tmp (6638).Maybe i find something i was looking for ?
23:53 <****> Fr0zen_: copy it
23:54 <****> Level9Wizard: must be a MyISAM engine and add fulltext index on proper columns
23:56 <****> chadmaynard, Is it possible to set this from phpmyadmin 2.8.2.4?
23:57 <****>);
23:57 <****> chadmaynard: thank you bunches!
23:57 <****>) AGAIn......
23:58 <****> maestrojed: my pleasure
--- Log closed Mon Oct 01 00:00:38 2007
Total 19 pages. You are browsing page 19/19.
First :: Prev :: [...] [15] [16] [17] [18] [19] :: Next :: Last