editEdit 4 (previous edits done over): Now regarding lower bounds (and cf. If kappaNoah's comments below)...
Say that a (possibly beyond 1st order) logic (I'm not sure of what the formal definition of "logic" is inaccessiblehere, but it doesn't really matter; I only use it in a limited sense below which is clear enough) is $\kappa$-compact iff whenever $T$ is a set-sized theory in that logic and weall subtheories of size ${<\kappa}$ have compactness at kappa with respect toa model, then $T$ also has a model.
Now consider the logic which includes the full first$\mathcal{L}$ in the (first order) language of set theory together with, where we have available a proper class of constant symbolsymbols, plus theand an extra predicate symbol (second orderwhich can be taken to code multiple predicates/functions below), together with the second-order statement “I``I am wellfounded”wellfounded''. (Remark: I mistakenly said "one" constant symbol in an earlier version; but I used set-many. Actually for the purposes below we can restrict the number of constants available to something like the cardinality of $V_{\kappa+2}$, thenwhere $\kappa$ is the cardinal in question.)
Claim: Let $\kappa$ be a cardinal and suppose that $\mathcal{L}$ as above is $\kappa$-compact. Then there is a measurable less than or equal to kappacardinal $\leq\kappa$. For consider the theory T in the language of set theory plus
Proof: First suppose that $\kappa$ is inaccessible. Consider the constant symbol mu$\mathcal{L}$-dot,theory $T$ which includes the full first order theory of $V_{\kappa+1}$ in parameters, the formulas “alpha < mu-dot < kappa”“$\alpha < \dot{\mu} < \kappa$”, for each alpha < kappa$\alpha < \kappa$, where $\dot{\mu}$ is a new constant, and the (2nd order) formula “I am wellfounded”. If that has$M$ is a (wellfounded) model of $T$, then it’s truly wellfoundednote that there is an elementary $j:V_{\kappa+1}\to M$, the critical point $\mathrm{crit}(j)$ of $j$ exists, and it follows there’sis a measurable less or equal to kappacardinal $\leq\kappa$. So we just need to see the small subtheories have models, but this easily follows easily from the inaccessibility of $\kappa$ (consider elementary substructures of $V_{\kappa+1}$).
edit 2Now suppose $\kappa$ is singular. Suppose we have compactness at Let $\kappa=\gamma^+$ for the language as above$f:\eta\to\kappa$ be cofinal, with constant symbol X. Then there is a measurable cardinalwhere $\leq\gamma$$\eta<\kappa$. For considerConsider the theory $T$ consisting of the first order theory in parameters of $H=\mathcal{H}_{\kappa}$$V_\kappa$, plus “I am wellfounded”and using function symbols $\dot{f},\dot{g}$, plus “Xthe statement "$\dot{f}:\eta\to\mathrm{Ord}$ is a wellorder of $\gamma$“ pluscofinal", the statements “$\alpha<$equations "$\dot{f}(\alpha)=\beta$" for each $\alpha,\beta$ such that $f(\alpha)=\beta$, and the ordertype of X”statement "$\dot{g}$ is a surjection from some ordinal onto $\mathrm{Ord}$", and (2nd order) "I am wellfounded". Then for each $\alpha<\kappa$. Clearly$\theta<\kappa$, each fragment $\bar{T}$ of size $<\kappa$ subtheory$\theta$ is satisfiable, since we may assume $\eta<\theta$, and we can find an elementary substructure of $(X,f\cap X)\preceq(V_\kappa,f)$ of cardinality $\theta$, with $\theta+1\subseteq X$, and then the transitive collapse $(M,\bar{f},g)$ is a model, where we take $g:\theta\to\mathrm{Ord}^M$ a surjection. But ifSo we get a wellfounded model $M$ satisfies$(M,f',g')$ of the wholefull theory then. Let $M\neq H$$j:V_\kappa\to M$ be the resulting elementary embedding. Note that $\mathrm{crit}(j)<\kappa$, because otherwise $f'=f$, so by cofinality, $\kappa=\mathrm{Ord}^M$, so $M=V_\kappa$, so $g':\gamma\to\kappa$ is a surjection for some $\gamma<\kappa$, contradiction. But then $\mathrm{crit}(j)<\kappa$ is measurable.
Finally suppose that $\gamma<\kappa\leq 2^\gamma$. Then consider the theory consisting of the first order theory in parameters of $X^M$$\mathcal{H}_{(2^\gamma)^+}$, "I am wellfounded", and the statement "$\dot{f}:\mathcal{P}(\gamma)\to\mathrm{Ord}$ is surjective". Any sub-theory of size $<\kappa$ is satisfiable (in fact, any sub-theory of size $\leq 2^\gamma$ is satisfiable), so we have an elementary $\pi:H\to M$a model, and note it hasgives a critical pointmeasurable $\leq\gamma$.
(This leaves $\omega$, whichbut it's easy to see this is measurableimpossible; also cf. Noah's comments in the question and below.)