209 reputation
13
bio website
location
age
visits member for 1 year, 9 months
seen Apr 9 at 19:03

Dec
24
awarded  Yearling
Sep
21
awarded  Custodian
Sep
20
comment High MySQL CPU usage, queries seem fine, not running ntp
Sure, just: set global long_query_time=0; However, I believe that if your clients are already connected, they won't pick up the setting until you disconnect/reconnect.
Sep
20
answered High MySQL CPU usage, queries seem fine, not running ntp
Sep
18
answered How do I persist recurring events?
Sep
18
comment What is the difference between 'two way transactional replication' and 'peer to peer replication'?
It would probably be helpful if you specified what database software you are talking about.
Sep
18
comment change encoding of database from latin1_swedish_ci to utf8
A common technique would be to create an identical table structure with the new collation and then do a INSERT INTO new_table_name SELECT * from old_table_name. Then you can inspect the results of the collation change.
Sep
18
comment change encoding of database from latin1_swedish_ci to utf8
I don't know, but I gave a +1 for being a good question. My sense is that Rolando is right, changing the databases default collation would only affect new tables being created, you'll still have to alter all your tables.
Sep
17
awarded  Supporter
Sep
17
reviewed Reviewed Maximum number of databases for single instance of PostgreSQL 9
Sep
17
answered Merge 2 tables and fetch data one by one
Jul
18
answered How to concatenate psql variables?
Jul
12
comment How to configure postgresql to use multiple cores?
Oh, I didn't even see that was the version that came up in Google. The text is the same even in the current 9.3 dev version: postgresql.org/docs/devel/static/connect-estab.html
Jul
12
answered MySQL, “columns partitioning” when multiple columns are individiually important
Jul
12
awarded  Teacher
Jul
12
answered How to configure postgresql to use multiple cores?