#mysql
30 September 2007
Total 19 pages. You are browsing page 4/19.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:16 <****> ?
03:17 <****> hmm
03:19 <****> I added all priveledges to proper users by using grant ...
03:19 <****> and the server needs more RAM ...
03:20 <****> slavi1: www.day32.com/MySQL/tuning-primer.sh
03:20 <****> perhaps you can tune the config without adding ram in the meantime
03:21 <****> i like to make sure that the thread_cache table_cache and open-files are good
03:21 <****> mikegriffin: the server has 128MB of RAM ...
03:21 <****> heh
03:21 <****> maybe 16 2048 and 200000 respectively
03:21 <****> slavi1: ouch btw
03:21 <****> maybe we'll beg student gov't for a grant on a new server
03:22 <****> mikegriffin: bcacm.org :)
03:22 <****> and I inherited this server (would not have used gentoo on it if I was setting it up).
03:25 <****> slavi1: version of mysql?
03:25 <****> 5.0.42 I believe, gimmie a sec
03:25 <****> 5.0.44
03:25 <****> you should be able to do profiling
03:25 <****> and find bottlenecks
03:26 <****> how can I profile?
03:26 <****> set profiling = 1;
03:26 <****> set profiling_history_size = 15;
03:26 <****> show profiles;
03:26 <****> show profile ALL for query 2;
03:26 <****> etc
03:27 <****> should I really do it?
03:27 <****> if you are bored and want to optimize
03:27 <****> I want to add RAM either way, and I might reinstall the server from scratch
03:27 <****> nah, I'm not ;)
03:28 <****> well, I need to recompile the kernel at least, as the server hdd was moved to a diff system but I had to keep the network card from the old one, and the old one was someone's system.
03:28 <****> and I do like recompiling the kernel
03:29 <****> slavi1: i havent compiled a kernel in quite a while because apt is my friend
03:30 <****> mikegriffin: exactly, but I didn't set this server up
03:30 <****> this server took two days to set up (because of all the compilation taking place on a p2)
03:31 <****> haha
03:32 <****> it's running on a p3 500MHz ... but still not very nice :(
03:32 <****> same specs as my laptop
03:32 <****> ya pgbench is omitted from pkgsrc
03:32 <****> maybe I can get to the student gov't and ask for like a 500USD grant to build something a bit better (dual core, 1gb of RAM) or something
03:33 <****> postgresql-server needs a patch to include it
03:36 <****> hi there
03:37 <****> hello
03:38 <****> does anybody know why does it take years to finish this query "alter table domains add column zone_expiry datetime after account;" and how can check .. if there issue with database
03:40 <****> penda5, how big is the table?
03:41 <****> whopes wrong channel
03:41 <****> victori_: haha
03:43 <****> meant to post in #netbsd
03:44 <****> Simetrical, it has around 600K entries
03:45 <****> penda5, how long does it take?
03:45 <****> Simetrical, i read it copy the whole tables then do the alternation
03:46 <****> penda5, that's correct.
04:42 <****> I'm storing financial data. Should I use NUMERIC or DECIMAL?
04:43 <****> that depends on the precision you want to achieve.
04:43 <****> Hmm.. what are the degrees of precision for NUMERIC and DECIMAL.
04:43 <****> ? *
04:44 <****> decimal can be slightly more precise.
04:45 <****> Wait - is NUMERIC and DECIMAL supported on MyISAM?
04:54 <****> When I'm using DECIMAL, can I do like SELECT cashleft FROM item WHERE item_id = 2; and then decrease cashleft by 0.01 (one cent) and enter it back into the db?
04:58 <****> Why don't you use UPDATE item SET cashleft = cashleft - 0.01 WHERE item_id = 2; ?
04:58 <****> Simetrical: that might work better ;-) Thank you!
05:08 <****> I was searching for a tool to design database and represent it visually ?
05:25 <****> Hey all. I just accidentally deleted the contents in my DATA directory. Its a fresh install how do I repopulate it with a command? BTW This is mysql 5
05:28 <****> i have a .sql file i want to read, without really putting back in to a db. are there any cli / gui readers?
05:28 <****> n/m i figured it out
05:28 <****> via mysql online docs
05:28 <****> lastnode, vim?
05:28 <****> lastnode, gedit? Notepad?
05:29 <****> Microsoft Word? emacs?
05:29 <****> WordPad? TextPad? Notepad++?
05:29 <****> Simetrical: :D i mean something that also renders html as well?
05:29 <****> Er, SQL can't render to HTML.
05:30 <****> It's text and/or binary data, in general. You need to run it through a Web application to view it in HTML.
05:30 <****> Simetrical: how do i strip data such as \r\n\r\n
05:32 <****> lastnode, you have a few options. 1) Load it into a database and view it in the appropriate application. 2) Just read it, it's a bit ugly but you can still understand it. 3) Write a script.
05:33 <****> gotcha, thanks
05:54 <****> much love, i'm out
06:01 <****> I have 3 tables; students has id and other stuff, courses has id and other stuff, and enrollments has id, student_id, and course_id. What query can I use to find all the courses that a particular student is not enrolled in; that is, all the courses where enrollments does not contain an entry with that course_id and a specific student_id?
06:02 <****> que tal... alguien vivo?
06:04 <****> nor spelling bee champion.
06:13 <****> Anybody?
06:39 <****> is there some kind of CONTAINS operator in SQL syntax so I can say Table.field CONTAINS "some string" instead of Table.field = "some string"?
06:40 <****> are the mysql canned config files a decent starting point at optimizing a server?
06:43 <****> themoebius, use LIKE '%some string%'.
06:44 <****> Fr0zen_, decent enough, I suppose.
07:19 <****> is this? CREATE TABLE `ContractorMain` (
07:19 <****> `contractor_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
07:20 <****> the same as PRIMARY KEY pk_ContractorMain (contractor_id) ? sorry for the multi line
07:30 <****> does anyone know why foreign key restraints on an innodb table of about 4 million rows is massively slow?
07:36 <****> oreonix, because it has to do lots of extra checks every time the table data is changed? If you need performance, disable foreign key constraints.
07:41 <****> why do I get 0 results if one of the tables I select from is empty? SELECT Content.*, Event.* FROM Content, Event;
07:41 <****> the event table is empty, but content is not, yet i still get no results
07:41 <****> but as soon as i add a record to Event I get all results as I should.
07:58 <****> Hopefully themoebius realized the issue.
07:59 <****> Even a cartesian product can be pretty small.
08:11 <****> a
08:11 <****>fields_arr['tags']).'%\') AND ';
08:11 <****> }
08:11 <****> instead of using AND i would like to consist of video_title
08:11 <****> what operators should i use?
08:12 <****> huh? It would help if you could paste the actual SQL query, not the perl or php or whatever that is
Total 19 pages. You are browsing page 4/19.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last