#mysql
31 October 2007
Total 29 pages. You are browsing page 2/29.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:35 <****> so my guess is for some reason the table in question isnt staying in the bufferpool, or the indexes are too big for the bufferpool or something
00:35 <****> would that make any sense ?
00:36 <****> any time there is an insert on a table, would it add anything to the buffer pool ? we do have a high number of inserts and updates on a few of our tables, ie 10-15 insert/update combos per second....
00:37 <****> nkbreau: if you're talking about the query cache, mysql caches query result sets. But it flushes the query cache when the underlying tables change because of inserts or updates.
00:39 <****> hello
00:39 <****> need help with website, as I am trying to update the database, and then display one of the fields. I am able to update, but then I am not able to display the field, any ideas? http://pastebin.com/d2f0a225
00:39 <****> nkbreau: every commit writes to the disk
00:39 <****> I'll explain the scenario in detail....
00:39 <****> basically we have a dsatabase with 10-15 inserts/updates per second
00:39 <****> nkbreau: if you commit every insert/update there will be at least 1 disk write
00:39 <****> for each commit
00:39 <****> Xgc, thanks for all your unbelievable help today. It's greatly appreciated. I've got it all working now and you've certainly taught me a bunch with using derivatives. Still trying to figure out the relation between tables and the top select, but I'll get it soon enough :) Thanks again!
00:39 <****> when the database and app first load, everything is slow for the first few hours from disk io (i think) until everything seems to be cached and mysql rarely needs to go to disk
00:40 <****> flexo: You're welcome.
00:40 <****> lately, one of parts of the application seems ot be getting slow on occasion, and when it does i notice the query is doing alot of io on disk
00:40 <****> lol
00:40 <****> so it seems like suddenly whatever was being put in the cache, is being evicted
00:40 <****> compiling with the c flag k8 crashed myself
00:40 <****> mysql
00:40 <****> cputype
00:41 <****> Xgc, mind if I PM you real quick?
00:41 <****> nkbreau: not really, every commit from your insert/update writes to the disk, transaction log
00:41 <****> or the index/table which used to fit in the cache doesnt anymore... or something like that
00:42 <****> nkbreau: possible, you can check with "show innodb status"
00:43 <****> what would that show ? ie what should i like at in the innodbstatus ?
00:44 <****> there is a simple statistics of the buffer pool
00:44 <****> to an output file somehow ?
00:45 <****> help
00:45 <****> there is a tee command
00:46 <****> if i pu tthe results in pastebin you mind taking a look to see if anyting seems wrong or fishy ?
00:46 <****> try to read yourself, find the memory with buffer pool part
00:47 <****> this?
00:47 <****> Total memory allocated 11748249540; in additional pool allocated 47635968
00:47 <****> Buffer pool size 640000
00:47 <****> around there
00:47 <****> Buffer pool hit rate 997 / 1000
00:47 <****> thats probably a good number...
00:47 <****> thats good
00:48 <****> wouldnt that mean it isnt big enough ?
00:48 <****> flexo: Go ahead.
00:48 <****> Free buffers 1 <- thats bad right ?
00:49 <****> not necessary bad, overtime, it will be full, but something not used can be removed without problem
00:49 <****> not removed, replaced is a better term
00:50 <****> is there any way to see whats in the buffer pool and somehow control it so it prioritizes for the one slow table we have ?
00:51 <****> I'm guessing i need to do some more learning to figure this out :P
00:54 <****> command line to pipe query output to a file ?
00:54 <****> tee
00:54 <****> got it\
01:03 <****> hi
01:04 <****> quick question
01:04 <****> I want to alter a table
01:04 <****> can I do that while other folks are using it?
01:04 <****> is that going to be an issue?
01:05 <****> cannot write when alter table, not sure if read is possible or not
01:05 <****> ok, but I don't have to lock the table
01:05 <****> and kick everyone off the db
01:05 <****> alter table will lock accordingly
01:06 <****> cool, thanks
01:06 <****> who can help me with encoding in my php script?
01:07 <****> this is not php channel
01:07 <****> kimseong: yes, but it seems to me that the reason in mysql base
01:09 <****> when I use function htmlspecialchars for my solution.. it works correctly only if i write string in file by hands.. for example.. htmlspecialchars('string')
01:09 <****> but when I read it from Mysql DB... it work not corectle
01:12 <****> under innodb status is this bad ?? RW-shared spins 2764621, OS waits 1852584; RW-excl spins 338413, OS waits 196361
01:12 <****> ie unreasonably high ?
01:13 <****> hello, i need to make my osCommerce with UTF-8
01:14 <****> could someone help me with this?
01:14 <****> Nut: no you don't
01:15 <****> chadmaynard, is there any problem with this?
01:15 <****> flexo: You probably need to register/identify with nickserv.
01:16 <****> is there some trick to getting non local roots to connect to mysql?
01:19 <****> I insert something into a table... and there is an autoincriment field there which I want to get back. How do I get that?
01:20 <****> After I insert?
01:24 <****> !man last_insert_id
01:24 <****> (Information Functions) : http://dev.mysql.com/doc/mysql/en/information-functions.html
01:25 <****> Thanks
01:27 <****> no ideas?
01:31 <****> Broccoly: mysql has its own authentication mechanism, just create the user with the appropriate priv
01:31 <****> kimseong: i did add the host i want to root, but it is being rejected
01:32 <****> what is the error message?
01:33 <****> kimseong: host is not allowed to connect to this mysql server
01:34 <****> i tried both by dns name and ip
01:34 <****> Broccoly: is the port open? any firewall?
01:34 <****> wait
01:34 <****> how did you create the user
01:34 <****> what host did you use for the user
01:35 <****> what do you mean what host?
01:36 <****> how did you create the mysql user?
01:36 <****> !man grant
01:36 <****> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
01:36 <****> if you don't know host, likely your user is not created correctly
01:36 <****> ohh i used the mysqladmin
01:37 <****> then i looked into the user table and everything looks good
01:38 <****> can mysqladmin create user?
01:39 <****> sure
01:39 <****> the gui administrator?
01:39 <****> it works as i added some other users
01:39 <****> I'm a little bit confused.. I've managed to log in as ''@'localhost' .. and I don't appear in the process list, nor do I seem to appear in the mysql.user table
01:39 <****> yeah the gui, other users work
01:39 <****> how do I get rid of this blank user?
Total 29 pages. You are browsing page 2/29.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last