James

Age: 35

Sysadmin (Windows, Linux) and DBA (SQL Server, MySQL).

Mar
3
awarded Yearling
Mar
3
awarded Yearling
Feb
27
awarded Notable Question
Jan
7
comment Mysql Windows Issues
@RolandoMySQLDBA It seems likely that there are other issues if the server wasn't upgraded properly. Would it make sense to (re-)run the mysql_upgrade script?
Jan
6
comment How can it take longer to replay a captured trace than to capture it
Can you narrow down what is taking longer, for example is each of the individual statements taking longer to execute or is it just that the aggregate time to replay the whole workload is longer? Is it possible that the extra time is accounted for by something other than query execution, such as connecting and authenticating?
Jan
1
comment The best MySQL Settings for 32GB RAM on a Dedicated Server
You probably don't want to assign 70% of the memory to InnoDB if a web server is already using most of the memory at times.
Jan
1
comment The best MySQL Settings for 32GB RAM on a Dedicated Server
Can you update this with some further details about how much memory MySQL and php-fpm are using, and how you're determining memory usage? Also, from what you posted, it sounds like you think php-fpm is using nearly all of the memory on the server, so I'm not sure what this has to do with MySQL. If there's free memory on the server, you might benefit from configuring MySQL to use more memory, but this won't solve your problem with php-fpm.
Dec
28
comment Show processlist / Max concurrent connections seem to max out at 131
What happens if you try to establish more than 131 connections? Do you get an error or does the attempt succeed?
Dec
28
comment How to save a copy of SQL Server book online in my Android tablet?
Now that the question isn't on DBA.se anymore, it might be worth clarifying for anyone not familiar with SQL Server that 'Books Online' is the name for Microsoft's SQL Server documentation.
Dec
27
comment What's the name for a script that can be executed any number of times with the same final result?
Neither is 'without errors', as far as I understand. I think the question could use some clarification in order to be answerable and potentially useful to people finding it through Google.
Dec
27
comment Rare error lasts only a second "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)" 146=ECONNREFUSED
Patching Solaris and/or MySQL, that is.
Dec
27
comment Rare error lasts only a second "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)" 146=ECONNREFUSED
@GeorgeBailey Yes I mentioned that the 146 appears to mean 'connection refused' on Solaris upthread. : ) The question you linked to has some good information about how to confirm that, though. Are you able to reproduce the problem with a simple repro script like the one in this bug report? If so, patching may fix it, as it has for others who posted in that report, but I don't have any insight into why it is occurring.
Dec
27
comment What's the name for a script that can be executed any number of times with the same final result?
I'm afraid I don't understand what the question is and suspect others won't either. Maybe you are asking about idempotence?
Dec
25
awarded Supporter
Dec
25
comment How to save a copy of SQL Server book online in my Android tablet?
OP is asking about converting files from the new help format (MSHI or MSHC) to CHM or another format that's easily read on Android. Maybe a better question for SuperUser if Android is the wrong site?
Dec
25
awarded Supporter
Dec
24
comment How to protect SQL Server from Hackers
Yes it sounds like your Windows Firewall is misconfigured. Maybe you have another more general rule that is allowing port 1433 (or allowing everything), or maybe Windows Firewall is disabled on the internet-facing NIC. It's hard to say without seeing the configuration. But this is really more of a question for ServerFault like Max says. Did you mean Windows 2008 R2, btw? 'RC' is Release Candidate, pre-release software for testing.
Dec
15
revised In case of multiple updates of the same record in a single transaction, how many versions are being stored?
Removed confusing formatting (part of sentence on separate line and in bold), fixed a couple minor spelling/grammar problems
Nov
29
revised Suggest better design pattern for reverse DNS lookups
added 74 characters in body
Nov
27
comment Connect to SQL Server from internet
I agree that you probably don't want to pass unencrypted database traffic over the internet. At the very least, you probably want to restrict port 1433 to trusted hosts. Anyhow, can you telnet to port 1433? Are you trying to use SQL Server authentication or Windows authentication? In most situations, Windows auth won't work over the internet unless you have a VPN.
1 2 3 4 5